View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
04340Bug reportsStatisticspublic2010-06-08 21:51
Reporterddiazmon Assigned Tomachaven  
PriorityurgentSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.90b 
Summary04340: 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
SELECT title, type, question, qid, lid, lid1, other FROM questions WHERE qid='6' AND parent_qid=0 and language='es'
Unknown column 'lid' in 'field list'

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
SELECT title, type, question, qid, lid, lid1, other FROM questions WHERE qid='6' AND parent_qid=0 and language='es'
Unknown column 'lid' in 'field list'

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
Number of query records: 2
Total survey records: 2
Total Percentage: 100.00%

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
SELECT title, type, question, qid, lid, lid1, other FROM questions WHERE qid='6' AND language='es'
Unknown column 'lid' in 'field list'

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.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)8708
I will donate to the project if issue is resolved
BrowserFirefox
Database type & versionMySQL 5.0.86-log
Server OS (if known)Windows
Webserver software & version (if known)dandim.db.4730981.hostedresource.com
PHP VersionPHP Version 5.2.5
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2010-05-14 13:54

updater   ~11814

Machaven, can you check if this is just a duplicate of one of the errors you fixed recently?!

Issue History

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