View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06155 | Bug reports | Survey editing | public | 2012-05-31 14:04 | 2012-06-07 11:02 |
| Reporter | mdekker | Assigned To | mdekker | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.92+ | ||||
| Fixed in Version | 1.92+ | ||||
| Summary | 06155: 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 | |||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 120530 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | MSSQL | ||||
| Server OS (if known) | . | ||||
| Webserver software & version (if known) | . | ||||
| PHP Version | . | ||||
| Git branch / Pull Request URL | |||||
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8590 |
|
|
Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8592 |
|
|
New 1.91+ build released. |
|
|
LimeSurvey: master 64d892c7 2012-05-31 07:05 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 Details Diff |
Fixed 06155: Error on MSSQL: Ambiguous column name qid |
Affected Issues 06155 |
|
| mod - application/helpers/expressions/em_manager_helper.php | Diff File | ||
| 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 |