LimeSurvey forums :: Topic: Update problem (1.89

Welcome, Guest

TOPIC: Update problem (1.89 - 1.90)

Update problem (1.89 - 1.90) 2 years 6 months ago #52755

giopas
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: 2 years 6 months ago by giopas.

The administrator has disabled public write access.

Re:Update problem (1.89 - 1.90) 2 years 6 months ago #52834

c_schmitz OFFLINE LimeSurvey Team Posts: 618 Thank you received: 73 Karma: 78	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) 2 years 6 months ago #52842

giopas 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) 2 years 6 months ago #52864

DenisChenu OFFLINE Moderator Lime Posts: 4521 Thank you received: 472 Karma: 168	At starting of the update, LimeSurvey make a database backup, you can found it at limesurvey-directory/temp/......sql
	Bug report \| LimeSurvey Version 2.05 beta 2 released! \| Please, read the documentation \| La doc en français à besoin de traducteurs et traductrices Denis Chenu Libriste convaincu: Official LimeSurvey Partner: Sondages Pro : Vos enquêtes sur internet Web development : Développement de Logiciels... The administrator has disabled public write access.

Forum

English support forums

Installation & update issues

Update problem (1.89 - 1.90)