View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
19680 | Bug reports | Survey taking | public | 2024-08-06 11:16 | 2024-09-13 14:21 |
Reporter | tmszi | Assigned To | tibor.pacalat | ||
Priority | none | Severity | crash | ||
Status | assigned | Resolution | open | ||
Product Version | 6.5.x | ||||
Summary | 19680: 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 | ||||
Steps To Reproduce | Steps to reproduce
500: Internal Server Error - CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text <> integer Expected resultSurvey shared URL link should work without message. Actual resultYou 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 | ||||
Tags | No tags attached. | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 6.5.17 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | PostgreSQL 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 Version | 8.1.29 | ||||
@tmszi can you please update to 6.5.18 and see if this is still happening? |
|
@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. |
|
@tmszi There is a new version available at https://hub.docker.com/r/martialblog/limesurvey/tags. Can you please try with the newest one? |
|
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 |