View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
12487Bug reportsOtherpublic2017-06-29 12:24
ReporterESPU Assigned Toc_schmitz  
PrioritynoneSeveritycrash 
Status closedResolutionfixed 
Fixed in Version2.67.x 
Summary12487: Error on notifications table creation when updating to 2.67.0+170622
Description

The error below is displayed when updating the database. This issue was not there on version 2.66.0+170619.

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 ls_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

This issue is related to line 1564 in updatedb_helper.php.

On version 2.66.0+170619 it was:
'display_class' => 'string(31) default \'default\'',

On version 2.67.0+170622 the line has been changed, it leaves unwanted backslashes in the SQL query:
'display_class' => "string(31) default \'default\'",

Steps To Reproduce

Upgrade from 2.06+ Build 160129.
Go to admin interface and proceed to database update.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)2.67.0+170622
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL 5.6
Server OS (if known)Windows 2008R2
Webserver software & version (if known)IIS 7.5
PHP Version7.1.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2017-06-29 12:24

administrator   ~43982

This is already fixed in the latest version.
For a quickfix just remove the slashes round the 'default'.

Issue History

Date Modified Username Field Change
2017-06-26 14:49 ESPU New Issue
2017-06-29 12:24 c_schmitz Assigned To => c_schmitz
2017-06-29 12:24 c_schmitz Status new => closed
2017-06-29 12:24 c_schmitz Resolution open => fixed
2017-06-29 12:24 c_schmitz Fixed in Version => 2.67.x
2017-06-29 12:24 c_schmitz Note Added: 43982