View Issue Details

IDProjectCategoryView StatusLast Update
15851Bug reportsSurvey editingpublic2020-02-17 17:59
Reporterfabianlehner Assigned To 
PrioritynormalSeveritypartial_block 
Status closedResolutionno change required 
Product Version4.1.2 
Summary15851: 500 (xhr) error when trying to list questions
Description

When trying to access the "list questions" menu item in the survey editor, the xhr request fails with a 500 error: message:

CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "group" LINE 1: ...t"."gid"="group"."gid") WHERE (parent_qid = 0 AND group.sid=...

Stack trace is below.
This might be related to 15752.
Same error happens on 4.0.1 and 4.1.2 releases.

Please let me know if I can help to resolve this.

Steps To Reproduce

Try to access "list questions" in the survey editor.

Additional Information

Stack trace:
#0 /var/www/html/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /var/www/html/framework/db/ar/CActiveFinder.php(810): CDbCommand->queryAll()
#2 /var/www/html/framework/db/ar/CActiveFinder.php(441): CJoinElement->runQuery(Object(CJoinQuery))
#3 /var/www/html/framework/db/ar/CActiveFinder.php(68): CJoinElement->find(Object(CDbCriteria))
#4 /var/www/html/framework/db/ar/CActiveRecord.php(1364): CActiveFinder->query(Object(CDbCriteria), true)
#5 /var/www/html/application/models/LSActiveRecord.php(74): CActiveRecord->query(Object(CDbCriteria), true)
#6 /var/www/html/framework/db/ar/CActiveRecord.php(1478): LSActiveRecord->query(Object(CDbCriteria), true)
#7 /var/www/html/application/controllers/admin/statistics.php(160): CActiveRecord->findAll(Array)
#8 [internal function]: statistics->run('746595', NULL)
#9 /var/www/html/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(statistics), Array)
#10 /var/www/html/application/core/Survey_Common_Action.php(86): CAction->runWithParamsInternal(Object(statistics), Object(ReflectionMethod), Array)
#11 /var/www/html/framework/web/CController.php(308): Survey_Common_Action->runWithParams(Array)
#12 /var/www/html/framework/web/CController.php(286): CController->runAction(Object(statistics))
#13 /var/www/html/framework/web/CController.php(265): CController->runActionWithFilters(Object(statistics), Array)
#14 /var/www/html/application/controllers/AdminController.php(165): CController->run('statistics')
#15 /var/www/html/framework/web/CWebApplication.php(282): AdminController->run('statistics')
#16 /var/www/html/framework/web/CWebApplication.php(141): CWebApplication->runController('admin/statistic...')
#17 /var/www/html/framework/base/CApplication.php(185): CWebApplication->processRequest()
#18 /var/www/html/index.php(195): CApplication->run()
#19 {main}

TagsNo tags attached.
Complete LimeSurvey version number (& build)4.1.3
I will donate to the project if issue is resolvedNo
Browser
Database & DB-VersionPostgres 11.6
Server OS (if known)
Webserver software & version (if known)
PHP Version7.4.2

Activities

eddylackmann

eddylackmann

2020-02-17 14:53

developer   ~56057

@fabianlehner should be fixed now right in 4.1.5? Can i close the ticket ?

fabianlehner

fabianlehner

2020-02-17 16:07

reporter   ~56058

Works, thanks a lot!

Issue History

Date Modified Username Field Change
2020-02-12 12:19 fabianlehner New Issue
2020-02-12 12:35 ollehar Priority none => normal
2020-02-17 14:53 eddylackmann Note Added: 56057
2020-02-17 16:07 fabianlehner Note Added: 56058
2020-02-17 17:59 ollehar Status new => closed
2020-02-17 17:59 ollehar Resolution open => no change required