Welcome, Guest
Username: Password: Remember me

TOPIC: Installing from backup

Installing from backup 3 years 6 months ago #61069

  • jeantoul
  • jeantoul's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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
The administrator has disabled public write access.

Re: Installing from backup 3 years 6 months ago #61076

  • c_schmitz
  • c_schmitz's Avatar
  • NOW ONLINE
  • LimeSurvey Team
  • Posts: 819
  • Thank you received: 116
  • Karma: 93
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.
Support us, too. Donate to the LimeSurvey project and help keep us going!
Last Edit: 3 years 6 months ago by c_schmitz.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.092 seconds
Donation Image