View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
19680Bug reportsSurvey takingpublic2024-08-06 11:162024-10-28 10:05
Reportertmszi Assigned Totibor.pacalat  
PrioritynoneSeveritycrash 
Status closedResolutionwon't fix 
Product Version6.5.x 
Summary19680: Survey shared URL return 500: Internal Server Error - CDbCommand failed to execute the SQL statement
Description

Created new survey shared URL return error message:

500: Internal Server Error - CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text <> integer
LINE 1: ...AND parent_qid=0 AND((attribute='hidden' AND value!=1 )OR at...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

Steps To Reproduce

Steps to reproduce

  1. Create new simple survey with one question
  2. Try open the survey shared URL
  3. You get error message

500: Internal Server Error - CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text <> integer
LINE 1: ...AND parent_qid=0 AND((attribute='hidden' AND value!=1 )OR at...
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

Expected result

Survey shared URL link should work without message.

Actual result

You get error message:

500: Internal Server Error - CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text <> integer
LINE 1: ...AND parent_qid=0 AND((attribute='hidden' AND value!=1 )OR at...
^

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)6.5.17
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL DB version 16.3
Server OS (if known)GNU/Linux Debian 6.1.94-1 (2024-06-21) x86_64
Webserver software & version (if known)Apache/2.4.61 (Debian)
PHP Version8.1.29

Users monitoring this issue

tmszi

Activities

tibor.pacalat

tibor.pacalat

2024-08-06 13:20

administrator   ~80744

@tmszi can you please update to 6.5.18 and see if this is still happening?
tmszi

tmszi

2024-08-06 14:07

reporter   ~80747

@tibor.pacalat I'm using Docker image from Docker Hub repository https://hub.docker.com/r/martialblog/limesurvey/tags, but last available version is 6.5.17-240715-apache only. Version 6.18 is not yet available.

I try downgrade LimeSurvey app version (Docker image) to version 6.5.15-240701-apache, and survey shared URL works as expected without error message.
tibor.pacalat

tibor.pacalat

2024-09-13 14:21

administrator   ~81017

@tmszi There is a new version available at https://hub.docker.com/r/martialblog/limesurvey/tags. Can you please try with the newest one?
tmszi

tmszi

2024-10-26 08:17

reporter   ~81298

@tibor.pacalat First sorry for delay. I tested lastest available version 6.6.5-240924 and it works as expected. Thanks.

Issue History

Date Modified Username Field Change
2024-08-06 11:16 tmszi New Issue
2024-08-06 11:24 tmszi Issue Monitored: tmszi
2024-08-06 11:24 tmszi Bug heat 0 => 2
2024-08-06 13:20 tibor.pacalat Note Added: 80744
2024-08-06 13:20 tibor.pacalat Bug heat 2 => 4
2024-08-06 13:20 tibor.pacalat Assigned To => tibor.pacalat
2024-08-06 13:20 tibor.pacalat Status new => feedback
2024-08-06 14:07 tmszi Note Added: 80747
2024-08-06 14:07 tmszi Bug heat 4 => 6
2024-08-06 14:07 tmszi Status feedback => assigned
2024-09-13 14:21 tibor.pacalat Note Added: 81017
2024-10-26 08:17 tmszi Note Added: 81298
2024-10-28 10:05 tibor.pacalat Status assigned => closed
2024-10-28 10:05 tibor.pacalat Resolution open => won't fix