View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
16317Bug reportsOtherpublic2020-05-21 13:052021-08-31 08:40
Reporterrkm1 Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Summary16317: Column "language" does not exist in questions table
Description

Hi dev team,

Thank you for your work making a great survey tool. I think I found a bug - details below.

Cheers,
Richard

The link "View the statistics for this survey" at the end of a survey returns an HTTP 500 with the error

CDbCommand failed to execute the SQL statement:

SQLSTATE[42703]: Undefined column: 7
ERROR: column "language" does not exist
LINE 1: SELECT * FROM "lime_questions" "t" WHERE language='de' AND ...

Build: limesurvey4.2.4+200520.zip
Database: Postgres
OS: Ubuntu 18.04 LTS
PHP: 7.2.24

Steps To Reproduce

1) Create a survey with a multiple choice question.

2) Enable "Show in public statistics" on the "Statistics" tab for the question.

3) Enable "Public Statistics" in the survey settings under "Presentation & navigation".

4) Run the survey, add a response for the question, then view the statistics with the link
"View the statistics for this survey" (.../index.php/statistics_user/...) at the end of the survey.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)Unknown
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2021-03-07 21:45

administrator   ~62834

Hello rkm1,
This should already be fixed in recent versions.
Can you please check if this issue still exists in the latest version of LimeSurvey and let us know?
Thank you!
c_schmitz

c_schmitz

2021-08-31 08:40

administrator   ~66205

Hello rkm1,

we have asked for feedback on this issue. Because we did not get an answer we assume that the issue is resolved.
However, should you be able to reproduce the issue using the latest version, please feel free to re-open the issue and give us exact details on how to reproduce it.

Thank you and best regards,

c_schmitz

Issue History

Date Modified Username Field Change
2020-05-21 13:05 rkm1 New Issue
2021-03-07 21:44 c_schmitz Project Development => Bug reports
2021-03-07 21:44 c_schmitz Category Statistics => Other issues
2021-03-07 21:45 c_schmitz Note Added: 62834
2021-03-07 21:45 c_schmitz Assigned To => c_schmitz
2021-03-07 21:45 c_schmitz Status new => feedback
2021-03-07 21:45 c_schmitz Complete LimeSurvey version number (& build) => Unknown
2021-08-31 08:40 c_schmitz Status feedback => closed
2021-08-31 08:40 c_schmitz Resolution open => fixed
2021-08-31 08:40 c_schmitz Note Added: 66205