View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 14545 | Bug reports | Menu system | public | 2019-02-19 09:14 | 2019-04-30 09:11 |
| Reporter | DenisChenu | Assigned To | DenisChenu | ||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.x | ||||
| Fixed in Version | 3.15.x | ||||
| Summary | 14545: Unable to reset menu entries with MSSQL | ||||
| Description | When trying to reset menu entries : nothing happen | ||||
| Steps To Reproduce | Click on reset menu entries | ||||
| Additional Information | Even with switchMSSQLIdentityInsert : it's still an issue CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Explicit value must be specified for identity column in table 'lime_surveymenu_entries' either when IDENTITY_INSERT is set to ONor when a replication user is inserting into a NOT FOR REPLICATION identity column.. #0 E:\WebSite\limesurvey\framework\db\CDbCommand.php(1278): CDbCommand->execute(Array) | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 3.15.9 github | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | FF | ||||
| Database type & version | MS SQL Server 2012 | ||||
| Server OS (if known) | windows | ||||
| Webserver software & version (if known) | IIS | ||||
| PHP Version | php7 | ||||
|
We don't need switchMSSQLIdentityInsert since id is not set in default now … |
|
|
https://github.com/LimeSurvey/LimeSurvey/commit/b34bb31def3e26d0ae84f61b5196f1032a5ba67b |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-02-19 09:14 | DenisChenu | New Issue | |
| 2019-02-19 09:14 | DenisChenu | Status | new => assigned |
| 2019-02-19 09:14 | DenisChenu | Assigned To | => markusfluer |
| 2019-02-19 09:14 | DenisChenu | File Added: image001.png | |
| 2019-02-19 09:19 | DenisChenu | Note Added: 50614 | |
| 2019-02-19 09:19 | DenisChenu | Assigned To | markusfluer => DenisChenu |
| 2019-02-19 09:28 | DenisChenu | Status | assigned => resolved |
| 2019-02-19 09:28 | DenisChenu | Resolution | open => fixed |
| 2019-02-19 09:28 | DenisChenu | Fixed in Version | => 3.15.x |
| 2019-02-19 09:28 | DenisChenu | Note Added: 50615 | |
| 2019-02-19 09:28 | DenisChenu | Relationship added | related to 13904 |
| 2019-04-30 09:11 | c_schmitz | Status | resolved => closed |
| 2019-09-10 11:46 | c_schmitz | Category | MenuSystem => Menu system |