View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
04484Bug reportsStatisticspublic2010-07-16 15:002010-08-18 15:07
Reporterrmmartel Assigned ToMazi  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.90RC2 
Fixed in Version1.90+ 
Summary04484: Unable to view statistics in survey - statistics_user.php warning
Description

When attempting to view the statistics for a survey after completing it an error message from limesurvey/statistics_user.php is displayed.

http://levin3.urban.csuohio.edu/limesurvey/index.php?sid=16134

Steps To Reproduce

Complete the survey,

Click on the link "View the statistics for this survey."

generates error message:

Warning: Invalid argument supplied for foreach() in /var/www/limesurvey/statistics_user.php on line 263

Additional Information

New to LimeSurvey, fresh install.

I originally installed RC1 last week, updated to RC2 yesterday (15 July 2010). Created a simple test survey yesterday - saw this problem the first time through.

I have not yet tried creating a second survey to see if the problem persists. Will try that today time permitting.

MySQL 5.1.44 is running on a separate host - Sun 420R, Solaris 10.

TagsNo tags attached.
Attached Files
results-survey95396.csv (288 bytes)    
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND language='en' ORDER BY gid, title' at line 1:SELECT question, type, other, title FROM lime_questions WHERE qid= AND language='en' ORDER BY gid, title
results-survey95396.csv (288 bytes)   
limesurvey_survey_95396.lss.html (25,899 bytes)    
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Survey</LimeSurveyDocType>
 <DBVersion>143</DBVersion>
 <languages>
  <language>en</language>
 </languages>
 <answers>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>code</fieldname>
   <fieldname>answer</fieldname>
   <fieldname>sortorder</fieldname>
   <fieldname>language</fieldname>
   <fieldname>assessment_value</fieldname>
   <fieldname>scale_id</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[128]]></qid>
    <code><![CDATA[711]]></code>
    <answer><![CDATA[Rheems Fire Department]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <language><![CDATA[en]]></language>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[128]]></qid>
    <code><![CDATA[74]]></code>
    <answer><![CDATA[Elizabethtown Fire Department]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <language><![CDATA[en]]></language>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[128]]></qid>
    <code><![CDATA[75]]></code>
    <answer><![CDATA[Fire Department Mount Joy]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <language><![CDATA[en]]></language>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[128]]></qid>
    <code><![CDATA[79]]></code>
    <answer><![CDATA[Maytown-ED Fire Department]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <language><![CDATA[en]]></language>
    <assessment_value><![CDATA[0]]></assessment_value>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
  </rows>
 </answers>
 <groups>
  <fields>
   <fieldname>gid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>group_name</fieldname>
   <fieldname>group_order</fieldname>
   <fieldname>description</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <gid><![CDATA[21]]></gid>
    <sid><![CDATA[95396]]></sid>
    <group_name><![CDATA[Registration Info]]></group_name>
    <group_order><![CDATA[0]]></group_order>
    <description><![CDATA[]]></description>
    <language><![CDATA[en]]></language>
   </row>
  </rows>
 </groups>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[123]]></qid>
    <sid><![CDATA[95396]]></sid>
    <gid><![CDATA[21]]></gid>
    <type><![CDATA[S]]></type>
    <title><![CDATA[First Name]]></title>
    <question><![CDATA[First Name<br />]]></question>
    <preg><![CDATA[]]></preg>
    <help><![CDATA[]]></help>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[0]]></question_order>
    <language><![CDATA[en]]></language>
    <parent_qid><![CDATA[0]]></parent_qid>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
   </row>
   <row>
    <qid><![CDATA[124]]></qid>
    <sid><![CDATA[95396]]></sid>
    <gid><![CDATA[21]]></gid>
    <type><![CDATA[S]]></type>
    <title><![CDATA[LastName]]></title>
    <question><![CDATA[Last Name<br />]]></question>
    <preg><![CDATA[]]></preg>
    <help><![CDATA[]]></help>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <parent_qid><![CDATA[0]]></parent_qid>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
   </row>
   <row>
    <qid><![CDATA[125]]></qid>
    <sid><![CDATA[95396]]></sid>
    <gid><![CDATA[21]]></gid>
    <type><![CDATA[S]]></type>
    <title><![CDATA[email]]></title>
    <question><![CDATA[Email Address<br />]]></question>
    <preg><![CDATA[]]></preg>
    <help><![CDATA[]]></help>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <parent_qid><![CDATA[0]]></parent_qid>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
   </row>
   <row>
    <qid><![CDATA[128]]></qid>
    <sid><![CDATA[95396]]></sid>
    <gid><![CDATA[21]]></gid>
    <type><![CDATA[L]]></type>
    <title><![CDATA[Fire Department]]></title>
    <question><![CDATA[What fire department are you with?]]></question>
    <preg><![CDATA[]]></preg>
    <help><![CDATA[]]></help>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[3]]></question_order>
    <language><![CDATA[en]]></language>
    <parent_qid><![CDATA[0]]></parent_qid>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
   </row>
  </rows>
 </questions>
 <question_attributes>
  <fields>
   <fieldname>qaid</fieldname>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
  </fields>
  <rows>
   <row>
    <qaid><![CDATA[389]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[suffix]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[313]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[hidden]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[388]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[prefix]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[315]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[page_break]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[387]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[numbers_only]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[317]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[318]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_action]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qaid><![CDATA[319]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_message]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[320]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_message_delay]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[321]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_disable_next]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[322]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_message_style]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[323]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_timer_style]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[324]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_warning]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[325]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_warning_display_time]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[326]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_warning_message]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[327]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[time_limit_warning_style]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[390]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[text_input_width]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[386]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[maximum_chars]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[385]]></qaid>
    <qid><![CDATA[123]]></qid>
    <attribute><![CDATA[display_rows]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[328]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[display_rows]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[329]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[hidden]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[330]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[maximum_chars]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[331]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[page_break]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[332]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[text_input_width]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[333]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[334]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_action]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qaid><![CDATA[335]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_message]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[336]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_message_delay]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[337]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_disable_next]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[338]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_message_style]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[339]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_timer_style]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[340]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_warning]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[341]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_warning_display_time]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[342]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_warning_message]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[343]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[time_limit_warning_style]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[379]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[numbers_only]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[380]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[prefix]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[381]]></qaid>
    <qid><![CDATA[124]]></qid>
    <attribute><![CDATA[suffix]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[344]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[display_rows]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[345]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[hidden]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[346]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[maximum_chars]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[347]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[page_break]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[348]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[text_input_width]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[349]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[350]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_action]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qaid><![CDATA[351]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_message]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[352]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_message_delay]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[353]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_disable_next]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[354]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_message_style]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[355]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_timer_style]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[356]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_warning]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[357]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_warning_display_time]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[358]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_warning_message]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[359]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[time_limit_warning_style]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[382]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[numbers_only]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[383]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[prefix]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[384]]></qaid>
    <qid><![CDATA[125]]></qid>
    <attribute><![CDATA[suffix]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[404]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[alphasort]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[405]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[array_filter]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[406]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[array_filter_exclude]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[407]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[display_columns]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qaid><![CDATA[408]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[hide_tip]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[409]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[hidden]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[410]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[other_comment_mandatory]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[411]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[other_numbers_only]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[412]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[other_replace_text]]></attribute>
    <value><![CDATA[]]></value>
   </row>
   <row>
    <qaid><![CDATA[413]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[page_break]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[414]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[public_statistics]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[415]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[random_order]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qaid><![CDATA[416]]></qaid>
    <qid><![CDATA[128]]></qid>
    <attribute><![CDATA[scale_export]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
  </rows>
 </question_attributes>
 <surveys>
  <fields>
   <fieldname>sid</fieldname>
   <fieldname>admin</fieldname>
   <fieldname>expires</fieldname>
   <fieldname>adminemail</fieldname>
   <fieldname>private</fieldname>
   <fieldname>faxto</fieldname>
   <fieldname>format</fieldname>
   <fieldname>template</fieldname>
   <fieldname>language</fieldname>
   <fieldname>additional_languages</fieldname>
   <fieldname>datestamp</fieldname>
   <fieldname>usecookie</fieldname>
   <fieldname>notification</fieldname>
   <fieldname>allowregister</fieldname>
   <fieldname>allowsave</fieldname>
   <fieldname>autonumber_start</fieldname>
   <fieldname>autoredirect</fieldname>
   <fieldname>allowprev</fieldname>
   <fieldname>printanswers</fieldname>
   <fieldname>ipaddr</fieldname>
   <fieldname>refurl</fieldname>
   <fieldname>listpublic</fieldname>
   <fieldname>htmlemail</fieldname>
   <fieldname>tokenanswerspersistence</fieldname>
   <fieldname>usecaptcha</fieldname>
   <fieldname>bounce_email</fieldname>
   <fieldname>startdate</fieldname>
   <fieldname>publicstatistics</fieldname>
   <fieldname>publicgraphs</fieldname>
   <fieldname>assessments</fieldname>
   <fieldname>usetokens</fieldname>
   <fieldname>attributedescriptions</fieldname>
   <fieldname>emailresponseto</fieldname>
   <fieldname>tokenlength</fieldname>
  </fields>
  <rows>
   <row>
    <sid><![CDATA[95396]]></sid>
    <admin><![CDATA[Phil Colvin]]></admin>
    <expires><![CDATA[]]></expires>
    <adminemail><![CDATA[pacolvin@comcast.net]]></adminemail>
    <private><![CDATA[Y]]></private>
    <faxto><![CDATA[]]></faxto>
    <format><![CDATA[A]]></format>
    <template><![CDATA[FDMJ2]]></template>
    <language><![CDATA[en]]></language>
    <additional_languages><![CDATA[]]></additional_languages>
    <datestamp><![CDATA[N]]></datestamp>
    <usecookie><![CDATA[Y]]></usecookie>
    <notification><![CDATA[0]]></notification>
    <allowregister><![CDATA[N]]></allowregister>
    <allowsave><![CDATA[N]]></allowsave>
    <autonumber_start><![CDATA[0]]></autonumber_start>
    <autoredirect><![CDATA[N]]></autoredirect>
    <allowprev><![CDATA[N]]></allowprev>
    <printanswers><![CDATA[N]]></printanswers>
    <ipaddr><![CDATA[Y]]></ipaddr>
    <refurl><![CDATA[N]]></refurl>
    <listpublic><![CDATA[Y]]></listpublic>
    <htmlemail><![CDATA[Y]]></htmlemail>
    <tokenanswerspersistence><![CDATA[N]]></tokenanswerspersistence>
    <usecaptcha><![CDATA[D]]></usecaptcha>
    <bounce_email><![CDATA[pacolvin@comcast.net]]></bounce_email>
    <startdate><![CDATA[]]></startdate>
    <publicstatistics><![CDATA[Y]]></publicstatistics>
    <publicgraphs><![CDATA[N]]></publicgraphs>
    <assessments><![CDATA[N]]></assessments>
    <usetokens><![CDATA[N]]></usetokens>
    <attributedescriptions><![CDATA[]]></attributedescriptions>
    <emailresponseto><![CDATA[]]></emailresponseto>
    <tokenlength><![CDATA[15]]></tokenlength>
   </row>
  </rows>
 </surveys>
 <surveys_languagesettings>
  <fields>
   <fieldname>surveyls_survey_id</fieldname>
   <fieldname>surveyls_language</fieldname>
   <fieldname>surveyls_title</fieldname>
   <fieldname>surveyls_description</fieldname>
   <fieldname>surveyls_welcometext</fieldname>
   <fieldname>surveyls_urldescription</fieldname>
   <fieldname>surveyls_email_invite_subj</fieldname>
   <fieldname>surveyls_email_invite</fieldname>
   <fieldname>surveyls_email_remind_subj</fieldname>
   <fieldname>surveyls_email_remind</fieldname>
   <fieldname>surveyls_email_register_subj</fieldname>
   <fieldname>surveyls_email_register</fieldname>
   <fieldname>surveyls_email_confirm_subj</fieldname>
   <fieldname>surveyls_email_confirm</fieldname>
   <fieldname>surveyls_url</fieldname>
   <fieldname>surveyls_endtext</fieldname>
   <fieldname>surveyls_dateformat</fieldname>
  </fields>
  <rows>
   <row>
    <surveyls_survey_id><![CDATA[95396]]></surveyls_survey_id>
    <surveyls_language><![CDATA[en]]></surveyls_language>
    <surveyls_title><![CDATA[Paintball Sign Up]]></surveyls_title>
    <surveyls_description><![CDATA[]]></surveyls_description>
    <surveyls_welcometext><![CDATA[<p>Join FDMJ on Saturday, September 4th, as we travel to Conestoga for a day of paintball competition. Ambush will provide everything you need for a day of action in the trenches including marker rentals, face mask&nbsp; and paintballs.&nbsp; Bring your own food for lunch at the field. FDMJ will bring the&nbsp; water. Players are welcome to bring their own paintball gear.</p>
<p>Meet at the field at 0800 hrs. for a pre-game briefing. Play will continue until approximately 1500 hrs. Ambush Paintball is located at 91 Hilltop Drive, Conestoga.</p>
<p><span style="font-size: 16px;"><strong><span>PAYMENT &amp; SIGN-UP DEADLINE: WEDNESDAY 8/18. GIVE INDIVIDUAL OR GROUP DEPT. CHECKS TO TYLER PRICKETT @ FDMJ. CHECKS SHOULD BE MADE PAYABLE TO &quot;FIRE DEPARTMENT MOUNT JOY.&quot; PAYMENT CANNOT BE REFUNDED AFTER THE DEADLINE.</span></strong></span></p>
<p>Additional questions? Call, text, or email Tyler Prickett @ 371-1875 or <a href="mailto:tylerprickett@comcast.net">tylerprickett@comcast.net</a></p>
<p>&nbsp;</p>
<p><strong>DATE: </strong>9/4/2010 (Sat 8:00AM - 3:00PM)<br />
<br />
<strong>LOCATION: </strong>Ambush Paintball, Conestoga<br />
<br />
<br />
If you wish to remove your name please do so prior to Wednesday, 8/18. All funds will be due at that time. All questions can be directed to Tyler Prickett (FDMJ) at (717) 371-1875 or <a href="mailto:tylerprickett@comcast.net">tylerprickett@comcast.net</a>.<br />
&nbsp;</p>]]></surveyls_welcometext>
    <surveyls_urldescription><![CDATA[]]></surveyls_urldescription>
    <surveyls_email_invite_subj><![CDATA[Invitation to participate in survey]]></surveyls_email_invite_subj>
    <surveyls_email_invite><![CDATA[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}]]></surveyls_email_invite>
    <surveyls_email_remind_subj><![CDATA[Reminder to participate in survey]]></surveyls_email_remind_subj>
    <surveyls_email_remind><![CDATA[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}]]></surveyls_email_remind>
    <surveyls_email_register_subj><![CDATA[Survey registration confirmation]]></surveyls_email_register_subj>
    <surveyls_email_register><![CDATA[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}.]]></surveyls_email_register>
    <surveyls_email_confirm_subj><![CDATA[Confirmation of completed survey]]></surveyls_email_confirm_subj>
    <surveyls_email_confirm><![CDATA[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}]]></surveyls_email_confirm>
    <surveyls_url><![CDATA[]]></surveyls_url>
    <surveyls_endtext><![CDATA[<p>Thank you for registering. We will see you on September 4th. Don't forget to get your check to Tyler @ FDMJ no later than 8/18/10.<br />
<br />
<br />
Tyler Prickett,<br />
<br />
FDMJ</p>]]></surveyls_endtext>
    <surveyls_dateformat><![CDATA[9]]></surveyls_dateformat>
   </row>
  </rows>
 </surveys_languagesettings>
</document>
limesurvey_survey_95396.lss.html (25,899 bytes)   
limesurvey_survey_95396.lss (25,899 bytes)
limesurvey_survey_16134.lss (27,294 bytes)
limesurvey_survey_46493.lss (45,224 bytes)
Bug heat8
Complete LimeSurvey version number (& build)8906
I will donate to the project if issue is resolved
BrowserFirefox
Database type & versionMySQL 5.1.44
Server OS (if known)Debian Lenny
Webserver software & version (if known)Apache 2
PHP Version5.2.6-1+lenny8

Users monitoring this issue

rmmartel

Activities

Mazi

Mazi

2010-07-16 15:11

updater   ~12433

Can you please attach your survey so I can test at the latest SVN version?!

Thanks!
Mazi

Mazi

2010-07-19 12:18

updater   ~12456

There will be another RC3 version soon. Please test if the problem is solved then.

user9112

2010-07-29 03:49

  ~12505

I am experiencing the same problem with RC3. See below for error:

Warning: Invalid argument supplied for foreach() in /home/fdmjweb/public_html/limesurvey/statistics_user.php on line 263

1.9 RC3 Build 8963
Firefox
DB=MySQL 5.1.47
OS Unix
Web Server Apache 2.2.15
PHP Version 5.2.13
Mazi

Mazi

2010-07-29 09:36

updater   ~12507

Can you please export the test survey as .csv file so I can import it on my test system which runs the latest code base from SVN!?

Thanks!
rmmartel

rmmartel

2010-07-29 14:39

reporter   ~12509

I will try with RC3 to see if I still have the problem and attach a copy of the survey once I figure out how.

user9112

2010-07-29 14:56

  ~12510

I uploaded the results as a .csv and an .lss file. Let me know if you need anything else.
Mazi

Mazi

2010-07-29 15:51

updater   ~12511

I need the survey structure which can be exported as .lss file, see: http://docs.limesurvey.org/tiki-index.php?page=Exporting+a+survey+structure&amp;structure=English+Instructions+for+LimeSurvey

If possible a link to the public statstics of a problematic survey would also be nice.

user9112

2010-07-29 19:33

  ~12513

I have uploaded the .lss file for the survey. The link that can be used is http://www.fdmj.com/limesurvey/. This will open the available surveys page. Click the View Statistics link next to the survey and you will see the error we are receiving.
rmmartel

rmmartel

2010-07-29 21:05

reporter   ~12514

Updated to RC3 - problem persists.
Uploaded limesurvey_survey_16134.lss which came from

http://levin3.urban.csuohio.edu/limesurvey/ (A first test)

http://levin3.urban.csuohio.edu/limesurvey/index.php?sid=16134
rmmartel

rmmartel

2010-07-29 21:47

reporter   ~12515

Created a second simple survey. Uploaded its lss file. Same issue as the first when attempt to view stats as end of survey:

Warning: Invalid argument supplied for foreach() in /var/www/limesurvey/statistics_user.php on line 263
Mazi

Mazi

2010-07-29 22:56

updater   ~12516

Last edited: 2010-07-29 22:57

I tested the last 3 files you both attached. At all surveys no question was set to be displayed at public statistics. This has to be set at the advanced settings tab of each question.
Did you forget to set it there or was this changed/overwritten when I imported your files?

Here are some details instructions:
"The new feature to show statistics to the user at the end of a survey was introduced in version 1.80RC3. Using this feature the user is presented a link at the end of the survey which takes him to the public statistics.

There are two important settings. At first you have to [url=http://docs.limesurvey.org/tiki-index.php?page=Creating+a+new+survey#Presentation_amp_Navigation]enable public statistics for your current survey[/url] at survey settings -> presentation & navigation -> Public statistics.
Because often you only want to show statistics for certain questions there is an [url=http://docs.limesurvey.org/tiki-index.php?page=Question+attributes#public_statistics]additional question attribute "public_statistics"[/url] . This question attribute has to be applied to all questions which should be shown to the user. Note that the use of this question attribute is limited to certain question types (see list at manual -> question attributes -> public_statistics).
Furthermore it is possible to [url=http://docs.limesurvey.org/tiki-index.php?page=Creating+a+new+survey#Presentation_amp_Navigation]set if the public statistics should contain graphs[/url] . This can also be set individually for each survey at survey settings -> presentation & navigation -> public graphs"
rmmartel

rmmartel

2010-08-17 19:02

reporter   ~12648

That seems to have corrected the issue for me. Seems the package should fail more gracefully than showing an error message to the end user.

Thanks very much for Limesurvey, the helpful pointers and for looking into this problem!
Mazi

Mazi

2010-08-18 15:06

updater   ~12652

rmmartel, you're welcome!

If our hints have been helpful and you enjoy limesurvey please consider a donation to the team: http://donate.limesurvey.org/
We do all this in our free time and you don't have to pay a penny for this software.

Without your help we can't keep this project alive.

Issue History

Date Modified Username Field Change
2010-07-16 15:00 rmmartel New Issue
2010-07-16 15:01 rmmartel Issue Monitored: rmmartel
2010-07-16 15:11 Mazi Note Added: 12433
2010-07-16 15:11 Mazi Assigned To => Mazi
2010-07-16 15:11 Mazi Status new => feedback
2010-07-19 12:18 Mazi Note Added: 12456
2010-07-29 03:49 user9112 Note Added: 12505
2010-07-29 03:50 user9112 Issue Monitored: user9112
2010-07-29 09:36 Mazi Note Added: 12507
2010-07-29 14:39 rmmartel Note Added: 12509
2010-07-29 14:39 rmmartel Status feedback => assigned
2010-07-29 14:54 user9112 File Added: results-survey95396.csv
2010-07-29 14:54 user9112 File Added: limesurvey_survey_95396.lss.html
2010-07-29 14:56 user9112 Note Added: 12510
2010-07-29 15:51 Mazi Note Added: 12511
2010-07-29 15:53 Mazi Status assigned => feedback
2010-07-29 19:33 user9112 Note Added: 12513
2010-07-29 19:33 user9112 File Added: limesurvey_survey_95396.lss
2010-07-29 21:03 rmmartel File Added: limesurvey_survey_16134.lss
2010-07-29 21:05 rmmartel Note Added: 12514
2010-07-29 21:05 rmmartel Status feedback => assigned
2010-07-29 21:46 rmmartel File Added: limesurvey_survey_46493.lss
2010-07-29 21:47 rmmartel Note Added: 12515
2010-07-29 22:56 Mazi Note Added: 12516
2010-07-29 22:57 Mazi Status assigned => feedback
2010-07-29 22:57 Mazi Note Edited: 12516
2010-08-17 19:02 rmmartel Note Added: 12648
2010-08-17 19:02 rmmartel Status feedback => assigned
2010-08-18 15:06 Mazi Note Added: 12652
2010-08-18 15:07 Mazi Status assigned => closed
2010-08-18 15:07 Mazi Resolution open => fixed
2010-08-18 15:07 Mazi Fixed in Version => 1.90+
2021-08-03 15:59 guest Bug heat 6 => 8