View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
11603 | Bug reports | Installation | public | 2016-08-31 09:43 | 2016-09-01 11:05 |
Reporter | fvanderstarre | Assigned To | ollehar | ||
Priority | none | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 2.51.x | ||||
Fixed in Version | 2.51.x | ||||
Summary | 11603: Upgrading from 2.50-160616 to 2.51-160829 fails with database error on MS-SQL | ||||
Description | Updating 2.50 build 160616 (db version 258) to 2.51 build 160829 (db version 260) fails with database error: | ||||
Additional Information | Using dblib, FreeTDS | ||||
Tags | No tags attached. | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 2.51 builld 160829 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Any | ||||
Database type & version | MS SQL server 2008 | ||||
Server OS (if known) | DB server: Windows NT 6.1 <X64> build 7601 SP1 | ||||
Webserver software & version (if known) | Linux RHEL 7, Apache 2.4.6 | ||||
PHP Version | 5.6.21 | ||||
drivername should be checked when creating the notifications table in updatedb_helper.php, line #1420 and following ( if ($iOldDBVersion < 259) etc....) |
|
Just removing "default" from first_read column definition did the trick (if no value specified, null is default anyway, and column must be nullable): |
|
Thanks, will apply this change. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=20327 |
|
Version 2.51.1 Build 160901 released |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2016-08-31 09:43 | fvanderstarre | New Issue | |
2016-08-31 09:51 | fvanderstarre | Note Added: 40587 | |
2016-08-31 10:26 | fvanderstarre | Note Added: 40596 | |
2016-08-31 10:27 | ollehar | Note Added: 40597 | |
2016-08-31 10:28 | ollehar | Changeset attached | => LimeSurvey master 2a999aaf |
2016-08-31 10:28 | ollehar | Note Added: 40598 | |
2016-08-31 10:28 | ollehar | Assigned To | => ollehar |
2016-08-31 10:28 | ollehar | Resolution | open => fixed |
2016-08-31 10:29 | ollehar | Status | new => resolved |
2016-08-31 10:29 | ollehar | Fixed in Version | => 2.51.x |
2016-09-01 11:05 | c_schmitz | Note Added: 40628 | |
2016-09-01 11:05 | c_schmitz | Status | resolved => closed |