View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
20464Bug reportsDatabase designpublic2026-03-18 14:592026-03-27 13:22
Reporterbismark Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status resolvedResolutionfixed 
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.
c_schmitz

c_schmitz

2026-03-27 13:22

administrator   ~84549

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=39475

Related Changesets

LimeSurvey: master 793ea2cb

2026-03-27 13:22

c_schmitz


Details Diff		 Fixed issue 20464: Error message 'Unkown table field questions.qid' Affected Issues
20464
mod - application/helpers/common_helper.php Diff File

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
2026-03-27 13:22 c_schmitz Changeset attached => LimeSurvey master 793ea2cb
2026-03-27 13:22 c_schmitz Note Added: 84549
2026-03-27 13:22 c_schmitz Assigned To => c_schmitz
2026-03-27 13:22 c_schmitz Status new => resolved
2026-03-27 13:22 c_schmitz Resolution open => fixed