View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05311 | Bug reports | Response browsing | public | 2011-06-29 09:02 | 2011-07-08 17:15 |
| Reporter | jungstar | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.91+ | ||||
| Fixed in Version | 1.91+ | ||||
| Summary | 05311: SQL Error when trying to download a file of a survey response | ||||
| Description | The system produces a SQL error when the admin wants to download a file of a survey response. | ||||
| Steps To Reproduce |
=> Everything results in an SQL error | ||||
| Additional Information | ERROR: syntax error at or near "X195X4491" LINE 1: SELECT 54177X195X4491 , 54177X195X4492 FROM "lime_survey_5... ^:SELECT 54177X195X4491 , 54177X195X4492 FROM "lime_survey_54177" WHERE id=2 For me it seems that quotation marks for the column names are missing (quoted identifier). | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 10315 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | PostgreSQL 8.3 | ||||
| Server OS (if known) | Ubuntu 8.04 | ||||
| Webserver software & version (if known) | Apache/2.2.8 | ||||
| PHP Version | PHP/5.2.4-2 | ||||
| Git branch / Pull Request URL | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-06-29 09:02 | jungstar | New Issue | |
| 2011-06-29 13:27 | c_schmitz | Assigned To | => c_schmitz |
| 2011-06-29 13:27 | c_schmitz | Status | new => assigned |
| 2011-07-03 11:59 | c_schmitz | Note Added: 15620 | |
| 2011-07-03 11:59 | c_schmitz | Status | assigned => resolved |
| 2011-07-03 11:59 | c_schmitz | Fixed in Version | => 1.91+ |
| 2011-07-03 11:59 | c_schmitz | Resolution | open => fixed |
| 2011-07-08 17:15 | c_schmitz | Note Added: 15690 | |
| 2011-07-08 17:15 | c_schmitz | Status | resolved => closed |