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 |