View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04340 | Bug reports | Statistics | public | 2010-05-14 08:04 | 2010-06-08 21:51 |
| Reporter | ddiazmon | Assigned To | machaven | ||
| Priority | urgent | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.90b | ||||
| Summary | 04340: Database tables lack a colum which is being asked for in "statistics_user.php" | ||||
| Description | The program has a bug whenever I try to see the statistics of the survey, it says the following: Couldn't get question I know a little bit about MySQL therefore checked the table 'questions' and effectively found out that there are no fields listed as 'lid' or 'lid1' as the code on "www.domain.com/survey/admin/admin.php?action=statistics#start" or let's refer to it as "admin.php". However, I can see in the "questions" table in the MySQL database that there are the following fields: 'parent_qid' , 'sid' , 'gid' , which I believe that might have been substituted with 'lid' and 'lid1'. | ||||
| Steps To Reproduce | Perform a complete survey, activate it, and then you hit the "Browse Response for this Survey". Then you hit the "Get Statistics from this survey" button. On the "General Filters" section when you check the "View summary of all available fields" checkbox or on the "Response Filter" section when you check any of the checkboxes, and then hit the "View Stats" button, you get the following message: Couldn't get question Also I must mention that when you check the "Show graphs" check box in the "General Filters" section and hit the "View Stats" button, no graphs are being brought up or any other information is being brought up besides the following: Results That is no relevant data as percentages of the answers of a question were answered, etc, which is the main purpose of the software. The same problem happens when you have available surveys in your home page and decide to hit the "View Statistics" link. There appears the following message: Couldn't get question | ||||
| Additional Information | I believe that the solution is just to substitute the fieldnames in MySQL with the ones on "admin.php" and "statistics_user.php" or viceversa, whatever is less tedious. Good luck, I think that your software is in the right track. Hope you can fix those bugs. | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 8708 | ||||
| I will donate to the project if issue is resolved | |||||
| Browser | Firefox | ||||
| Database type & version | MySQL 5.0.86-log | ||||
| Server OS (if known) | Windows | ||||
| Webserver software & version (if known) | dandim.db.4730981.hostedresource.com | ||||
| PHP Version | PHP Version 5.2.5 | ||||
| Git branch / Pull Request URL | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-05-14 08:04 | ddiazmon | New Issue | |
| 2010-05-14 08:04 | ddiazmon | Status | new => assigned |
| 2010-05-14 08:04 | ddiazmon | Assigned To | => user372 |
| 2010-05-14 13:54 | Mazi | Assigned To | user372 => machaven |
| 2010-05-14 13:54 | Mazi | Note Added: 11814 | |
| 2010-06-04 10:57 | machaven | Status | assigned => resolved |
| 2010-06-04 10:57 | machaven | Resolution | open => fixed |
| 2010-06-08 21:51 | c_schmitz | Status | resolved => closed |