View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
16372Bug reportsSurvey editingpublic2020-06-16 09:40
Reporterovsd_ptran Assigned Toc_schmitz  
PriorityhighSeveritycrash 
Status closedResolutionfixed 
Product Version3.22.19 
Summary16372: 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
  1. Upgrade from earlier version to 3.22.19.
  2. Create new survey.
  3. Go to General Settings and attempt to add languages.
  4. Click Save. Cogwheel spins but goes nowhere.
  5. Developer Tools reveals 500 error on POST.
    Tried on Chrome and Firefox.
Additional Information

Replaced files with fresh copy of 3.22.19.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build) 3.22.19+200605
I will donate to the project if issue is resolvedYes
Browser
Database type & versionMicrosoft SQL Server 2016
Server OS (if known)Windows Server 2012 R2
Webserver software & version (if known)IIS 8.5
PHP Version7.3.12

Users monitoring this issue

There are no users monitoring this issue.

Activities

ovsd_ptran

ovsd_ptran

2020-06-08 22:38

reporter   ~58222

I got some debug data in the 500 error!

"<h1>CDbException</h1>
<p>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)</p><pre>#0 C:\inetpub\limesurveyinstallfolder\framework\db\CDbCommand.php(455): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 C:\inetpub\limesurveyinstallfolder\application\helpers\common_helper.php(3794): CDbCommand->queryColumn()
#2 C:\inetpub\limesurveyinstallfolder\application\controllers\admin\database.php(1151): fixLanguageConsistency('398835', 'es vi')
#3 C:\inetpub\limesurveyinstallfolder\application\controllers\admin\database.php(136): database->actionUpdateSurveyLocaleSettingsGeneralSettings(398835)
#4 [internal function]: database->index()
#5 C:\inetpub\limesurveyinstallfolder\framework\web\actions\CAction.php(109): ReflectionMethod->invokeArgs(Object(database), Array)
#6 C:\inetpub\limesurveyinstallfolder\application\core\Survey_Common_Action.php(83): CAction->runWithParamsInternal(Object(database), Object(ReflectionMethod), Array)
#7 C:\inetpub\limesurveyinstallfolder\framework\web\CController.php(308): Survey_Common_Action->runWithParams(Array)
#8 C:\inetpub\limesurveyinstallfolder\framework\web\CController.php(286): CController->runAction(Object(database))
#9 C:\inetpub\limesurveyinstallfolder\framework\web\CController.php(265): CController->runActionWithFilters(Object(database), Array)
#10 C:\inetpub\limesurveyinstallfolder\application\controllers\AdminController.php(165): CController->run('database')
#11 C:\inetpub\limesurveyinstallfolder\framework\web\CWebApplication.php(282): AdminController->run('database')
#12 C:\inetpub\limesurveyinstallfolder\framework\web\CWebApplication.php(141): CWebApplication->runController('admin/database/...')
#13 C:\inetpub\limesurveyinstallfolder\framework\base\CApplication.php(185): CWebApplication->processRequest()
#14 C:\inetpub\limesurveyinstallfolder\index.php(194): CApplication->run()
#15 {main}</pre>"

lime_release_bot

lime_release_bot

2020-06-16 09:40

administrator   ~58298

Fixed in Release 3.22.20+200617

Related Changesets

LimeSurvey: 3.x-LTS 018cc1f7

2020-06-09 10:52:28

c_schmitz

Details Diff
Fixed issue 16372: Unable to save any settings on "General Settings" screen when using MSSQL Affected Issues
16372
mod - application/helpers/common_helper.php Diff File

Issue History

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