View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04325 | Bug reports | Statistics | public | 2010-05-10 14:35 | 2010-05-21 19:05 |
| Reporter | Assigned To | machaven | |||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.90b | ||||
| Fixed in Version | 1.90RC1 | ||||
| Summary | 04325: Problem when generating statistics | ||||
| Description | On beta 1.90, I have a survey and want to generate statistics from the responses. Couldn't get question This happens when I make a random selection in the 'response filters' section. When I don't make any selections there, I do get statistics, but I only get 'xx responses (100%)' and nothing more, no info per question whatsoever. | ||||
| Steps To Reproduce | 1) Go to admin The above error then appears. | ||||
| Tags | No tags attached. | ||||
| Attached Files | limesurvey_survey_83993-4193.csv (14,259 bytes)
# LimeSurvey Survey Dump
# DBVersion 142
# This is a dumped survey from the LimeSurvey Script
# http://www.limesurvey.org/
# Do not change this header!
#
# SURVEYS TABLE
#
"sid","owner_id","admin","active","expires","startdate","adminemail","private","faxto","format","template","language","additional_languages","datestamp","usecookie","notification","allowregister","allowsave","autonumber_start","autoredirect","allowprev","printanswers","ipaddr","refurl","datecreated","publicstatistics","publicgraphs","listpublic","htmlemail","tokenanswerspersistence","assessments","usecaptcha","usetokens","bounce_email","attributedescriptions","emailresponseto","tokenlength"
"83993","1","admin","Y","","","cavila@detma.org","Y","","S","sherpa","en","","N","N","0","N","Y","6","Y","Y","N","N","N","2010-03-08","N","N","N","Y","N","N","D","N","cavila@detma.org","","","15"
#
# GROUPS TABLE
#
"gid","sid","group_name","group_order","description","language"
"2","83993","Task Specific","0","","en"
"3","83993","Overall","1","","en"
#
# QUESTIONS TABLE
#
"qid","sid","gid","type","title","question","preg","help","other","mandatory","lid","lid1","question_order","language"
"4","83993","2","L","0001","The training met my expectations<br />","","","N","Y","0","0","0","en"
"5","83993","2","L","0002","I will be able to apply the knowledge learned<br />","","","N","Y","0","0","1","en"
"6","83993","2","L","0003","<p lang=""en-GB"" style=""margin-bottom: 0in;""><font face=""Arial, sans-serif"">The training objectives for each topic were identified and followed.</font></p>","","","N","Y","0","0","2","en"
"7","83993","2","L","0004","<p lang=""en-GB"" style=""margin-bottom: 0in;""><font face=""Arial, sans-serif"">The content was organized and easy to follow</font></p>","","","N","Y","0","0","3","en"
"8","83993","2","L","0005","<p lang=""en-GB"" style=""margin-bottom: 0in;""><font face=""Arial, sans-serif"">The materials distributed were pertinent and useful.</font></p>","","","N","Y","0","0","4","en"
"9","83993","2","L","0006","<p lang=""en-GB"" style=""margin-bottom: 0in;""><font face=""Arial, sans-serif"">The trainer was knowledgeable.</font></p>","","","N","Y","0","0","5","en"
"10","83993","2","L","0007","<p lang=""en-GB"" style=""margin-bottom: 0in;""><font face=""Arial, sans-serif"">The quality of instruction was good.</font></p>","","","N","Y","0","0","6","en"
"11","83993","2","L","0008","<p lang=""en-GB"" style=""margin-bottom: 0in;""><font face=""Arial, sans-serif"">The trainer met the training objectives.</font></p>","","","N","Y","0","0","7","en"
"12","83993","2","L","0009","<p lang=""en-GB"" style=""margin-bottom: 0in;""><font face=""Arial, sans-serif"">Class participation and interaction were encouraged.</font></p>","","","N","Y","0","0","8","en"
"13","83993","2","L","0010","<p lang=""en-GB"" style=""margin-bottom: 0in;""><font face=""Arial, sans-serif"">Adequate time was provided for questions and discussion.</font></p>","","","N","Y","0","0","9","en"
"14","83993","3","L","0001","<p lang=""en-GB"" style=""margin-left: -0.25in; text-indent: 0.25in; margin-bottom: 0in;""><font face=""Arial, sans-serif"">How do you rate the training overall?</font></p>","","","N","Y","0","0","0","en"
"15","83993","3","S","0002","<p style=""margin-bottom: 0in;""><font face=""Arial, sans-serif""><span lang=""en-GB"">What aspects of the training could be improved?</span></font></p>","","","N","Y","0","0","1","en"
"16","83993","3","S","0003","Other Comments?<br />","","","N","N","0","0","2","en"
#
# ANSWERS TABLE
#
"qid","code","answer","default_value","assessment_value","sortorder","language"
"6","01","Strongly Agree","N","0","1","en"
"6","02","Agree","N","0","2","en"
"6","03","Neutral","N","0","3","en"
"6","04","Disagree","N","0","4","en"
"6","05","Strongly Disagree","N","0","5","en"
"5","01","Strongly Agree","N","0","1","en"
"5","02","Agree","N","0","2","en"
"5","03","Neutral","N","0","3","en"
"5","04","Disagree","N","0","4","en"
"5","05","Strongl Disagree","N","0","5","en"
"4","01","Strongly Agree","N","0","1","en"
"4","02","Agree","N","0","2","en"
"4","03","Neutral","N","0","3","en"
"4","04","Disagree","N","0","4","en"
"4","05","Strongly Disagree","N","0","5","en"
"7","01","Strongly Agree","N","0","1","en"
"7","02","Agree","N","0","2","en"
"7","03","Neutral","N","0","3","en"
"7","04","Disagree","N","0","4","en"
"7","05","Strongly Disagree","N","0","5","en"
"8","01","Strongly Agree","N","0","1","en"
"8","02","Agree","N","0","2","en"
"8","03","Neutral","N","0","3","en"
"8","04","Disagree","N","0","4","en"
"8","05","Strongly Disagree","N","0","5","en"
"9","01","Strongly Agree","N","0","1","en"
"9","02","Agree","N","0","2","en"
"9","03","Neutral","N","0","3","en"
"9","04","Disagree","N","0","4","en"
"9","05","Strongly Disagree","N","0","5","en"
"10","01","Strongly Agree","N","0","1","en"
"10","02","Agree","N","0","2","en"
"10","03","Neutral","N","0","3","en"
"10","04","Disagree","N","0","4","en"
"10","05","Strongly Disagree","N","0","5","en"
"11","01","Strongly Agree","N","0","1","en"
"11","02","Agree","N","0","2","en"
"11","03","Neutral","N","0","3","en"
"11","04","Disagree","N","0","4","en"
"11","05","Strongly Disagree","N","0","5","en"
"12","01","Strongly Agree","N","0","1","en"
"12","02","Agree","N","0","2","en"
"12","03","Neutral","N","0","3","en"
"12","04","Disagree","N","0","4","en"
"12","05","Strongly Disagree","N","0","5","en"
"13","01","Strongly Agree","N","0","1","en"
"13","02","Agree","N","0","2","en"
"13","03","Neutral","N","0","3","en"
"13","04","Disagree","N","0","4","en"
"13","05","Strongly Disagree","N","0","5","en"
"14","01","Excellent","N","0","1","en"
"14","02","Good","N","0","2","en"
"14","03","Average","N","0","3","en"
"14","04","Poor","N","0","4","en"
"14","05","Very Poor","N","0","5","en"
#
# CONDITIONS TABLE
#
#
# LABELSETS TABLE
#
#
# LABELS TABLE
#
#
# QUESTION_ATTRIBUTES TABLE
#
"qaid","qid","attribute","value"
"70","6","display_columns","1"
"69","6","array_filter_exclude",""
"68","6","array_filter",""
"67","6","alphasort","0"
"66","4","scale_export","0"
"65","4","other_replace_text",""
"64","4","other_numbers_only","0"
"63","4","other_comment_mandatory","0"
"62","4","hide_tip","0"
"61","4","display_columns","1"
"59","5","scale_export","0"
"58","5","random_order","0"
"57","5","public_statistics","0"
"56","5","page_break","0"
"55","5","other_replace_text",""
"54","5","other_numbers_only","0"
"53","5","other_comment_mandatory","0"
"52","5","hidden","0"
"51","5","hide_tip","0"
"50","5","display_columns","1"
"49","5","array_filter_exclude",""
"48","5","array_filter",""
"47","5","alphasort","0"
"46","4","random_order","0"
"45","4","public_statistics","0"
"44","4","page_break","0"
"43","4","hidden","0"
"42","4","array_filter_exclude",""
"41","4","array_filter",""
"60","4","alphasort","0"
"71","6","hide_tip","0"
"72","6","hidden","0"
"73","6","other_comment_mandatory","0"
"74","6","other_numbers_only","0"
"75","6","other_replace_text",""
"76","6","page_break","0"
"77","6","public_statistics","0"
"78","6","random_order","0"
"79","6","scale_export","0"
"80","7","alphasort","0"
"81","7","array_filter",""
"82","7","array_filter_exclude",""
"83","7","display_columns","1"
"84","7","hide_tip","0"
"85","7","hidden","0"
"86","7","other_comment_mandatory","0"
"87","7","other_numbers_only","0"
"88","7","other_replace_text",""
"89","7","page_break","0"
"90","7","public_statistics","0"
"91","7","random_order","0"
"92","7","scale_export","0"
"93","8","alphasort","0"
"94","8","array_filter",""
"95","8","array_filter_exclude",""
"96","8","display_columns","1"
"97","8","hide_tip","0"
"98","8","hidden","0"
"99","8","other_comment_mandatory","0"
"100","8","other_numbers_only","0"
"101","8","other_replace_text",""
"102","8","page_break","0"
"103","8","public_statistics","0"
"104","8","random_order","0"
"105","8","scale_export","0"
"106","9","alphasort","0"
"107","9","array_filter",""
"108","9","array_filter_exclude",""
"109","9","display_columns","1"
"110","9","hide_tip","0"
"111","9","hidden","0"
"112","9","other_comment_mandatory","0"
"113","9","other_numbers_only","0"
"114","9","other_replace_text",""
"115","9","page_break","0"
"116","9","public_statistics","0"
"117","9","random_order","0"
"118","9","scale_export","0"
"119","10","alphasort","0"
"120","10","array_filter",""
"121","10","array_filter_exclude",""
"122","10","display_columns","1"
"123","10","hide_tip","0"
"124","10","hidden","0"
"125","10","other_comment_mandatory","0"
"126","10","other_numbers_only","0"
"127","10","other_replace_text",""
"128","10","page_break","0"
"129","10","public_statistics","0"
"130","10","random_order","0"
"131","10","scale_export","0"
"132","11","alphasort","0"
"133","11","array_filter",""
"134","11","array_filter_exclude",""
"135","11","display_columns","1"
"136","11","hide_tip","0"
"137","11","hidden","0"
"138","11","other_comment_mandatory","0"
"139","11","other_numbers_only","0"
"140","11","other_replace_text",""
"141","11","page_break","0"
"142","11","public_statistics","0"
"143","11","random_order","0"
"144","11","scale_export","0"
"145","12","alphasort","0"
"146","12","array_filter",""
"147","12","array_filter_exclude",""
"148","12","display_columns","1"
"149","12","hide_tip","0"
"150","12","hidden","0"
"151","12","other_comment_mandatory","0"
"152","12","other_numbers_only","0"
"153","12","other_replace_text",""
"154","12","page_break","0"
"155","12","public_statistics","0"
"156","12","random_order","0"
"157","12","scale_export","0"
"158","13","alphasort","0"
"159","13","array_filter",""
"160","13","array_filter_exclude",""
"161","13","display_columns","1"
"162","13","hide_tip","0"
"163","13","hidden","0"
"164","13","other_comment_mandatory","0"
"165","13","other_numbers_only","0"
"166","13","other_replace_text",""
"167","13","page_break","0"
"168","13","public_statistics","0"
"169","13","random_order","0"
"170","13","scale_export","0"
"171","14","alphasort","0"
"172","14","array_filter",""
"173","14","array_filter_exclude",""
"174","14","display_columns","1"
"175","14","hide_tip","0"
"176","14","hidden","0"
"177","14","other_comment_mandatory","0"
"178","14","other_numbers_only","0"
"179","14","other_replace_text",""
"180","14","page_break","0"
"181","14","public_statistics","0"
"182","14","random_order","0"
"183","14","scale_export","0"
"184","15","display_rows",""
"185","15","hidden","0"
"186","15","maximum_chars",""
"187","15","numbers_only","0"
"188","15","page_break","0"
"189","15","prefix",""
"190","15","suffix",""
"191","15","text_input_width",""
"192","15","time_limit",""
"193","15","time_limit_action","1"
"194","15","time_limit_message",""
"195","15","time_limit_message_delay",""
"196","15","time_limit_disable_next","0"
"197","15","time_limit_message_style",""
"198","15","time_limit_timer_style",""
"199","15","time_limit_warning",""
"200","15","time_limit_warning_display_time",""
"201","15","time_limit_warning_message",""
"202","15","time_limit_warning_style",""
"203","16","display_rows",""
"204","16","hidden","0"
"205","16","maximum_chars",""
"206","16","numbers_only","0"
"207","16","page_break","0"
"208","16","prefix",""
"209","16","suffix",""
"210","16","text_input_width",""
"211","16","time_limit",""
"212","16","time_limit_action","1"
"213","16","time_limit_message",""
"214","16","time_limit_message_delay",""
"215","16","time_limit_disable_next","0"
"216","16","time_limit_message_style",""
"217","16","time_limit_timer_style",""
"218","16","time_limit_warning",""
"219","16","time_limit_warning_display_time",""
"220","16","time_limit_warning_message",""
"221","16","time_limit_warning_style",""
#
# ASSESSMENTS TABLE
#
#
# SURVEYS_LANGUAGESETTINGS TABLE
#
"surveyls_survey_id","surveyls_language","surveyls_title","surveyls_description","surveyls_welcometext","surveyls_endtext","surveyls_url","surveyls_urldescription","surveyls_email_invite_subj","surveyls_email_invite","surveyls_email_remind_subj","surveyls_email_remind","surveyls_email_register_subj","surveyls_email_register","surveyls_email_confirm_subj","surveyls_email_confirm","surveyls_dateformat"
"83993","en","QUEST class 03.08.2010","Generic QUEST class evaluation survey.<br />","Please indicate your impressions of the QUEST class you attended. <br />","Thank you for participating in this survey. Your feedback is important to us.<br />","http://intranet.detma.org/limesurvey/","","Invitation to participate in survey","Dear {FIRSTNAME},<br /><br />You have been invited to participate in a survey.<br /><br />The survey is titled:<br />""{SURVEYNAME}""<br /><br />""{SURVEYDESCRIPTION}""<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}","Reminder to participate in survey","Dear {FIRSTNAME},<br /><br />Recently we invited you to participate in a survey.<br /><br />We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.<br /><br />The survey is titled:<br />""{SURVEYNAME}""<br /><br />""{SURVEYDESCRIPTION}""<br /><br />To participate, please click on the link below.<br /><br />Sincerely,<br /><br />{ADMINNAME} ({ADMINEMAIL})<br /><br />----------------------------------------------<br />Click here to do the survey:<br />{SURVEYURL}","Survey registration confirmation","Dear {FIRSTNAME},<br /><br />You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br /><br />To complete this survey, click on the following URL:<br /><br />{SURVEYURL}<br /><br />If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.","Confirmation of completed survey","Dear {FIRSTNAME},<br /><br />This email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br /><br />If you have any further questions about this email, please contact {ADMINNAME} at {ADMINEMAIL}.<br /><br />Sincerely,<br /><br />{ADMINNAME}","9"
#
# QUOTA TABLE
#
#
# QUOTA_MEMBERS TABLE
#
#
# QUOTA_LANGUAGESETTINGS TABLE
#
| ||||
| Bug heat | 8 | ||||
| Complete LimeSurvey version number (& build) | 8691 | ||||
| I will donate to the project if issue is resolved | |||||
| Browser | any | ||||
| Database type & version | MySQL | ||||
| Server OS (if known) | Linux | ||||
| Webserver software & version (if known) | Apache | ||||
| PHP Version | PHP 5 | ||||
 |
When testing using the latest 1.90beta version I receive a similar erro without even setting any filters: "Couldn't get text question Sample survey and screenshot attached. |
 |
Did some more testing and this is really critical since it is impossible to generate any statistics at all (except for export to Excel or SPSS but I really like the built-in statistics just fine). |
 |
Fixed in SVN |
 |
1.90 beta3 release |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-05-10 14:35 |
|
New Issue | |
| 2010-05-10 14:35 |
|
Status | new => assigned |
| 2010-05-10 14:35 |
|
Assigned To | => user372 |
| 2010-05-10 17:32 | Mazi | Note Added: 11753 | |
| 2010-05-10 17:33 | Mazi | File Added: limesurvey_survey_83993-4193.csv | |
| 2010-05-10 17:33 | Mazi | File Added: statistics_filter.PNG | |
| 2010-05-10 17:34 | Mazi | Assigned To | user372 => c_schmitz |
| 2010-05-10 18:55 | machaven | Assigned To | c_schmitz => machaven |
| 2010-05-10 20:10 |
|
Note Added: 11757 | |
| 2010-05-12 07:32 | machaven | Note Added: 11783 | |
| 2010-05-12 07:32 | machaven | Status | assigned => resolved |
| 2010-05-12 07:32 | machaven | Fixed in Version | => 1.90RC1 |
| 2010-05-12 07:32 | machaven | Resolution | open => fixed |
| 2010-05-21 19:05 | lemeur | Note Added: 11929 | |
| 2010-05-21 19:05 | lemeur | Status | resolved => closed |
