LimeSurvey bugs, patches and feature requests - Bug reports |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 04929 | Bug reports | [All Projects] Response browsing | public | 2011-02-04 14:35 | 2011-04-14 00:01 |
|
| Reporter | user11933 | |
| Assigned To | lemeur | |
| Priority | high | Severity | crash | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | | OS Version | |
| Product Version | 1.91RC3 | |
| Target Version | 1.91RC4 | Fixed in Version | 1.91RC5 | |
| I will donate to the project if issue is resolved within 48 hrs | No |
| LimeSurvey build number | 9715 |
| Browser | Firefox 4.0 Beta |
| Database & DB-Version | Mysql 5.0 |
| Operating System (Server) | Linux infong 2.4 #1 |
| Webserver software & version | Apache/1.3.41 Ben-SSL/1.59 |
| PHP Version | PHP Version 5.2.17 |
|
| Summary | 04929: 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
|
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | 04894 | closed | DenisChenu | Changing "display" to "Completed responses only" = SQL syntax error |
|
| Attached Files |  testsurvey.sql.gz (65,644) 2011-02-10 09:02
http://bugs.limesurvey.org/file_download.php?file_id=3724&type=bug |
|
| 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 |
|
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 |
|
|
|
|
|
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
|
|
|
|
|
(14493)
|
|
user11933
|
|
2011-03-21 08:26
|
|
|
sorry for late feedback, yes its resolved. |
|
|
|
(14510)
|
|
Mazi
|
|
2011-03-22 16:23
|
|
|