LimeSurvey bugs, patches and feature requests - Bug reports
View Issue Details
04929Bug reports[All Projects] Response browsingpublic2011-02-04 14:352011-04-14 00:01
user11933 
lemeur 
highcrashhave not tried
closedfixed 
1.91RC3 
1.91RC41.91RC5 
No
9715
Firefox 4.0 Beta
Mysql 5.0
Linux infong 2.4 #1
Apache/1.3.41 Ben-SSL/1.59
PHP Version 5.2.17
04929: crash by pressing "show answers" in "answers and statistics"
Couldn'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
I'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:
admin.php?action=browse&sid=26621&subaction=all
No tags attached.
related to 04894closed DenisChenu Changing "display" to "Completed responses only" = SQL syntax error 
gz testsurvey.sql.gz (65,644) 2011-02-10 09:02
http://bugs.limesurvey.org/file_download.php?file_id=3724&type=bug
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

Notes
(14105)
Mazi   
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
(14124)
jcleeland   
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?
(14127)
user11933   
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.
(14318)
lemeur   
2011-03-07 18:04   
I've already fixed such a bug it was published in 1.91RC4.
Can you check again ?
(14472)
lemeur   
2011-03-20 07:54   
feedback ??
(14493)
user11933   
2011-03-21 08:26   
sorry for late feedback, yes its resolved.
(14510)
Mazi   
2011-03-22 16:23   
Fixed at 1.91RCx