Check out the LimeSurvey source code on GitHub!

Update problem (1.89 - 1.90)

More
6 years 1 month ago - 6 years 1 month ago #52755 by giopas
Hi guys,

I was updating my Limesurvey, but when I go on http://[site]/admin/admin.php I receive the following message.

The LimeSurvey database is being upgraded (2010-11-22 22:57:54) . Please be patient...

Moving user templates to new location at C:\www-root\[site]\www\survey\upload\templates...
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Attention:The following upgrades will update your MySQL Database collations. This may take some time.
If for any reason you should get a timeout just re-run the upgrade procedure. The updating will continue where it left off.

. . . . .
Executing.....INSERT INTO `lime_settings_global` VALUES ('SessionName', 'ls74774484574743389884')...Failed! Reason: Duplicate entry 'SessionName' for key 1.
Executing.....ALTER TABLE `lime_surveys` ADD `printanswers` CHAR(1) default 'N' AFTER allowsave...Failed! Reason: Duplicate column name 'printanswers'
Executing.....ALTER TABLE `lime_surveys` ADD `listpublic` CHAR(1) default 'N' AFTER `datecreated`...Failed! Reason: Duplicate column name 'listpublic'
Executing.....CREATE TABLE `lime_quota` ( `id` int(11) NOT NULL auto_increment, `sid` int(11) default NULL, `qlimit` int(8) default NULL, `name` varchar(255) collate utf8_unicode_ci default NULL, `action` int(2) default NULL, `active` int(1) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci...Failed! Reason: Table 'lime_quota' already exists
Executing.....CREATE TABLE `lime_quota_members` ( `id` int(11) NOT NULL auto_increment, `sid` int(11) default NULL, `qid` int(11) default NULL, `quota_id` int(11) default NULL, `code` varchar(5) collate utf8_unicode_ci default NULL, PRIMARY KEY (`id`), UNIQUE KEY `sid` (`sid`,`qid`,`quota_id`,`code`) ) ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci...Failed! Reason: Table 'lime_quota_members' already exists. . . . . . .
Executing.....ALTER TABLE `lime_surveys` ADD `htmlemail` CHAR(1) default 'N'...Failed! Reason: Duplicate column name 'htmlemail'
Executing.....ALTER TABLE `lime_surveys` ADD `tokenanswerspersistence` CHAR(1) default 'N'...Failed! Reason: Duplicate column name 'tokenanswerspersistence'
Executing.....ALTER TABLE `lime_surveys` ADD `usecaptcha` CHAR(1) default 'N'...Failed! Reason: Duplicate column name 'usecaptcha'
Executing.....ALTER TABLE `lime_users` ADD `htmleditormode` CHAR(7) default 'default'...Failed! Reason: Duplicate column name 'htmleditormode'
Executing.....CREATE TABLE `lime_templates_rights` ( `uid` int(11) NOT NULL, `folder` varchar(255) NOT NULL, `use` int(1) NOT NULL, PRIMARY KEY (`uid`,`folder`) ) ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci...Failed! Reason: Table 'lime_templates_rights' already exists
Executing.....CREATE TABLE `lime_templates` ( `folder` varchar(255) NOT NULL, `creator` int(11) NOT NULL, PRIMARY KEY (`folder`) ) ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci...Failed! Reason: Table 'lime_templates' already exists. .
Executing.....ALTER TABLE `lime_surveys` ADD `bounce_email` text...Failed! Reason: Duplicate column name 'bounce_email'
Executing.....ALTER TABLE `lime_users` ADD `superadmin` tinyint(1) NOT NULL default '0'...Failed! Reason: Duplicate column name 'superadmin'
Executing.....UPDATE `lime_users` SET `superadmin`=1 where (create_survey=1 AND create_user=1 AND move_user=1 AND delete_user=1 AND configurator=1)...Failed! Reason: Unknown column 'move_user' in 'where clause'
Executing.....ALTER TABLE `lime_users` DROP COLUMN `move_user`...Failed! Reason: Can't DROP 'move_user'; check that column/key exists
Executing.....ALTER TABLE `lime_questions` ADD `lid1` integer NOT NULL default '0'...Failed! Reason: Duplicate column name 'lid1'. .
Executing.....create index `assessments_idx2` on `lime_assessments` (`sid`)...Failed! Reason: Duplicate key name 'assessments_idx2'
Executing.....create index `assessments_idx3` on `lime_assessments` (`gid`)...Failed! Reason: Duplicate key name 'assessments_idx3'
Executing.....create index `conditions_idx2` on `lime_conditions` (`qid`)...Failed! Reason: Duplicate key name 'conditions_idx2'
Executing.....create index `groups_idx2` on `lime_groups` (`sid`)...Failed! Reason: Duplicate key name 'groups_idx2'
Executing.....create index `questions_idx2` on `lime_questions` (`sid`)...Failed! Reason: Duplicate key name 'questions_idx2'
Executing.....create index `questions_idx3` on `lime_questions` (`gid`)...Failed! Reason: Duplicate key name 'questions_idx3'
Executing.....create index `question_attributes_idx2` on `lime_question_attributes` (`qid`)...Failed! Reason: Duplicate key name 'question_attributes_idx2'
Executing.....create index `quota_idx2` on `lime_quota` (`sid`)...Failed! Reason: Duplicate key name 'quota_idx2'
Executing.....create index `saved_control_idx2` on `lime_saved_control` (`sid`)...Failed! Reason: Duplicate key name 'saved_control_idx2'
Executing.....create index `user_in_groups_idx1` on `lime_user_in_groups` (`ugid`, `uid`)...Failed! Reason: Duplicate key name 'user_in_groups_idx1'
Executing.....create index `answers_idx2` on `lime_answers` (`sortorder`)...Failed! Reason: Duplicate key name 'answers_idx2'
Executing.....create index `conditions_idx3` on `lime_conditions` (`cqid`)...Failed! Reason: Duplicate key name 'conditions_idx3'
Executing.....create index `questions_idx4` on `lime_questions` (`type`)...Failed! Reason: Duplicate key name 'questions_idx4'. .
Executing.....ALTER TABLE `lime_surveys` ADD `startdate` DATETIME...Failed! Reason: Duplicate column name 'startdate'. .
Executing.....ALTER TABLE `lime_conditions` ADD `scenario` integer NOT NULL default '1' AFTER `qid`...Failed! Reason: Duplicate column name 'scenario'. .
Executing.....ALTER TABLE `lime_surveys` ADD `publicstatistics` varchar(1) NOT NULL default 'N'...Failed! Reason: Duplicate column name 'publicstatistics'.
Executing.....ALTER TABLE `lime_surveys` ADD `publicgraphs` varchar(1) NOT NULL default 'N'...Failed! Reason: Duplicate column name 'publicgraphs'.
Executing.....ALTER TABLE `lime_users` ADD `one_time_pw` blob...Failed! Reason: Duplicate column name 'one_time_pw'
Executing.....ALTER TABLE `lime_surveys` ADD `assessments` varchar(1) NOT NULL default 'N'...Failed! Reason: Duplicate column name 'assessments'
Executing.....ALTER TABLE `lime_answers` ADD `assessment_value` int(11) NOT NULL default '0'...Failed! Reason: Duplicate column name 'assessment_value'
Executing.....ALTER TABLE `lime_labels` ADD `assessment_value` int(11) NOT NULL default '0'...Failed! Reason: Duplicate column name 'assessment_value'. . .
Executing.....ALTER TABLE `lime_assessments` ADD `language` varchar(20) NOT NULL default 'en'...Failed! Reason: Duplicate column name 'language'.
Executing.....update `lime_assessments` set `message`=concat(replace(`message`,'/''',''''),'<br /><a href="',`link`,'">',`link`,'</a>')...Failed! Reason: Unknown column 'link' in 'field list'
Executing.....ALTER TABLE `lime_assessments` DROP COLUMN `link`...Failed! Reason: Can't DROP 'link'; check that column/key exists.
Executing.....ALTER TABLE `lime_surveys_languagesettings` ADD `surveyls_url` varchar(255)...Failed! Reason: Duplicate column name 'surveyls_url'
Executing.....ALTER TABLE `lime_surveys_languagesettings` ADD `surveyls_endtext` text...Failed! Reason: Duplicate column name 'surveyls_endtext'
Executing.....update `lime_surveys_languagesettings` set `surveyls_url`=(select `url` from `lime_surveys` where `sid`=`lime_surveys_languagesettings`.`surveyls_survey_id`)...Failed! Reason: Unknown column 'url' in 'field list'
Executing.....ALTER TABLE `lime_surveys` DROP COLUMN `url`...Failed! Reason: Can't DROP 'url'; check that column/key exists.
Executing.....ALTER TABLE `lime_surveys` ADD `usetokens` varchar(1) NOT NULL default 'N'...Failed! Reason: Duplicate column name 'usetokens'
Executing.....ALTER TABLE `lime_surveys` ADD `attributedescriptions` TEXT...Failed! Reason: Duplicate column name 'attributedescriptions'
Executing.....ALTER TABLE `lime_surveys` DROP COLUMN `attribute1`...Failed! Reason: Can't DROP 'attribute1'; check that column/key exists
Executing.....ALTER TABLE `lime_surveys` DROP COLUMN `attribute2`...Failed! Reason: Can't DROP 'attribute2'; check that column/key exists. . .
Executing.....ALTER TABLE `lime_quota` ADD `autoload_url` int(1) NOT NULL default '0'...Failed! Reason: Duplicate column name 'autoload_url'
Executing.....CREATE TABLE `lime_quota_languagesettings` ( `quotals_id` int(11) NOT NULL auto_increment, `quotals_quota_id` int(11) NOT NULL default '0', `quotals_language` varchar(45) NOT NULL default 'en', `quotals_name` varchar(255) collate utf8_unicode_ci default NULL, `quotals_message` text NOT NULL, `quotals_url` varchar(255), `quotals_urldescrip` varchar(255), PRIMARY KEY (`quotals_id`) ) ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci...Failed! Reason: Table 'lime_quota_languagesettings' already exists.
Executing.....ALTER TABLE `lime_surveys_languagesettings` ADD `surveyls_dateformat` int(1) NOT NULL default '1'...Failed! Reason: Duplicate column name 'surveyls_dateformat'
Executing.....ALTER TABLE `lime_users` ADD `dateformat` int(1) NOT NULL default '1'...Failed! Reason: Duplicate column name 'dateformat'.
Executing.....UPDATE `lime_surveys` set `expires`=null where `useexpiry`='N'...Failed! Reason: Unknown column 'useexpiry' in 'where clause'
Executing.....ALTER TABLE `lime_surveys` DROP COLUMN `useexpiry`...Failed! Reason: Can't DROP 'useexpiry'; check that column/key exists. . . . .
Executing.....ALTER TABLE `lime_surveys` ADD `emailresponseto` text DEFAULT NULL...Failed! Reason: Duplicate column name 'emailresponseto'.
Executing.....ALTER TABLE `lime_surveys` ADD `tokenlength` tinyint(2) NOT NULL default '15'...Failed! Reason: Duplicate column name 'tokenlength'. . . . . .
Executing.....ALTER TABLE `lime_questions` ADD `parent_qid` integer NOT NULL default '0'...Failed! Reason: Duplicate column name 'parent_qid'
Executing.....ALTER TABLE `lime_answers` ADD `scale_id` tinyint NOT NULL default '0'...Failed! Reason: Duplicate column name 'scale_id'
Executing.....ALTER TABLE `lime_questions` ADD `scale_id` tinyint NOT NULL default '0'...Failed! Reason: Duplicate column name 'scale_id'
Executing.....ALTER TABLE `lime_questions` ADD `same_default` tinyint NOT NULL default '0' COMMENT 'Saves if user set to use the same default value across languages in default options dialog'...Failed! Reason: Duplicate column name 'same_default'.
Executing.....CREATE TABLE `lime_defaultvalues` ( `qid` int(11) NOT NULL default '0', `scale_id` int(11) NOT NULL default '0', `sqid` int(11) NOT NULL default '0', `language` varchar(20) NOT NULL, `specialtype` varchar(20) NOT NULL default '', `defaultvalue` text, PRIMARY KEY (`qid` , `scale_id`, `language`, `specialtype`, `sqid` ) ) ENGINE=myISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci...Failed! Reason: Table 'lime_defaultvalues' already existsUnknown column 'a.default_value' in 'where clause':select a.*, q.sid, q.gid from lime_answers a,lime_questions q where a.qid=q.qid and q.type in ('L','O','!') and a.default_value='Y'


If I then rename install/ folder to _install/ I still can't log in limesurvey because it still try to update db.

Maybe I am tired, but what am I doing wrong? :/

Thanks,
giopas
Last Edit: 6 years 1 month ago by giopas.

Please Log in to join the conversation.

More
6 years 1 month ago #52834 by c_schmitz
There is no 1.89. And this looks like the update was executed twice.
Maybe you did not upload all files completely.
Restore the database from your backup and try again.

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
6 years 1 month ago #52842 by giopas
Yes, actually maybe it is not a 1.89 but some pre-release 1.90 (back in Mars 2010).

Do you mean to run the database backup (I haven't :) ... yes I know, it's my fault) or just the file backup?

Thanks,

giopas

Please Log in to join the conversation.

More
6 years 1 month ago #52864 by DenisChenu
At starting of the update, LimeSurvey make a database backup, you can found it at limesurvey-directory/temp/......sql

:)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).

Please Log in to join the conversation.

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