View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
03895 | Bug reports | Survey participants (Tokens) | public | 2009-11-24 17:01 | 2009-11-28 13:44 |
Reporter | joe_p | Assigned To | jcleeland | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.87RC2 | ||||
Fixed in Version | 1.87RC3 | ||||
Summary | 03895: SQL error (actually in 1.87RC3) | ||||
Description | After entering a token on the token entry screen, I get the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]The data types text and varchar are incompatible in the equal to operator.:SELECT count(qa.qaid) as afcount from [question_attributes] as qa, [questions] as q WHERE qa.qid = q.qid AND qa.attribute='array_filter' AND qa.value ='4_ProGetHC' AND q.sid=75194 Here's a fixed version: SELECT count(qa.qaid) as afcount | ||||
Additional Information | I wasn't able to select 1.87RC3 in the dropdown, but that's the version that has the error. Also, there's no build number in version.php. | ||||
Tags | No tags attached. | ||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 0000 | ||||
I will donate to the project if issue is resolved | |||||
Browser | FF 3.5.5 | ||||
Database type & version | MS SQL Server 10.0.2531 | ||||
Server OS (if known) | Microsoft-IIS/6.0 | ||||
Webserver software & version (if known) | Windows Server 2008 | ||||
PHP Version | PHP Version 5.2.11 | ||||
For SQL 2005 and newer, you can equate values if the data type is varchar(max). Without a PHP code change, change the table create script -- TEXT data type to varchar(max) |
|
The 'like' solution is elegant enough, works on all DB systems and only needed for qa.value. |
|
SQL updated, thanks |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2009-11-24 17:01 | joe_p | New Issue | |
2009-11-24 17:01 | joe_p | Status | new => assigned |
2009-11-24 17:01 | joe_p | Assigned To | => user372 |
2009-11-24 17:01 | joe_p | LimeSurvey build number | => 0000 |
2009-11-24 17:01 | joe_p | Browser | => FF 3.5.5 |
2009-11-24 17:01 | joe_p | Database & DB-Version | => MS SQL Server 10.0.2531 |
2009-11-24 17:01 | joe_p | Operating System (Server) | => Microsoft-IIS/6.0 |
2009-11-24 17:01 | joe_p | Webserver | => Windows Server 2008 |
2009-11-24 17:01 | joe_p | PHP Version | => PHP Version 5.2.11 |
2009-11-24 17:47 |
|
Assigned To | user372 => c_schmitz |
2009-11-24 19:18 | bobc55 | Note Added: 10242 | |
2009-11-26 17:27 | c_schmitz | Note Added: 10277 | |
2009-11-26 17:27 | c_schmitz | Note Edited: 10277 | |
2009-11-26 17:27 | c_schmitz | Assigned To | c_schmitz => jcleeland |
2009-11-27 00:53 | jcleeland | Note Added: 10283 | |
2009-11-27 00:53 | jcleeland | Status | assigned => resolved |
2009-11-27 00:53 | jcleeland | Fixed in Version | => 1.87RC3 |
2009-11-27 00:53 | jcleeland | Resolution | open => fixed |
2009-11-28 13:44 | c_schmitz | Status | resolved => closed |
2016-12-08 10:39 | c_schmitz | Category | Tokens => Survey participants (Tokens) |