View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05919 | Bug reports | Installation | public | 2012-03-16 16:36 | 2012-03-19 19:02 |
| Reporter | MPIDR | Assigned To | c_schmitz | ||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.92+ | ||||
| Fixed in Version | 1.92+ | ||||
| Summary | 05919: Bad SQL syntax in file upgrade-mssqlnative.php | ||||
| Description | I am using LimeSurvey 1.91 with a MS SQL Server 2008 R2. During update to LimeSurvey 1.92, the database cannot be upgraded. I receive a number of error messages from SQL server. | ||||
| Steps To Reproduce | Upgrade from 1.91 to 1.92. | ||||
| Additional Information | This relates to Bug ID 05913. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 120314 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | doesn't matter | ||||
| Database type & version | MS SQL Server 2008 R2 | ||||
| Server OS (if known) | Windows Server 2008 R2 | ||||
| Webserver software & version (if known) | IIS 7.5 | ||||
| PHP Version | 5.3.8 | ||||
| Git branch / Pull Request URL | |||||
|
Thank you. This was resolved with 05913, too. |
|
|
05913 includes a new create-mssqlnative.sql file. However, there is no new upgrade-mssqlnative.php. The upgrade-mssqlnative.php in 1.92+ contains a lot of MySQL code like AUTO_INCREMENT instead of IDENTIDY (1,1) and int(20) instead of integer. |
|
|
1.92+ version released. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-03-16 16:36 | MPIDR | New Issue | |
| 2012-03-16 17:21 | c_schmitz | Relationship added | related to 05913 |
| 2012-03-16 17:22 | c_schmitz | Note Added: 17948 | |
| 2012-03-16 17:22 | c_schmitz | Status | new => resolved |
| 2012-03-16 17:22 | c_schmitz | Fixed in Version | => 1.92+ |
| 2012-03-16 17:22 | c_schmitz | Resolution | open => fixed |
| 2012-03-16 17:22 | c_schmitz | Assigned To | => c_schmitz |
| 2012-03-19 09:08 | MPIDR | Note Added: 17990 | |
| 2012-03-19 19:02 | c_schmitz | Note Added: 17993 | |
| 2012-03-19 19:02 | c_schmitz | Status | resolved => closed |