View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
19723Bug reportsStatisticspublic2024-08-27 19:092024-10-02 16:37
Reportermferraz Assigned Totibor.pacalat  
PrioritynoneSeverityblock 
Status feedbackResolutionopen 
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 heat2
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

tibor.pacalat

tibor.pacalat

2024-10-02 16:16

administrator   ~81141

@mferraz can you please try with the newest version? I can not reproduce the issue.

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
2024-10-02 16:16 tibor.pacalat Note Added: 81141
2024-10-02 16:16 tibor.pacalat Bug heat 0 => 2
2024-10-02 16:37 tibor.pacalat Assigned To => tibor.pacalat
2024-10-02 16:37 tibor.pacalat Status new => feedback