View Issue Details

IDProjectCategoryView StatusLast Update
13664Bug reports[All Projects] Central participant databasepublic2018-05-16 12:14
Reporteramunizp Assigned Toollehar  
Status closedResolutionfixed 
Product Version 
Target VersionFixed in Version3.7.x 
Summary13664: internal server error sql

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 'DOUBLE)) as stdev, SUM(CAST(519275X7X21 AS DOUBLE)*1) as sum, AVG(CAST(`519275' at line 1

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.
2018-05-11 04:59:48

Steps To Reproduce

Survey list> statistics button

TagsNo tags attached.
Complete LimeSurvey version number (& build)professional
I will donate to the project if issue is resolvedYes
Database & DB-Versionprofessional
Server OS (if known)professional
Webserver software & version (if known)professional
PHP Versionprofessional




2018-05-11 13:31

reporter   ~47584

I have the same problem, see my bug report ""



2018-05-16 10:41

administrator   ~47596

This should have been fixed now. Please try again.



2018-05-16 11:16

reporter   ~47597

Hello olle!

How can this be fixed, I have no update with the comfort update?

Kind regards,


Issue History

Date Modified Username Field Change
2018-05-11 06:03 amunizp New Issue
2018-05-11 13:31 Einkauf.ZIT Note Added: 47584
2018-05-16 10:41 ollehar Note Added: 47596
2018-05-16 10:41 ollehar Status new => feedback
2018-05-16 11:16 Einkauf.ZIT Note Added: 47597
2018-05-16 12:14 ollehar Assigned To => ollehar
2018-05-16 12:14 ollehar Status feedback => closed
2018-05-16 12:14 ollehar Resolution open => fixed
2018-05-16 12:14 ollehar Fixed in Version => 3.7.x