View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04404 | Bug reports | Other | public | 2010-06-09 01:26 | 2010-06-10 11:33 |
| Reporter | jrowley | Assigned To | c_schmitz | ||
| Priority | urgent | Severity | block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.90b | ||||
| Fixed in Version | 1.90RC1 | ||||
| Summary | 04404: ODBC error taking a survey migrated from v1.86 to 1.90b3 | ||||
| Description | I updated the LS and ran the script again but ended up with a bunch of IDENTITY_SET OFF error. It is trying to insert some records into 'lime_questions' table with the 'id'. So, I set the IDENTITY_INSERT to ON, restore the DB, ran the scripts, and I still got the same errors. So I ignored it and logged into it, deactivate the survey, change settings, and reactivated it. This time, it activated without any errors. But when I clicked "Next" after the first question, I got the following error. [Microsoft][ODBC SQL Server Driver][SQL Server]The data types text and varchar are incompatible in the equal to operator.:SELECT qid,attribute FROM [lime_question_attributes] WHERE value=lower('cl1') | ||||
| Additional Information | related to 4374 and 4373 | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 8745 | ||||
| I will donate to the project if issue is resolved | |||||
| Browser | Firefox | ||||
| Database type & version | MS SQL Server 2008 | ||||
| Server OS (if known) | Windows Server 2008 | ||||
| Webserver software & version (if known) | IIS 7 | ||||
| PHP Version | 5.2.11 | ||||
| Git branch / Pull Request URL | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-06-09 01:26 | jrowley | New Issue | |
| 2010-06-09 01:26 | jrowley | Status | new => assigned |
| 2010-06-09 01:26 | jrowley | Assigned To | => user372 |
| 2010-06-09 01:26 | jrowley | File Added: limesurvey_survey_49736(2).lss | |
| 2010-06-09 01:57 | jrowley | Note Added: 12207 | |
| 2010-06-10 11:33 | c_schmitz | Note Added: 12211 | |
| 2010-06-10 11:33 | c_schmitz | Status | assigned => resolved |
| 2010-06-10 11:33 | c_schmitz | Fixed in Version | => 1.90RC1 |
| 2010-06-10 11:33 | c_schmitz | Resolution | open => fixed |
| 2010-06-10 11:33 | c_schmitz | Assigned To | user372 => c_schmitz |
| 2010-06-10 11:33 | c_schmitz | Status | resolved => closed |
| 2010-10-25 00:18 | c_schmitz | Category | Survey Taking => (No Category) |