LimeSurvey bugs and feature requests - Bug reports
View Issue Details
04929Bug reports[All Projects] Response browsingpublic2011-02-04 14:352011-04-14 00:01
Assigned Tolemeur 
PriorityhighSeveritycrashReproducibilityhave not tried
PlatformOSOS Version
Product Version1.91RC3 
Target Version1.91RC4Fixed in Version1.91RC5 
Complete LimeSurvey version number (& build)9715
I will donate to the project if issue is resolvedNo
BrowserFirefox 4.0 Beta
Database & DB-VersionMysql 5.0
Operating System (Server)Linux infong 2.4 #1
Webserver software & versionApache/1.3.41 Ben-SSL/1.59
PHP VersionPHP Version 5.2.17
Summary04929: crash by pressing "show answers" in "answers and statistics"
DescriptionCouldn't get response data
SELECT count(*) FROM `lime_survey_26621` LEFT JOIN lime_tokens_26621 ON `lime_survey_26621`.token = lime_tokens_26621.token submitdate IS NOT NULL WHERE submitdate IS NOT NULL
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 'submitdate IS NOT NULL WHERE submitdate IS NOT NULL' at line 1
Steps To ReproduceI've made exports from a survey answers. everthing was ok.
I left to the admin main menu and then i gone back to the "show answers" option.
But now i get the following Database Error
By pressing on the link:
TagsNo tags attached.
related to 04894closed DenisChenu Changing "display" to "Completed responses only" = SQL syntax error 
Attached Filesgz testsurvey.sql.gz (65,644) 2011-02-10 09:02

2011-02-09 15:53   
Can you always reproduce the problem with every active survey and these steps?

1. I've made exports from a survey answers. everthing was ok.
2. I left to the admin main menu and then i gone back to the "show answers" option.
3. But now i get the following Database Error
2011-02-10 04:44   
Hi, I've been unable to reproduce this issue, can you please export the survey where the error is occuring so I can try and replicate it using that?
2011-02-10 09:03   
since this error, i don't made changes on limesurvey. But if i want to login now, i get the error "Invalid survey id"
I upload a SQL Dump from the Survey.
This SQL Dump contains the tables: answers,conditions,defaultvalues,groups,questions,question,attributes,surveys,surveys_languagesettings,survey_26621
Drop Table Option is included, so it should overwrite a clean installation.
I hope it helps to reproduce.
2011-03-07 18:04   
I've already fixed such a bug it was published in 1.91RC4.
Can you check again ?
2011-03-20 07:54   
feedback ??
2011-03-21 08:26   
sorry for late feedback, yes its resolved.
2011-03-22 16:23   
Fixed at 1.91RCx

Issue History
2011-02-04 14:35user11933New Issue
2011-02-09 15:53MaziNote Added: 14105
2011-02-09 15:53MaziAssigned To => DenisChenu
2011-02-09 15:53MaziStatusnew => feedback
2011-02-09 15:53MaziTarget Version => 1.91RC4
2011-02-10 04:43jcleelandAssigned ToDenisChenu => jcleeland
2011-02-10 04:43jcleelandStatusfeedback => assigned
2011-02-10 04:44jcleelandNote Added: 14124
2011-02-10 09:02user11933File Added: testsurvey.sql.gz
2011-02-10 09:03user11933Note Added: 14127
2011-02-15 21:24c_schmitzAssigned Tojcleeland => lemeur
2011-03-01 11:58DenisChenuRelationship addedrelated to 04894
2011-03-07 18:04lemeurNote Added: 14318
2011-03-07 18:04lemeurStatusassigned => feedback
2011-03-20 07:54lemeurNote Added: 14472
2011-03-21 08:26user11933Note Added: 14493
2011-03-21 08:26user11933Statusfeedback => assigned
2011-03-22 16:23MaziNote Added: 14510
2011-03-22 16:23MaziStatusassigned => resolved
2011-03-22 16:23MaziFixed in Version => 1.91RC5
2011-03-22 16:23MaziResolutionopen => fixed
2011-04-14 00:01c_schmitzStatusresolved => closed