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 |