View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
10572Bug reportsInstallationpublic2016-04-06 11:36
Reporterautopoiesis Assigned Toc_schmitz  
PrioritynormalSeveritycrash 
Status closedResolutionfixed 
Product Version2.06+ 
Fixed in Version2.50.x 
Summary10572: Error during update from 2.06+ to 2.5
Description

We get the following error message during the upate from 2.06+ to 2.5:

"CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs"

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)14cc77aaff5c28a62cdcfe7507bb
I will donate to the project if issue is resolvedNo
BrowserChrome 48
Database type & versionmysql 5.5.44
Server OS (if known)ubuntu4.13
Webserver software & version (if known)Apache/2.4.7 (Ubuntu)
PHP Version5.5.9-1

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2016-02-24 11:36

administrator   ~35646

Can you activate debug mode in /application/config/config.php before update and see what detailed error on update you get?

c_schmitz

c_schmitz

2016-02-29 17:18

administrator   ~35798

Pretty please?

autopoiesis

autopoiesis

2016-03-01 09:40

reporter   ~35806

Sorry for the late reply.

We were able to solve the error somehow:

It was due to the fact that the token tables for 2 surveys exceeded the maximum table size. The update script was trying to increase the size of ‘firstname’ and ‘lastname’ to 150 char, which was failing due to total table size.

The only way to solve the issue was to remove attribute_84 from the tokens.

c_schmitz

c_schmitz

2016-04-04 16:01

administrator   ~36980

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=18294

c_schmitz

c_schmitz

2016-04-04 16:02

administrator   ~36981

Update is now more lenient and will skip the field size extension as token tables usually only have a limited lifetime.

c_schmitz

c_schmitz

2016-04-06 11:36

administrator   ~37032

Version 2.50+ Build 160405 released

Related Changesets

LimeSurvey: master 44169385

2016-04-04 14:01:41

c_schmitz

Details Diff
Fixed issue 10572: Error during update when updating token table field sizes Affected Issues
10572
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2016-02-24 10:43 autopoiesis New Issue
2016-02-24 11:36 c_schmitz Note Added: 35646
2016-02-24 11:36 c_schmitz Assigned To => c_schmitz
2016-02-24 11:36 c_schmitz Status new => feedback
2016-02-29 17:18 c_schmitz Note Added: 35798
2016-03-01 09:40 autopoiesis Note Added: 35806
2016-03-01 09:40 autopoiesis Status feedback => assigned
2016-04-04 16:01 c_schmitz Changeset attached => LimeSurvey master 44169385
2016-04-04 16:01 c_schmitz Note Added: 36980
2016-04-04 16:01 c_schmitz Resolution open => fixed
2016-04-04 16:02 c_schmitz Note Added: 36981
2016-04-04 16:02 c_schmitz Status assigned => resolved
2016-04-04 16:02 c_schmitz Fixed in Version => 2.5
2016-04-06 11:36 c_schmitz Note Added: 37032
2016-04-06 11:36 c_schmitz Status resolved => closed