View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05128 | Bug reports | Response browsing | public | 2011-04-26 04:35 | 2011-05-15 12:26 |
| Reporter | medicnick | Assigned To | c_schmitz | ||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.91RC6 | ||||
| Fixed in Version | 1.91+ | ||||
| Summary | 05128: Survey timings table is empty and mssql error | ||||
| Description | The survey timings table is now being created for MSSQL when a new survey is created but the table is empty although the survey response table has two entries. Also, browse.php between line 1031 and 1041 has two scripts calling for a NATURAL JOIN". In MSSQL a natural join is not allowed so I think an inner join should be used. The first point may not have anything to do with the second point but I discovered them at the same time. With an empty timings table there is nothing to return so I can't verify if the second point is handled properly. If you prefer a separate report please let me know. | ||||
| Steps To Reproduce | Clicked on view survey statistics which resulted in the following error message: "Couldn't get response data | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 10018 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | FF4 | ||||
| Database type & version | MSSQL R2 | ||||
| Server OS (if known) | WIN 2008 | ||||
| Webserver software & version (if known) | IIS7.5 | ||||
| PHP Version | 5.2.5 | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2011-04-26 04:35 | medicnick | New Issue | |
| 2011-04-28 14:44 | c_schmitz | Assigned To | => c_schmitz |
| 2011-04-28 14:44 | c_schmitz | Status | new => assigned |
| 2011-05-06 17:23 | c_schmitz | Note Added: 14939 | |
| 2011-05-06 17:23 | c_schmitz | Status | assigned => resolved |
| 2011-05-06 17:23 | c_schmitz | Fixed in Version | => 1.91+ |
| 2011-05-06 17:23 | c_schmitz | Resolution | open => fixed |
| 2011-05-15 12:26 | c_schmitz | Status | resolved => closed |
