View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 0
IDProjectCategoryView StatusDate SubmittedLast Update
20464Bug reportsDatabase designpublic2026-03-18 14:592026-03-18 14:59
Reporterbismark Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version6.16.x 
Summary20464: where clause must use table alias q instead of questions
Description

https://github.com/LimeSurvey/LimeSurvey/blob/master/application/helpers/common_helper.php#L1487

#1054 - Unbekanntes Tabellenfeld 'questions.qid' in where clause

AND questions.qid = 42 must use the alias q

SELECT g., q., gls., qls.
FROM lime_groups g
JOIN lime_questions q ON q.gid = g.gid
JOIN lime_group_l10ns gls ON gls.gid = g.gid
JOIN lime_question_l10ns qls ON qls.qid = q.qid
WHERE qls.language = 'de'
AND g.sid = 123456
AND q.parent_qid = 0
AND questions.qid = 42

Steps To Reproduce

var_dump() the query, use phpMyAdmin and filter by a specific qid

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)6.x
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL
Server OS (if known)
Webserver software & version (if known)
PHP Version8.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2026-03-18 14:59 bismark New Issue