- Posts: 1
- Thank you received: 0
Comfort Upgrade Failed
An non-recoverable error happened during the update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'default\', `created` datetime not null, `first_read` datetime null ) ENGINE=' at line 9. The SQL statement executed was: CREATE TABLE `lime_notifications` ( `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `entity` varchar(15) not null, `entity_id` int(11) not null, `title` varchar(255) not null, `message` text not null, `status` varchar(15) not null default 'new' , `importance` int(11) default 1, `display_class` varchar(31) default \'default\', `created` datetime not null, `first_read` datetime null ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
I am running Debian GNU/Linux 7.11 (wheezy), fully updated via apt-get. My PHP is version 5.4.45-0+deb7u8 and my MySQL version is 5.5.55-0+deb7u1. My current LimeSurvey version is 258 and it is trying to upgrade to 263.
How can I get my LimeSurvey working again? Thanks!
File Attachment:File Name: patch.zip
File Size:22 KB
I made a quickcomfort update last Friday and have a different error when I go to my mysurveysiteURL/admin (which then switch to mysurveysiteURL/index.php/admin):
Internal Server Error CDbConnection failed to open the DB connection. An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem. Thank you.
The survey site was fonctionning well before
Note: it hadn't be updated for quite a while.
Any guidance would be appreciated. I tested the patch from Olle but this does not impact.
Sorry about the problem. Can you enable debug = 2? Edit file application/config/config.php and change debug => 0 to debug => 2. Then reload the page and give us the error message.
Also, in config.php, check that your database credentials are correct.
Indeed, looking here: manual.limesurvey.org/Installation#Make_...rvey_on_your_website states thatrequired MySQL version is 5.5.3 minimum. My current version is 5.1. I am going to investigate how I can best upgrade my database, hoping that everything is not mixed up in it.
Note: It may be good to add a check of MySQL version in the comfortupdate procedure
I am using PHP5.6. I do not see were the issue come from.
Question: Is there a way to revert back from a Comfort Update ? Coming back to initial version, duplicating the 2 surveys I need and reimporting into a fresh limesurvey instance would probably be faster.