View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
10519Bug reportsInstallationpublic2016-02-18 09:53
ReporterFrancoisH Assigned Toc_schmitz  
PriorityurgentSeveritycrash 
Status closedResolutionfixed 
Product Version2.50.x 
Fixed in Version2.50.x 
Summary10519: Error when populating database on fresh install
Description

When populating the database during standard and fresh installation process, I get this error : SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; (see in other info for the complete error message)

Steps To Reproduce
  • Just proceed with installation.
Additional Information

Please fix the following input errors:

There were errors when trying to populate the database:
Executing: CREATE TABLE ls_participant_attribute_names_lang ( attribute_id int(11) NOT NULL, attribute_name varchar(30) NOT NULL, lang varchar(255) NOT NULL, PRIMARY KEY (attribute_id,lang) ) ENGINE=MYISAM CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; failed! Reason: exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes' in /home/francoisr/www-sf/sondage/framework/db/CDbCommand.php:358 Stack trace: #0 /home/francoisr/www-sf/sondage/application/controllers/InstallerController.php(990): CDbCommand->execute() #1 /home/francoisr/www-sf/sondage/application/controllers/InstallerController.php(960): InstallerController->executeSQLFile('/home/francoisr...', 'ls') #2 /home/francoisr/www-sf/sondage/application/controllers/InstallerController.php(577): InstallerController->_setup_tables('/home/francoisr...') #3 /home/francoisr/www-sf/sondage/application/controllers/InstallerController.php(79): InstallerController->stepPopulateDb() #4 /home/francoisr/www-sf/sondage/framework/web/CWebApplication.php(282): InstallerController->run('populatedb') #5 /home/francoisr/www-sf/sondage/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/popul...') #6 /home/francoisr/www-sf/sondage/framework/base/CApplication.php(184): CWebApplication->processRequest() #7 /home/francoisr/www-sf/sondage/index.php(211): CApplication->run() #8 {main}

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)160217
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMySQL 5.5
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.2.22
PHP Version5.6.17

Users monitoring this issue

There are no users monitoring this issue.

Activities

ecocitizen

ecocitizen

2016-02-18 01:23

reporter   ~35373

I had the same problem

jbeima

jbeima

2016-02-18 01:25

reporter   ~35374

Here too...

duemont

duemont

2016-02-18 01:56

reporter   ~35375

Very annoying and embarrassing bug! So I fixed it by myself.

/var/www/html/limesurvey/installer/sql/create-mysql.sql

  • lang varchar(255) NOT NULL,
  • lang varchar(200) NOT NULL,

255 * 4 bytes > 1000 max key length.

200 is just a hotfix for now. I don't know what kind of values you prefer.

c_schmitz

c_schmitz

2016-02-18 09:47

administrator   ~35380

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

c_schmitz

c_schmitz

2016-02-18 09:53

administrator   ~35382

2.50+ Build 160218 released

Related Changesets

LimeSurvey: master e025e451

2016-02-18 08:47:06

c_schmitz

Details Diff
Fixed issue 10519: Error when populating database on fresh install Affected Issues
10519
mod - application/controllers/InstallerController.php Diff File
mod - installer/sql/create-mysql.sql Diff File
mod - installer/sql/create-pgsql.sql Diff File

Issue History

Date Modified Username Field Change
2016-02-18 00:09 FrancoisH New Issue
2016-02-18 01:23 ecocitizen Note Added: 35373
2016-02-18 01:25 jbeima Note Added: 35374
2016-02-18 01:56 duemont Note Added: 35375
2016-02-18 09:47 c_schmitz Changeset attached => LimeSurvey master e025e451
2016-02-18 09:47 c_schmitz Note Added: 35380
2016-02-18 09:47 c_schmitz Assigned To => c_schmitz
2016-02-18 09:47 c_schmitz Resolution open => fixed
2016-02-18 09:47 c_schmitz Status new => resolved
2016-02-18 09:47 c_schmitz Fixed in Version => 2.5
2016-02-18 09:53 c_schmitz Note Added: 35382
2016-02-18 09:53 c_schmitz Status resolved => closed