View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
08793Bug reportsResponse browsingpublic2014-03-03 10:132014-03-11 17:51
Reporterkesako Assigned Toc_schmitz  
PriorityurgentSeveritycrash 
Status closedResolutionunable to reproduce 
Product Version2.05+ 
Summary08793: SQL error in ending of questionnary
Description

hello,

I have do a questionnary, but but after users have completed this questionnaire , they have this error

Internal Server Error
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 'and sid=344271' at line 1

How to resolve this ?

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)140302
I will donate to the project if issue is resolvedNo
BrowserAll
Database type & versionMySQL: 5.1.49
Server OS (if known)Debian
Webserver software & version (if known)Apache 2.0 Handler
PHP Version5.3.3-7+squeeze15
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-03-03 10:44

administrator   ~29069

Please activate debug mode in /application/config/config.php
, reproduce it and attach the full error message as HTML file.
Also attach your survey as .lss file.
Thank you.
c_schmitz

c_schmitz

2014-03-11 16:33

administrator   ~29192

Feedback please?
kesako

kesako

2014-03-11 16:51

reporter   ~29194

Last edited: 2014-03-11 16:52

Woups . Sorry, Sorry and Sorry .

Finaly, I have do a new questionnary with same question and I didn't was problem's. I don't know why but now survey questions works good .
kesako

kesako

2014-03-11 16:52

reporter   ~29195

The problem's are resolved

Issue History

Date Modified Username Field Change
2014-03-03 10:13 kesako New Issue
2014-03-03 10:44 c_schmitz Note Added: 29069
2014-03-03 10:44 c_schmitz Assigned To => c_schmitz
2014-03-03 10:44 c_schmitz Status new => feedback
2014-03-11 16:33 c_schmitz Note Added: 29192
2014-03-11 16:51 kesako Note Added: 29194
2014-03-11 16:51 kesako Status feedback => assigned
2014-03-11 16:52 kesako Note Edited: 29194
2014-03-11 16:52 kesako Note Added: 29195
2014-03-11 17:51 c_schmitz Status assigned => closed
2014-03-11 17:51 c_schmitz Resolution open => unable to reproduce