View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04330 | Bug reports | Statistics | public | 2010-05-10 17:40 | 2010-07-20 22:16 |
Reporter | Mazi | Assigned To | tpartner | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.90b | ||||
Target Version | 1.90RC1 | Fixed in Version | 1.90RC3 | ||
Summary | 04330: SQL error when trying to view public statistics | ||||
Description | When clicking the "View the statistics for this survey." link at the end of the attached survey I only get the header as shown at the screenshot but no data is shown. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 8 | ||||
Complete LimeSurvey version number (& build) | 8704 | ||||
I will donate to the project if issue is resolved | |||||
Browser | |||||
Database type & version | MySQL 5 | ||||
Server OS (if known) | Win 7 | ||||
Webserver software & version (if known) | Apache 2.2 | ||||
PHP Version | 5.3.1 | ||||
Make sure you have at least one question where the show in public statistics attribute of the question is set to yes. |
|
That might have been the course. I suggest to do a check if there is a question attribute set for at least one question of the survey. If not we shouldn't present the link at all. When having set the according question attribute for 2-3 questions and trying to run the public statistics again (having just updated to latest SVN version), I get the following warnings: Notice: Undefined index: lid in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 249 Notice: Undefined index: lid1 in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 250 Notice: Undefined index: lid in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 255 Notice: Undefined index: lid1 in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 256 Notice: Undefined index: lid in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 249 Notice: Undefined index: lid1 in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 250 Notice: Undefined index: lid in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 255 Notice: Undefined index: lid1 in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 256 Notice: Undefined index: lid in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 249 Notice: Undefined index: lid1 in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 250 Notice: Undefined index: lid in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 255 Notice: Undefined index: lid1 in C:\xampp\htdocs\limeSOURCE\limesurvey_svn\statistics_user.php on line 256 The table overview only lists the "other" field, no graphs are shown: |
|
Same here... public statistics is not adapted for the new subquestion stuff... trying to make use of the admin function now. |
|
Got it sort of fixed, but need to strip the browse button from the statistics. Anything else that is different in admin <-> public statistics? |
|
I committed a fix in 8770 to use the same code as the admin function does. I left out the browse buttons but please test as I don't know what to expect as I don't use statistics myself. I think the lsrc will be broken for statistics as generate_statistics with option 'all' needs to be updated like in statistics user too. |
|
I tested and the error messages mentioned above are gone. The header doesn'l look that nice yet, see attached screen shot. Maybe Tony can lay his magic hands on it? |
|
After having talked to Menno we decided that Tony is next :-) Can you have a look if/how we can make the output a little nicer? Afterwards please assign the ticket to rakete, because of Menno's changed the LSRC might be broken, he has to check. Thanks! |
|
Mazi I'm still getting PHP errors - see my screenshot. The first error is using the attached limesurvey_survey_85389.lss with only the first question displayed in public stats. The second error is using the attached limesurvey_survey_51184.lss - a single numeric question survey. I can tidy up the table styles a bit but it will need to be done in all shipped templates. Do you want me to go ahead with that before the PHP errors are fixed? |
|
Here's another snag. When using the attached limesurvey_survey_85389.lss with only the first question (semantic slider) set to show in public stats, there is no indication of which sub-question is being summarized, See my screenshot - field_summary_title_1.png. |
|
Thanks for the further testing. My simple survey only contained very few questions so there are probably further problems to solve. Menno, can you have another look? It is up to you if you want to improve the layout/design now or at a later stage when all problems are fiexed. |
|
It must be a bug in the exported survey or your install as for my sample survey it works fine... i did not import the attached survey |
|
Okay, thanks Menno. I got it and will send it to rakete when I'm done. |
|
I fixed the public graphs notice. |
|
I'm closing this ticket because it deals with several issues meanwhile. I opened the following new topics, please take a look: 4289: Umlauts not correctly displayed at public statistics. 4473: Admin Statistics: "Undefined variable: atext" notice at sample survey Please create new tickets if one of the problems mentioned here isn't solved yet. Thanks for all your help! |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2010-05-10 17:40 | Mazi | New Issue | |
2010-05-10 17:40 | Mazi | Status | new => assigned |
2010-05-10 17:40 | Mazi | Assigned To | => c_schmitz |
2010-05-10 17:40 | Mazi | File Added: limesurvey_survey_85389.lss | |
2010-05-10 17:40 | Mazi | File Added: stats_public.PNG | |
2010-05-10 18:54 | machaven | Assigned To | c_schmitz => machaven |
2010-05-31 14:51 | mdekker | Note Added: 12041 | |
2010-05-31 14:51 | mdekker | Assigned To | machaven => mdekker |
2010-05-31 15:29 | Mazi | Note Added: 12042 | |
2010-05-31 15:44 | mdekker | Note Added: 12043 | |
2010-06-01 10:24 | mdekker | Note Added: 12047 | |
2010-06-01 14:13 | mdekker | Note Added: 12048 | |
2010-06-01 14:13 | mdekker | Assigned To | mdekker => Mazi |
2010-06-01 14:13 | mdekker | Status | assigned => feedback |
2010-06-01 14:40 | Mazi | Note Added: 12049 | |
2010-06-01 14:40 | Mazi | Status | feedback => assigned |
2010-06-01 14:40 | Mazi | File Added: public stats header.PNG | |
2010-06-01 14:42 | Mazi | Assigned To | Mazi => tpartner |
2010-06-01 14:43 | Mazi | Note Added: 12050 | |
2010-06-01 15:38 | tpartner | File Added: limesurvey_survey_51184.lss | |
2010-06-01 15:39 | tpartner | File Added: php_errors_1.png | |
2010-06-01 15:47 | tpartner | Note Added: 12059 | |
2010-06-01 16:06 | tpartner | File Added: field_summary_title_1.png | |
2010-06-01 16:09 | tpartner | Note Added: 12063 | |
2010-06-01 16:17 | Mazi | Note Added: 12064 | |
2010-06-01 16:17 | Mazi | Assigned To | tpartner => mdekker |
2010-06-01 19:15 | mdekker | Note Added: 12067 | |
2010-06-02 01:20 | tpartner | Assigned To | mdekker => tpartner |
2010-06-02 01:21 | tpartner | Note Added: 12074 | |
2010-06-04 12:35 | machaven | Note Added: 12153 | |
2010-07-13 02:53 | Mazi | Note Added: 12404 | |
2010-07-13 02:54 | Mazi | Status | assigned => resolved |
2010-07-13 02:54 | Mazi | Fixed in Version | => 1.90RC3 |
2010-07-13 02:54 | Mazi | Resolution | open => fixed |
2010-07-20 22:16 | c_schmitz | Status | resolved => closed |