View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
04929Bug reportsResponse browsingpublic2011-02-04 14:352011-04-14 00:01
Reporteruser11933Assigned Tolemeur  
PriorityhighSeverityblock 
Status closedResolutionfixed 
Product Version1.91RC3 
Target Version1.91RC4Fixed in Version1.91RC5 
Summary04929: crash by pressing "show answers" in "answers and statistics"
Description

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

Steps To Reproduce

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

TagsNo tags attached.
Attached Files
testsurvey.sql.gz (65,644 bytes)
Bug heat8
Complete LimeSurvey version number (& build)9715
I will donate to the project if issue is resolvedNo
BrowserFirefox 4.0 Beta
Database type & versionMysql 5.0
Server OS (if known)Linux infong 2.4 #1
Webserver software & version (if known)Apache/1.3.41 Ben-SSL/1.59
PHP VersionPHP Version 5.2.17

Relationships

Relationship GraphDependency Graph
related to 04894 closedDenisChenu Changing "display" to "Completed responses only" = SQL syntax error 

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2011-02-09 15:53

updater   ~14105

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
jcleeland

jcleeland

2011-02-10 04:44

reporter   ~14124

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?

user11933

2011-02-10 09:03

  ~14127

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.
lemeur

lemeur

2011-03-07 18:04

developer   ~14318

I've already fixed such a bug it was published in 1.91RC4.
Can you check again ?
lemeur

lemeur

2011-03-20 07:54

developer   ~14472

feedback ??

user11933

2011-03-21 08:26

  ~14493

sorry for late feedback, yes its resolved.
Mazi

Mazi

2011-03-22 16:23

updater   ~14510

Fixed at 1.91RCx

Issue History

Date Modified Username Field Change
2011-02-04 14:35 user11933 New Issue
2011-02-09 15:53 Mazi Note Added: 14105
2011-02-09 15:53 Mazi Assigned To => DenisChenu
2011-02-09 15:53 Mazi Status new => feedback
2011-02-09 15:53 Mazi Target Version => 1.91RC4
2011-02-10 04:43 jcleeland Assigned To DenisChenu => jcleeland
2011-02-10 04:43 jcleeland Status feedback => assigned
2011-02-10 04:44 jcleeland Note Added: 14124
2011-02-10 09:02 user11933 File Added: testsurvey.sql.gz
2011-02-10 09:03 user11933 Note Added: 14127
2011-02-15 21:24 c_schmitz Assigned To jcleeland => lemeur
2011-03-01 11:58 DenisChenu Relationship added related to 04894
2011-03-07 18:04 lemeur Note Added: 14318
2011-03-07 18:04 lemeur Status assigned => feedback
2011-03-20 07:54 lemeur Note Added: 14472
2011-03-21 08:26 user11933 Note Added: 14493
2011-03-21 08:26 user11933 Status feedback => assigned
2011-03-22 16:23 Mazi Note Added: 14510
2011-03-22 16:23 Mazi Status assigned => resolved
2011-03-22 16:23 Mazi Fixed in Version => 1.91RC5
2011-03-22 16:23 Mazi Resolution open => fixed
2011-04-14 00:01 c_schmitz Status resolved => closed