View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04029 | Bug reports | Statistics | public | 2010-01-02 17:06 | 2010-01-24 23:56 |
| Reporter | Assigned To | gandalfar | |||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 1.87RC5 | ||||
| Summary | 04029: PostgreSQL syntax errors : PG 8.3 refuses implicit casts from char to int | ||||
| Description | hi folks, I'm trying to get a full statitics page for a specific survey from : /admin/admin.php?action=statistics#start If i ask the stats for a few questions it's ok, but if i want to "View summary of all available fields" i get the following error : Couldn't get question | ||||
| Additional Information | the problem lies at the line 1352 of admin/statistics_function.php : For some reason the $rqid variable is set to "" (empty string) but the qid column is and integer. The implicit conversion of $rquid in integer might work with MySQL and old PostgreSQL versions, but modern PostgreSQL don't do these conversions anymore. IMHO the best way to avoid that bug is to explicitly cast the qid inside the php code. Here's my patch : 1339c1339
| ||||
| Tags | No tags attached. | ||||
| Bug heat | 6 | ||||
| Complete LimeSurvey version number (& build) | |||||
| I will donate to the project if issue is resolved | |||||
| Browser | |||||
| Database type & version | 8.3.9 | ||||
| Server OS (if known) | |||||
| Webserver software & version (if known) | |||||
| PHP Version | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-01-02 17:06 |
|
New Issue | |
| 2010-01-02 17:06 |
|
Status | new => assigned |
| 2010-01-02 17:06 |
|
Assigned To | => user372 |
| 2010-01-02 17:06 |
|
Database & DB-Version | => 8.3.9 |
| 2010-01-03 19:47 |
|
Assigned To | user372 => rakete |
| 2010-01-05 21:50 |
|
Issue Monitored: gandalfar | |
| 2010-01-12 22:13 |
|
Assigned To | rakete => gandalfar |
| 2010-01-14 16:53 | c_schmitz | Note Added: 10780 | |
| 2010-01-24 22:32 | gandalfar | Note Added: 10870 | |
| 2010-01-24 23:56 | c_schmitz | Status | assigned => closed |
| 2010-01-24 23:56 | c_schmitz | Resolution | open => unable to reproduce |