View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 0
IDProjectCategoryView StatusDate SubmittedLast Update
19723Bug reportsStatisticspublic2024-08-27 19:092024-08-27 19:09
Reportermferraz Assigned To 
PrioritynoneSeverityblock 
Status newResolutionopen 
Product Version6.6.x 
Summary19723: 500: Internal Server Error - CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: opera
Description

After trying to generate a statistic, we get the error:
500: Internal Server Error - CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying LINE 1: ... FROM "lime_questions" "t" WHERE sid = 874176 andtype` = '...
^
HINT: No operator matches the given name and argument type. You might need to add an explicit type cast.

Steps To Reproduce

Steps to reproduce

Go to the survey list and try to generate statistics.

Expected result

Get the survey statistics.

Actual result

500: Internal Server Error - CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: character varying LINE 1: ... FROM "lime_questions" "t" WHERE sid = 874176 andtype` = '...
^
HINT: No operator matches the given name and argument type. You might need to add an explicit type cast.

TagsNo tags attached.
Attached Files
Imagem_2.png (83,918 bytes)   
Imagem_2.png (83,918 bytes)   
Imagem_1.png (57,975 bytes)   
Imagem_1.png (57,975 bytes)   
Bug heat0
Complete LimeSurvey version number (& build) 6.6.2+240827
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 13+225
Server OS (if known)
Webserver software & version (if known)
PHP Version8.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

Issue History

Date Modified Username Field Change
2024-08-27 19:09 mferraz New Issue
2024-08-27 19:09 mferraz File Added: Imagem_2.png
2024-08-27 19:09 mferraz File Added: Imagem_1.png