View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
16372 | Bug reports | Survey editing | public | 2020-06-08 22:02 | 2020-06-16 09:40 |
Reporter | ovsd_ptran | Assigned To | c_schmitz | ||
Priority | high | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.22.19 | ||||
Summary | 16372: Unable to save any settings on "General Settings" screen | ||||
Description | After upgrading from 3.17 to 3.22.19, no longer able to save any settings on General Settings screen after new survey is created. Browser receives 500 error on POST but can't find the actual details of the error. | ||||
Steps To Reproduce |
| ||||
Additional Information | Replaced files with fresh copy of 3.22.19. | ||||
Tags | No tags attached. | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | 3.22.19+200605 | ||||
I will donate to the project if issue is resolved | Yes | ||||
Browser | |||||
Database type & version | Microsoft SQL Server 2016 | ||||
Server OS (if known) | Windows Server 2012 R2 | ||||
Webserver software & version (if known) | IIS 8.5 | ||||
PHP Version | 7.3.12 | ||||
I got some debug data in the 500 error! "<h1>CDbException</h1> CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Ambiguous column name 'qid'.. The SQL statement executed was: SELECT q.qid FROM lime_questions q JOIN lime_questions r ON q.qid=r.qid WHERE q.parent_qid<>0 AND q.scale_id<>r.scale_id GROUP BY qid (C:\inetpub\limesurveyinstallfolder\framework\db\CDbCommand.php:543) #0 C:\inetpub\limesurveyinstallfolder\framework\db\CDbCommand.php(455): CDbCommand->queryInternal('fetchAll', Array, Array)" |
|
Fixed in Release 3.22.20+200617 |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2020-06-08 22:02 | ovsd_ptran | New Issue | |
2020-06-08 22:38 | ovsd_ptran | Note Added: 58222 | |
2020-06-09 10:35 | ollehar | Priority | none => high |
2020-06-09 10:35 | ollehar | Severity | partial_block => crash |
2020-06-09 10:55 | c_schmitz | Assigned To | => c_schmitz |
2020-06-09 10:55 | c_schmitz | Status | new => resolved |
2020-06-09 10:55 | c_schmitz | Resolution | open => fixed |
2020-06-09 11:12 | c_schmitz | Changeset attached | => LimeSurvey 3.x-LTS 018cc1f7 |
2020-06-16 09:40 | lime_release_bot | Note Added: 58298 | |
2020-06-16 09:40 | lime_release_bot | Status | resolved => closed |