View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
06274Bug reportsInstallationpublic2012-07-18 16:33
ReporterRob_Williams Assigned Toc_schmitz  
PrioritynormalSeveritycrash 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary06274: When updating I get a [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name error
Description

When updating Limesurvey to 1.92+ Build 120623 I get the error
The LimeSurvey database is being upgraded (2012-06-25 16:17:00) .Please be patient...

[Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'qid'.:select distinct c., q.sid, q.type from [lime_conditions] as c, [lime_questions] as q where c.cqid=q.qid union select c., q.sid, '' as type from [lime_conditions] as c, [lime_questions] as q where c.cqid = 0 and c.qid = q.qid order by sid, qid, scenario, cqid, cfieldname, value

Steps To Reproduce

Delete old stie files. Download installer. Unpack to required directory. Make changes as per documentation to config.php. Load Limesurvey Admin Console. Error will appear.

Additional Information

Had similar issue with a subtly different script which has since been resolved. Here is the link to that issue:
http://www.limesurvey.org/en/forum/installation-a-update-issues/81168-after-installing-version-192-build-120530-i-get-an-mssql-error-creating-survey#81185

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)120623
I will donate to the project if issue is resolvedNo
BrowserIE9
Database type & versionMS SQL Server 2000
Server OS (if known)Windows Server 2003
Webserver software & version (if known)IIS7
PHP Version5.3.3

Relationships

duplicate of 06207 closedc_schmitz [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'qid' 

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2012-06-26 15:15

updater   ~19568

Looks like a duplicate of http://bugs.limesurvey.org/view.php?id=6207.

^- Please check if that fix solves your problem.

Rob_Williams

Rob_Williams

2012-06-26 16:38

reporter   ~19571

Last edited: 2012-06-26 16:39

Hi,

I hope you dont mind me reopening but I just wanted to draw your attention to what I did to fix the issue. You were right that the fix in issue 06207 should have resolved my problem but it was getting ignored by the fact that it was doing an if statement for ($databasetype == 'mssql'). My config.php was set to ($databasetype == 'odbc_mssql'). Looking at the comments in the config.php there is no reference to 'mssql'. It states 'valid values are mysql, mysqli, odbc_mssql, mssql_n, odbtp or postgres'. I resolved my issue by changing the if statement to look for ($databasetype == 'odbc_mssql').

So in summary I think your fix is not going to work if people conform to the values stated in the config.php comments.

Regards,
Rob

Mazi

Mazi

2012-06-26 17:09

updater   ~19572

Thanks for your feedback. I have asked our developers to check your comments.

c_schmitz

c_schmitz

2012-07-05 22:29

administrator   ~19632

Will be fixed in the next version.

c_schmitz

c_schmitz

2012-07-18 16:33

administrator   ~19783

1.92+ version released.

Issue History

Date Modified Username Field Change
2012-06-25 17:11 Rob_Williams New Issue
2012-06-26 15:14 Mazi Relationship added duplicate of 06207
2012-06-26 15:15 Mazi Note Added: 19568
2012-06-26 15:15 Mazi Status new => closed
2012-06-26 15:15 Mazi Assigned To => Mazi
2012-06-26 15:15 Mazi Resolution open => fixed
2012-06-26 15:15 Mazi Fixed in Version => 1.92+
2012-06-26 16:38 Rob_Williams Note Added: 19571
2012-06-26 16:38 Rob_Williams Status closed => feedback
2012-06-26 16:38 Rob_Williams Resolution fixed => reopened
2012-06-26 16:39 Rob_Williams Note Edited: 19571
2012-06-26 17:09 Mazi Note Added: 19572
2012-07-05 22:29 c_schmitz Note Added: 19632
2012-07-05 22:29 c_schmitz Status feedback => resolved
2012-07-05 22:29 c_schmitz Resolution reopened => fixed
2012-07-05 22:30 c_schmitz Assigned To Mazi => c_schmitz
2012-07-18 16:33 c_schmitz Note Added: 19783
2012-07-18 16:33 c_schmitz Status resolved => closed