Welcome, Guest
Username: Password: Remember me

TOPIC: Update problem (1.89 - 1.90)

Update problem (1.89 - 1.90) 3 years 10 months ago #52755

  • giopas
  • giopas's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
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: 3 years 10 months ago by giopas.
The administrator has disabled public write access.

Re:Update problem (1.89 - 1.90) 3 years 10 months ago #52834

  • c_schmitz
  • c_schmitz's Avatar
  • NOW ONLINE
  • LimeSurvey Team
  • Posts: 807
  • Thank you received: 115
  • Karma: 93
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.
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.

Re:Update problem (1.89 - 1.90) 3 years 10 months ago #52842

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

Re:Update problem (1.89 - 1.90) 3 years 10 months ago #52864

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6429
  • Thank you received: 840
  • Karma: 249
At starting of the update, LimeSurvey make a database backup, you can found it at limesurvey-directory/temp/......sql

:)
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.129 seconds
Donation Image