09263: Error (CDbCommand failed) on DB update - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

09263	Bug reports	Other	public	2014-09-27 15:14	2014-10-14 00:29

Reporter	mfaber	Assigned To	c_schmitz
Priority	normal	Severity	block
Status	closed	Resolution	fixed
Product Version	2.06+
Fixed in Version	2.06+

Summary	09263: Error (CDbCommand failed) on DB update
Description	When updating a git version from march to a recent one, the following error appears after clicking "yes" to the database update: LimeSurvey@GIT The LimeSurvey database is being upgraded (2014-09-27 15:06:03) . Please be patient... An non-recoverable error happened during the update. Error details: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set email=substr(email,0,254)' at line 1
Additional Information	Probably related to line 1311 in update_helper: Yii::app()->db->createCommand("UPDATE {$sTableName} set email={$sSubstringCommand}(email,0,254)")->execute();
Tags	No tags attached.

Bug heat	4
Complete LimeSurvey version number (& build)	140927
I will donate to the project if issue is resolved	No
Browser	FF
Database type & version	MySQL 5.0.10
Server OS (if known)	Win7
Webserver software & version (if known)	Apache 2.4.7
PHP Version	PhP 5.4.19

User List	There are no users monitoring this issue.

mfaber 2014-09-27 15:42 reporter ~30708	"git blame" blames it on: 9e2c3763 Carsten Schmitz 09.09.2014 Changed feature 09206: Extended firstname, lastname to 150 characters and email fields to 254 characters on token tables and participant database to match width Changed feature: Token attributes are now of type text {

c_schmitz 2014-10-14 00:29 administrator ~30793	Fix committed to 2.06 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=14561

Date Modified	Username	Field	Change
2014-09-27 15:14	mfaber	New Issue
2014-09-27 15:14	mfaber	Issue generated from: 09262
2014-09-27 15:38	mfaber	Relationship added	related to 09206
2014-09-27 15:38	mfaber	Relationship deleted	related to 09206
2014-09-27 15:42	mfaber	Note Added: 30708
2014-10-14 00:27	c_schmitz	Status	new => closed
2014-10-14 00:27	c_schmitz	Assigned To	=> c_schmitz
2014-10-14 00:27	c_schmitz	Resolution	open => fixed
2014-10-14 00:27	c_schmitz	Fixed in Version	=> 2.06+
2014-10-14 00:29	c_schmitz	Changeset attached	=> LimeSurvey 2.06 bab96b6b
2014-10-14 00:29	c_schmitz	Note Added: 30793

LimeSurvey: 2.06 bab96b6b 2014-10-13 22:28:45 c_schmitz Details Diff	Fixed issue 09263: Error (CDbCommand failed) on DB update		Affected Issues 09263
	mod - application/helpers/update/updatedb_helper.php		Diff File