View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
06070Bug reportsData Entry (non public)public2012-05-07 15:342012-05-10 20:46
Reporteruser19739Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.00b1 
Fixed in Version2.00RC1 
Summary06070: Sql error after adding a condition
Description

Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '((871546X1X1.NAOK == \"\"))'' WHERE qid=2' at line 1. The SQL statement executed was: UPDATE lime_questions SET relevance=''((871546X1X1.NAOK == \"\"))'' WHERE qid=2

Steps To Reproduce

With two question,
within Add Condition of second question, select first question, select constant, write 1, click add condition, get this error

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)120406
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql 5.5.23-1
Server OS (if known)debian 6.0.4
Webserver software & version (if known)Apache 2.2.16
PHP Version5.3.11

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-05-10 20:46

administrator   ~18670

2.00RC1 released.

Issue History

Date Modified Username Field Change
2012-05-07 15:34 user19739 New Issue
2012-05-07 21:03 c_schmitz Status new => resolved
2012-05-07 21:03 c_schmitz Fixed in Version => 2.00RC1
2012-05-07 21:03 c_schmitz Resolution open => fixed
2012-05-07 21:03 c_schmitz Assigned To => c_schmitz
2012-05-10 20:46 c_schmitz Note Added: 18670
2012-05-10 20:46 c_schmitz Status resolved => closed