View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
20464Bug reportsDatabase designpublic2026-03-18 14:592026-03-20 12:27
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 heat2
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

c_schmitz

c_schmitz

2026-03-20 12:27

administrator   ~84493

Feel free to submit a PR.

Issue History

Date Modified Username Field Change
2026-03-18 14:59 bismark New Issue
2026-03-20 12:27 c_schmitz Note Added: 84493
2026-03-20 12:27 c_schmitz Bug heat 0 => 2