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 |