Check out the LimeSurvey source code on GitHub!

Problem when updating from v1.71+ to 1.90+

More
6 years 4 months ago #50115 by Feiyue
I had not been using my survey-tool for a while but was about too again and felt that I should update before going any futher. The installation on the server was version 1.71+ and I tried updating to current version 1.90+ build 9130.

I tried following the update instructions (The thorough way) exactly, but when i get to the final step "Modify the new database tables and finish the installation" and navigate to "/admin/admin.php" the browser starts loading and then i just get the following error message:


The LimeSurvey database is being upgraded (2010-10-06 11:30:08) . Please be patient...

Moving user templates to new location at /home/xxxxxx/public_html/survey/upload/templates...

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 exists. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Fatal error: Maximum execution time of 30 seconds exceeded in /home/xxxxxx/public_html/survey/admin/classes/core/sha256.php on line 190


The xxxxxx:s above is my databasename.
Any idea what might have gone wrong and what I could try to do to fix it?

Please Log in to join the conversation.

More
6 years 4 months ago #50122 by Mazi
The update script runs into a time limit. Raise max execution time at php.ini or ask your provider/admin to do so.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
6 years 4 months ago #50140 by DenisChenu
I don't know, but updating from 1.70 to 1.80 make a lot of step, maybe it's possible to do update 1.0->1.8->1.9

sourceforge.net/projects/limesurvey/files/

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.

More
6 years 4 months ago #50149 by Feiyue
Mazi wrote:

The update script runs into a time limit. Raise max execution time at php.ini or ask your provider/admin to do so.

Yeah i saw that i got a time limit error message but I just got the feeling that the earlier error messages didn't relate to the time limit but something else?

Shnoulle wrote:

I don't know, but updating from 1.70 to 1.80 make a lot of step, maybe it's possible to do update 1.0->1.8->1.9

sourceforge.net/projects/limesurvey/files/

Sure i could try updating in steps I just didn't try it because it didn't say anything in the update instructions about this beeing a problem. In fact the headline of the update instruction is: "Upgrading from version 1.45 or later to the latest 1.xx series".

How many steps do you think are necessary, 1.71 > 1.80 > 1.90?

Please Log in to join the conversation.

More
6 years 4 months ago #50160 by DenisChenu
I don't know,

If you can up your time script more than 30 s is the best (30s is very cheap)

Maybe just 120s

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.

More
6 years 4 months ago #50162 by Feiyue
I'll up the time limit and be back with results!

Please Log in to join the conversation.

More
6 years 4 months ago #50192 by Mazi
Upading from 1.71 to the latest version should be possible.

Raise limit because lots of SQL queries have to be made. Also make backups.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
6 years 4 months ago #50305 by Feiyue
Mazi wrote:

Upading from 1.71 to the latest version should be possible.

Raise limit because lots of SQL queries have to be made. Also make backups.

Backups were made before I started the update so that shouldn't be a problem.

I got my webhost to extend my maximum_execution_time and that seems to have done the trick or at least help me get rid of the final time-out error message.

Now i get the same initial error messages but at least the final message is "Database has been successfully upgraded":

Current error message:
Warning: Spoiler! [ Click to expand ]


I can now log in to limesurvey and when I do a datebase health check I'm told that everyting looks fine.
Should I be worried about the initial error messages that I got?

Please Log in to join the conversation.

More
6 years 4 months ago #50327 by DenisChenu
Feiyue wrote:

Should I be worried about the initial error messages that I got?

I don't think , it's certainly due to multiple update trye :)

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.

More
6 years 4 months ago #50334 by Feiyue
Shnoulle wrote:

I don't think , it's certainly due to multiple update trye :)

OK then I consider myself updated! :cheer:
Thanks a lot for your help guys!

Please Log in to join the conversation.

More
6 years 4 months ago #50336 by Mazi
Which error message?


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
6 years 4 months ago #50376 by Feiyue
Mazi wrote:

Which error message?

Well I still got some error messages, you can see in them in post #50305 in the spoiler.

But the final error message "Fatal error: Maximum execution time of 30 seconds exceeded in /home/xxxxxx/public_html/survey/admin/classes/core/sha256.php on line 190" did change to "Database has been successfully upgraded to version 143".

Please Log in to join the conversation.

More
6 years 4 months ago #50379 by Mazi
These were just error messages due to multiple updating. Your update seems to be done and Limesurvey should run fine.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

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