View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
09579Bug reportsComfortUpdatepublic2015-03-19 18:542015-12-09 09:34
ReporterJMI Assigned Toc_schmitz  
PriorityhighSeveritycrash 
Status closedResolutionunable to reproduce 
Product Version2.06alpha 
Summary09579: system.db.CDbCommand MYSQL -> 2.06a1 Build 150305
Description

CDbCommand::execute() failed: SQLSTATE[42000]: Syntax error or access
violation: 1071 Specified key was too long; max key length is 1000 bytes.
The SQL statement executed was: ALTER TABLE lime_tokens_94223 CHANGE
lastname lastname varchar(150) .

Erreur non récupérable durant la mise à jour. Détails de cette erreur :

CDbCommand n'a pas pu exécuter la commande SQL : SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

Steps To Reproduce

DEBIAN Wheezy
MySQL 5.5.41
PHP 5.4.36
2.05+ (150310) (stable)
Confort Update, last step with the MySQL update

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)2.06a1 Build 150305
I will donate to the project if issue is resolvedNo
BrowserIceWeasel 31.5
Database type & versionMySQL 5.5.41
Server OS (if known)DEBIAN Wheezy
Webserver software & version (if known)Apache 2.2.22.13
PHP VersionPHP 5.4.36

Relationships

Relationship GraphDependency Graph
related to 09949 closedc_schmitz unable to upgrade due to error in migration script upgradeTokenTables179 

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2015-03-20 09:15

administrator   ~31869

This might be caused by additional indexes you did set manually on your tokens table.
c_schmitz

c_schmitz

2015-06-16 10:12

administrator   ~32378

I apologize for my incorrect analysis. This will be fixed in the next 2.06 stable version and update should properly run then.

Issue History

Date Modified Username Field Change
2015-03-19 18:54 JMI New Issue
2015-03-19 18:54 JMI Status new => assigned
2015-03-19 18:54 JMI Assigned To => c_schmitz
2015-03-20 09:15 c_schmitz Note Added: 31869
2015-03-20 09:15 c_schmitz Status assigned => closed
2015-03-20 09:15 c_schmitz Resolution open => unable to reproduce
2015-06-16 10:12 c_schmitz Note Added: 32378
2015-12-09 09:34 c_schmitz Relationship added related to 09949