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) |