View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 0
IDProjectCategoryView StatusDate SubmittedLast Update
05947Bug reportsImport/Exportpublic2012-03-23 17:342012-03-23 22:01
Reporterpdaubresse Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary05947: Error when importing a survey
Description

I configured a limesurvey server to use Microsoft SQL Server 2008 as database engine. I tried to import a survey in .lss format into my server, but I get the error: "[Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: int is incompatible with text:UPDATE [questions] SET relevance=1 WHERE qid=787"
Apparently, it happens when updating table "limesurvey_questions". The SQL tries to assign value 1 to column "relevance". On my database "relevance" is of type "text", and the SQL syntax tries to assign a int value. Normally on MS SQL Server, you have to use '1' (single quotes are mandatory) for assigning an int value to a text column.
Could you tell me how to modify the SQL syntax in order to add the single quotes?

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)120311
I will donate to the project if issue is resolvedNo
BrowserIE
Database type & versionMS SQL Server 2008
Server OS (if known)Windows Server 2008R2
Webserver software & version (if known)IIS7
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2012-03-23 17:34 pdaubresse New Issue
2012-03-23 22:01 c_schmitz Status new => resolved
2012-03-23 22:01 c_schmitz Fixed in Version => 1.92+
2012-03-23 22:01 c_schmitz Resolution open => fixed
2012-03-23 22:01 c_schmitz Assigned To => c_schmitz
2012-03-23 22:01 c_schmitz Status resolved => closed