View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04894 | Bug reports | Response browsing | public | 2011-01-22 08:47 | 2011-01-26 22:10 |
Reporter | starmonkey | Assigned To | DenisChenu | ||
Priority | high | Severity | block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.91RC2 | ||||
Fixed in Version | 1.91RC3 | ||||
Summary | 04894: Changing "display" to "Completed responses only" = SQL syntax error | ||||
Description | As per the summary. Admin cannot proceed once this issue is triggered. | ||||
Steps To Reproduce | 1) Go to browse a survey's responses Couldn't pull response data | ||||
Additional Information | I fixed it by adding a line to admin/browse.php: $sql_where = ""; // SM 22Jan11: Fix to add WHERE clause if needed. //LETS COUNT THE DATA $dtresult=db_execute_num($dtquery) or safe_die("Couldn't pull response data<br />{$dtquery}<br />".$connect->ErrorMsg()); I generally prefer generating sql in more robust methods, but that's my quick fix. | ||||
Tags | No tags attached. | ||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 191 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox, Chrome | ||||
Database type & version | MySQL5 | ||||
Server OS (if known) | Ubuntu 10.04 | ||||
Webserver software & version (if known) | Apache2 | ||||
PHP Version | PHP5 | ||||
Note the build is Version 1.91RC2 Build 9672 (latest download) |
|
Thanks ! Fixed with: :) http://limesurvey.svn.sourceforge.net/viewvc/limesurvey?view=revision&revision=9711 |
|
Released. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2011-01-22 08:47 | starmonkey | New Issue | |
2011-01-22 09:12 | starmonkey | Note Added: 13954 | |
2011-01-22 18:55 | DenisChenu | Assigned To | => DenisChenu |
2011-01-22 18:55 | DenisChenu | Status | new => assigned |
2011-01-22 18:58 | DenisChenu | Status | assigned => resolved |
2011-01-22 18:58 | DenisChenu | Fixed in Version | => 1.91RC3 |
2011-01-22 18:58 | DenisChenu | Resolution | open => fixed |
2011-01-22 18:59 | DenisChenu | Issue Monitored: DenisChenu | |
2011-01-22 19:01 | DenisChenu | Note Added: 13957 | |
2011-01-26 22:10 | c_schmitz | Note Added: 13968 | |
2011-01-26 22:10 | c_schmitz | Status | resolved => closed |
2011-03-01 11:58 | DenisChenu | Relationship added | related to 04929 |
2021-08-03 07:27 | guest | Bug heat | 6 => 8 |