View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06155Bug reportsSurvey editingpublic2012-05-31 14:042012-06-07 11:02
Reportermdekker Assigned Tomdekker  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.92+ 
Target Version1.92+Fixed in Version1.92+ 
Summary06155: Error on MSSQL: Ambiguous column name qid
Description

[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'qid'.:SELECT a.qid, a.code, a.answer, a.scale_id, a.assessment_value FROM [lime_answers] AS a, [lime_questions] as q WHERE a.qid = q.qid and q.sid = 15324 and a.language='en' and q.language='en' ORDER BY qid, scale_id, sortorder

Additional Information

http://www.limesurvey.org/en/forum/installation-a-update-issues/81168-after-installing-version-192-build-120530-i-get-an-mssql-error-creating-survey

http://www.limesurvey.org/en/forum/installation-a-update-issues/80761-problems-updating-limesurvey-190-build-9642-to-v192-120517

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

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2012-05-31 14:07

reporter   ~19014

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

mdekker

2012-05-31 14:08

reporter   ~19015

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

c_schmitz

2012-06-07 11:02

administrator   ~19104

New 1.91+ build released.

Related Changesets

LimeSurvey: master 64d892c7

2012-05-31 07:05

mdekker


Details Diff		 Fixed 06155: Error on MSSQL: Ambiguous column name qid Affected Issues
06155
mod - classes/expressions/LimeExpressionManager.php Diff File

LimeSurvey: Yii dd0ce95b

2012-05-31 07:07

mdekker


Details Diff		 Fixed 06155: Error on MSSQL: Ambiguous column name qid Affected Issues
06155
mod - application/helpers/expressions/em_manager_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-05-31 14:04 mdekker New Issue
2012-05-31 14:04 mdekker Status new => assigned
2012-05-31 14:04 mdekker Assigned To => mdekker
2012-05-31 14:04 mdekker Summary Error on MSSQL: Ambiguos column name qid => Error on MSSQL: Ambiguous column name qid
2012-05-31 14:07 mdekker Changeset attached => LimeSurvey master 64d892c7
2012-05-31 14:07 mdekker Note Added: 19014
2012-05-31 14:07 mdekker Resolution open => fixed
2012-05-31 14:08 mdekker Changeset attached => LimeSurvey Yii dd0ce95b
2012-05-31 14:08 mdekker Note Added: 19015
2012-05-31 14:10 mdekker Status assigned => resolved
2012-05-31 14:10 mdekker Fixed in Version => 1.92+
2012-06-07 11:02 c_schmitz Note Added: 19104
2012-06-07 11:02 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing