Check out the LimeSurvey source code on GitHub!

Installing from backup

More
5 years 8 months ago #61069 by jeantoul
I would like to reinstall limesurvey from the backup that comfort update created. However, when I copy the files to the server, and then import the sql file, I get lots of errors.

Apparently it is saved in a different format and cannot be parsed. No matter which format I choose to import the .sql file in, I get this error, or something similar. Please halp!

Error
SQL query:

CREATE TABLE lime_old_tokens_28755_20110203131347(

`tid` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`firstname` VARCHAR( 40 ) ,
`lastname` VARCHAR( 40 ) ,
`email` TEXT,
`emailstatus` TEXT,
`token` VARCHAR( 36 ) ,
`language` VARCHAR( 25 ) ,
`sent` VARCHAR( 17 ) DEFAULT 'N',
`remindersent` VARCHAR( 17 ) DEFAULT 'N',
`remindercount` INT( 11 ) DEFAULT '0',
`completed` VARCHAR( 17 ) DEFAULT 'N',
`validfrom` DATETIME,
`validuntil` DATETIME,
`mpid` INT( 11 ) ,
PRIMARY KEY ( tid ) ,
KEY lime_tokens_28755_idx( token ) ,
KEY idx_lime_tokens_28755_efl( email, firstname, lastname )
);

MySQL said:

#1170 - BLOB/TEXT column 'email' used in key specification without a key length

Please Log in to join the conversation.

More
5 years 8 months ago - 5 years 8 months ago #61076 by c_schmitz
Hi!

Edit the backup file (make a a copy first), and if you look at the above statement change the line

KEY idx_lime_tokens_28755_efl( email, firstname, lastname )

to

KEY idx_lime_tokens_28755_efl( email (200), firstname, lastname )

Same for other places where this problem occurs.

Best regards

Carsten Schmitz
LimeSurvey project leader
Last Edit: 5 years 8 months ago by c_schmitz.

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form