View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04915 | Bug reports | Survey taking | public | 2011-02-01 12:42 | 2011-09-20 16:02 |
Reporter | Assigned To | c_schmitz | |||
Priority | normal | Severity | block | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 1.91RC2 | ||||
Target Version | 1.91RC4 | Fixed in Version | 1.91RC4 | ||
Summary | 04915: GSoC - SQL error testing survey (MS SQL Server 2005) | ||||
Description | When testing a survey, I get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]The data types text and varchar are incompatible in the not equal to operator.:SELECT attr.qid,value FROM [lime_question_attributes] as attr right join [lime_questions] as quests on attr.qid=quests.qid WHERE attribute='random_group' and value <> '' and sid=44897 GROUP BY attr.qid | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 10 | ||||
Complete LimeSurvey version number (& build) | 9672 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | MS SQL Server 2005 | ||||
Server OS (if known) | Windows Server 2003 SP2 | ||||
Webserver software & version (if known) | IIS 6.0 | ||||
PHP Version | 5.2.13 | ||||
I have: $databasetype = 'odbc_mssql' Resolution:
However, in MSSQL the query will still return an error since the 'value' column is specified in the SELECT but not in the GROUP BY. So in "index.php" I changed line 2698 to: $rgquery = "SELECT attr.qid,value FROM ".db_table_name('question_attributes')." as attr right join ".db_table_name('questions')." as quests on attr.qid=quests.qid WHERE attribute='random_group' and value <> '' and sid=$surveyid GROUP BY attr.qid, value"; |
|
To test: load the survey in attach. Select "Test this survey" |
|
The grouping error in this issue was reported yesterday in 04913. Apparently both PostgreSQL and MSSQL (correctly) reject the query, while MySQL actually accepts it, returning "something". |
|
Carsten, I think you are the only one who has MS SQL installed for testing?! |
|
1.91RC4 released |
|
A user recently reported this problem at the latest 1.91 version. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2011-02-01 12:42 |
|
New Issue | |
2011-02-01 12:43 |
|
File Added: limesurvey_survey_44897.lss | |
2011-02-01 12:43 |
|
Note Added: 14023 | |
2011-02-01 12:44 |
|
Note Added: 14024 | |
2011-02-01 12:46 |
|
Issue Monitored: user11833 | |
2011-02-01 13:47 | limech | Note Added: 14025 | |
2011-02-01 13:47 | limech | Issue Monitored: limech | |
2011-02-01 16:15 | mdekker | Target Version | => 1.91RC4 |
2011-02-02 12:39 | Mazi | Relationship added | related to 04913 |
2011-02-02 12:39 | Mazi | Assigned To | => c_schmitz |
2011-02-02 12:39 | Mazi | Status | new => assigned |
2011-02-02 12:40 | Mazi | Note Added: 14039 | |
2011-02-09 16:05 | Mazi | Summary | SQL error testing survey (MS SQL Server 2005) => GSoC - SQL error testing survey (MS SQL Server 2005) |
2011-02-09 16:05 | Mazi | Description Updated | |
2011-02-11 18:53 | c_schmitz | Status | assigned => resolved |
2011-02-11 18:53 | c_schmitz | Fixed in Version | => 1.91RC4 |
2011-02-11 18:53 | c_schmitz | Resolution | open => fixed |
2011-02-17 18:25 | c_schmitz | Note Added: 14222 | |
2011-02-17 18:25 | c_schmitz | Status | resolved => closed |
2011-09-20 15:34 | Mazi | Note Added: 16301 | |
2011-09-20 15:34 | Mazi | Status | closed => feedback |
2011-09-20 15:34 | Mazi | Resolution | fixed => reopened |
2011-09-20 16:02 | c_schmitz | Status | feedback => closed |
2011-09-20 16:02 | c_schmitz | Resolution | reopened => unable to reproduce |
2021-08-24 11:41 | guest | Bug heat | 8 => 10 |