View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
19673Bug reportsStatisticspublic2024-07-31 13:30
Reporterthws_jp Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version6.5.x 
Summary19673: 500: Interner Serverfehler - CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42601]
Description

500: Interner Serverfehler - CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42601]: Syntax error: 7 FEHLER: Syntaxfehler bei »=«
LINE 1: ...ROM "lime_questions" "t" WHERE sid = 344178 and type = ':'
^

Steps To Reproduce

Steps to reproduce

after opening the survey list and clicking on action in a survey to display the statistics
or
when editing a survey, click on statistics and run simple mode

Expected result

open the statistics of the survey

Actual result

error message:
500: Interner Serverfehler - CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42601]: Syntax error: 7 FEHLER: Syntaxfehler bei »=«
LINE 1: ...ROM "lime_questions" "t" WHERE sid = 344178 and type = ':'
^

The error happens with every survey

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)6.6.0+240729
I will donate to the project if issue is resolvedNo
BrowserFirefox 128.0.3 (64-Bit)
Database type & versionPostgreSQL 14.3
Server OS (if known)Microsoft Windows Server 2019 Standard
Webserver software & version (if known)
PHP Version8.3.9

Users monitoring this issue

thws_jp

Activities

thws_jp

thws_jp

2024-07-31 13:29

reporter   ~80724

BUG 6.6.0+240729.PNG (31,958 bytes)   
limesurvey_survey_762615.lss (26,484 bytes)   

Issue History

Date Modified Username Field Change
2024-07-31 13:27 thws_jp New Issue
2024-07-31 13:29 thws_jp Note Added: 80724
2024-07-31 13:29 thws_jp File Added: BUG 6.6.0+240729.PNG
2024-07-31 13:29 thws_jp File Added: limesurvey_survey_762615.lss
2024-07-31 13:29 thws_jp Bug heat 0 => 2
2024-07-31 13:30 thws_jp Issue Monitored: thws_jp
2024-07-31 13:30 thws_jp Bug heat 2 => 4