View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
10923Bug reportsStatisticspublic2016-04-15 10:24
Reporterasshank Assigned Toollehar  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.50.x 
Fixed in Version2.50.x 
Summary10923: statistics of questiontype array(numbers) not working
Description

'Show statistics' breaks down if the survey contains the questiontype array (numbers).
It tries to load unavailable fields.
see example. The question has 2 rows, 1 column.
the statistic-function always tries to load 1 column to much.
eg.: the field xxx1_2 is loaded, while the's only one column.
eg: the field xxx1_3 if there are 2 columns.

error message:

CDbCommand faalde tijdens het uitvoeren van volgend SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '796195X15X2891_2' in 'where clause'

Steps To Reproduce

load attached survey, fill in the question, submit, click 'show statistics'.

TagsNo tags attached.
Attached Files
limesurvey_survey_796195 statistics.lss (14,907 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Survey</LimeSurveyDocType>
 <DBVersion>258</DBVersion>
 <languages>
  <language>nl</language>
 </languages>
 <groups>
  <fields>
   <fieldname>gid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>group_name</fieldname>
   <fieldname>group_order</fieldname>
   <fieldname>description</fieldname>
   <fieldname>language</fieldname>
   <fieldname>randomization_group</fieldname>
   <fieldname>grelevance</fieldname>
  </fields>
  <rows>
   <row>
    <gid><![CDATA[15]]></gid>
    <sid><![CDATA[796195]]></sid>
    <group_name><![CDATA[A]]></group_name>
    <group_order><![CDATA[0]]></group_order>
    <description/>
    <language><![CDATA[nl]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
  </rows>
 </groups>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_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>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[289]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[796195]]></sid>
    <gid><![CDATA[15]]></gid>
    <type><![CDATA[:]]></type>
    <title><![CDATA[arraygetallen]]></title>
    <question><![CDATA[test van array getallen
]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
  </rows>
 </questions>
 <subquestions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_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>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[290]]></qid>
    <parent_qid><![CDATA[289]]></parent_qid>
    <sid><![CDATA[796195]]></sid>
    <gid><![CDATA[15]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[1]]></title>
    <question><![CDATA[Keuze1]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[291]]></qid>
    <parent_qid><![CDATA[289]]></parent_qid>
    <sid><![CDATA[796195]]></sid>
    <gid><![CDATA[15]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[1]]></title>
    <question><![CDATA[Mooi]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[1]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[292]]></qid>
    <parent_qid><![CDATA[289]]></parent_qid>
    <sid><![CDATA[796195]]></sid>
    <gid><![CDATA[15]]></gid>
    <type><![CDATA[T]]></type>
    <title><![CDATA[2]]></title>
    <question><![CDATA[Keuze2]]></question>
    <other><![CDATA[N]]></other>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[nl]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
  </rows>
 </subquestions>
 <question_attributes>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[289]]></qid>
    <attribute><![CDATA[multiflexible_checkbox]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[289]]></qid>
    <attribute><![CDATA[public_statistics]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
  </rows>
 </question_attributes>
 <surveys>
  <fields>
   <fieldname>sid</fieldname>
   <fieldname>admin</fieldname>
   <fieldname>expires</fieldname>
   <fieldname>startdate</fieldname>
   <fieldname>adminemail</fieldname>
   <fieldname>anonymized</fieldname>
   <fieldname>faxto</fieldname>
   <fieldname>format</fieldname>
   <fieldname>savetimings</fieldname>
   <fieldname>template</fieldname>
   <fieldname>language</fieldname>
   <fieldname>additional_languages</fieldname>
   <fieldname>datestamp</fieldname>
   <fieldname>usecookie</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>publicstatistics</fieldname>
   <fieldname>publicgraphs</fieldname>
   <fieldname>listpublic</fieldname>
   <fieldname>htmlemail</fieldname>
   <fieldname>sendconfirmation</fieldname>
   <fieldname>tokenanswerspersistence</fieldname>
   <fieldname>assessments</fieldname>
   <fieldname>usecaptcha</fieldname>
   <fieldname>usetokens</fieldname>
   <fieldname>bounce_email</fieldname>
   <fieldname>attributedescriptions</fieldname>
   <fieldname>emailresponseto</fieldname>
   <fieldname>emailnotificationto</fieldname>
   <fieldname>tokenlength</fieldname>
   <fieldname>showxquestions</fieldname>
   <fieldname>showgroupinfo</fieldname>
   <fieldname>shownoanswer</fieldname>
   <fieldname>showqnumcode</fieldname>
   <fieldname>bouncetime</fieldname>
   <fieldname>bounceprocessing</fieldname>
   <fieldname>bounceaccounttype</fieldname>
   <fieldname>bounceaccounthost</fieldname>
   <fieldname>bounceaccountpass</fieldname>
   <fieldname>bounceaccountencryption</fieldname>
   <fieldname>bounceaccountuser</fieldname>
   <fieldname>showwelcome</fieldname>
   <fieldname>showprogress</fieldname>
   <fieldname>questionindex</fieldname>
   <fieldname>navigationdelay</fieldname>
   <fieldname>nokeyboard</fieldname>
   <fieldname>alloweditaftercompletion</fieldname>
   <fieldname>googleanalyticsstyle</fieldname>
   <fieldname>googleanalyticsapikey</fieldname>
  </fields>
  <rows>
   <row>
    <sid><![CDATA[796195]]></sid>
    <admin><![CDATA[Joost Assendelft]]></admin>
    <adminemail><![CDATA[joost@assendelft.net]]></adminemail>
    <anonymized><![CDATA[N]]></anonymized>
    <faxto/>
    <format><![CDATA[G]]></format>
    <savetimings><![CDATA[N]]></savetimings>
    <template><![CDATA[default]]></template>
    <language><![CDATA[nl]]></language>
    <additional_languages/>
    <datestamp><![CDATA[N]]></datestamp>
    <usecookie><![CDATA[N]]></usecookie>
    <allowregister><![CDATA[N]]></allowregister>
    <allowsave><![CDATA[Y]]></allowsave>
    <autonumber_start><![CDATA[0]]></autonumber_start>
    <autoredirect><![CDATA[N]]></autoredirect>
    <allowprev><![CDATA[N]]></allowprev>
    <printanswers><![CDATA[N]]></printanswers>
    <ipaddr><![CDATA[N]]></ipaddr>
    <refurl><![CDATA[N]]></refurl>
    <publicstatistics><![CDATA[Y]]></publicstatistics>
    <publicgraphs><![CDATA[N]]></publicgraphs>
    <listpublic><![CDATA[N]]></listpublic>
    <htmlemail><![CDATA[N]]></htmlemail>
    <sendconfirmation><![CDATA[Y]]></sendconfirmation>
    <tokenanswerspersistence><![CDATA[N]]></tokenanswerspersistence>
    <assessments><![CDATA[N]]></assessments>
    <usecaptcha><![CDATA[N]]></usecaptcha>
    <usetokens><![CDATA[N]]></usetokens>
    <bounce_email><![CDATA[joost@assendelft.net]]></bounce_email>
    <emailresponseto/>
    <emailnotificationto/>
    <tokenlength><![CDATA[15]]></tokenlength>
    <showxquestions><![CDATA[Y]]></showxquestions>
    <showgroupinfo><![CDATA[B]]></showgroupinfo>
    <shownoanswer><![CDATA[N]]></shownoanswer>
    <showqnumcode><![CDATA[X]]></showqnumcode>
    <bounceprocessing><![CDATA[N]]></bounceprocessing>
    <showwelcome><![CDATA[Y]]></showwelcome>
    <showprogress><![CDATA[Y]]></showprogress>
    <questionindex><![CDATA[0]]></questionindex>
    <navigationdelay><![CDATA[0]]></navigationdelay>
    <nokeyboard><![CDATA[N]]></nokeyboard>
    <alloweditaftercompletion><![CDATA[N]]></alloweditaftercompletion>
    <googleanalyticsstyle><![CDATA[0]]></googleanalyticsstyle>
    <googleanalyticsapikey/>
   </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_endtext</fieldname>
   <fieldname>surveyls_url</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_dateformat</fieldname>
   <fieldname>surveyls_attributecaptions</fieldname>
   <fieldname>email_admin_notification_subj</fieldname>
   <fieldname>email_admin_notification</fieldname>
   <fieldname>email_admin_responses_subj</fieldname>
   <fieldname>email_admin_responses</fieldname>
   <fieldname>surveyls_numberformat</fieldname>
   <fieldname>attachments</fieldname>
  </fields>
  <rows>
   <row>
    <surveyls_survey_id><![CDATA[796195]]></surveyls_survey_id>
    <surveyls_language><![CDATA[nl]]></surveyls_language>
    <surveyls_title><![CDATA[test2]]></surveyls_title>
    <surveyls_description><![CDATA[test2]]></surveyls_description>
    <surveyls_welcometext/>
    <surveyls_endtext/>
    <surveyls_url/>
    <surveyls_urldescription/>
    <surveyls_email_invite_subj><![CDATA[Uitnodiging om deel te nemen aan een enquête]]></surveyls_email_invite_subj>
    <surveyls_email_invite><![CDATA[Geachte {FIRSTNAME},

U wordt uitgenodigd om deel te nemen aan een enquête.

De titel van de enquête is:
'{SURVEYNAME}'

'{SURVEYDESCRIPTION}'

Om aan de enquête deel te nemen kunt u op onderstaande link klikken.

Hoogachtend,

{ADMINNAME} ({ADMINEMAIL})

----------------------------------------------
Klik op 
{SURVEYURL}
 om aan het onderzoek deel te nemen.

Als u deze enquête niet wilt invullen en ook geen nieuwe uitnodigingen wilt ontvangen, klik dan a.u.b. op de volgende link: {OPTOUTURL}

Als u bent uitgesloten, maar toch deze enquête wilt invullen en ook nieuwe uitnodigingen wilt ontvangen, klik dan a.u.b. op de volgende link:
 {OPTINURL} ]]></surveyls_email_invite>
    <surveyls_email_remind_subj><![CDATA[Herinnering om deel te nemen aan een enquête]]></surveyls_email_remind_subj>
    <surveyls_email_remind><![CDATA[Geachte {FIRSTNAME},

Recent bent u uitgenodigd om aan een onderzoek deel te nemen.

We hebben geconstateerd dat u nog niet aan het onderzoek hebt deelgenomen en willen u er bij dezen aan herinneren dat het onderzoek nog loopt en dat u, als u dat wilt, nog kan deelnemen. 

Het onderzoek is getiteld: 
''{SURVEYNAME}"

''{SURVEYDESCRIPTION}"

Om deel te nemen klikt u op onderstaande link. 

Hoogachtend,

{ADMINNAME} ({ADMINEMAIL})

----------------------------------------------
Klik op:
{SURVEYURL} om aan het onderzoek deel te nemen.

Als u deze enquête niet wilt invullen en ook geen nieuwe uitnodigingen wilt ontvangen, klik dan a.u.b. op de volgende link: {OPTOUTURL}]]></surveyls_email_remind>
    <surveyls_email_register_subj><![CDATA[Bevestiging registratie enquête]]></surveyls_email_register_subj>
    <surveyls_email_register><![CDATA[Geachte {FIRSTNAME},

U, of iemand die uw e-mailadres gebruikt, heeft zich aangemeld voor deelname aan het online onderzoek getiteld {SURVEYNAME}.

Klik op onderstaande link om aan het onderzoek mee te doen:

{SURVEYURL}

Als u vragen heeft over de enquête, of als u zich niet heeft aangemeld voor deelname en meent dat u deze e-mail ten onrechte heeft ontvangen, kunt u contact opnemen met {ADMINNAME} via {ADMINEMAIL}.]]></surveyls_email_register>
    <surveyls_email_confirm_subj><![CDATA[Bevestiging van uw deelname aan onze enquête]]></surveyls_email_confirm_subj>
    <surveyls_email_confirm><![CDATA[Beste {FIRSTNAME},

Dit e-mail bericht bevestigt dat u de enquête {SURVEYNAME} heeft ingevuld en dat uw antwoorden zijn opgeslagen. Hartelijk dank voor uw deelname.

Als u vragen heeft over deze e-mail, neemt u dan contact op met de beheerder {ADMINNAME} via {ADMINEMAIL}.

Hoogachtend,

{ADMINNAME}]]></surveyls_email_confirm>
    <surveyls_dateformat><![CDATA[2]]></surveyls_dateformat>
    <email_admin_notification_subj><![CDATA[Respons inzending op enquête {SURVEYNAME}]]></email_admin_notification_subj>
    <email_admin_notification><![CDATA[Hallo,

Er is een nieuwe respons voor de enquête '{SURVEYNAME}'.

Klik op de volgende link om de enquête de herladen:
{RELOADURL}

Klik op de volgende link om de individuele enquête te bekijken:
{VIEWRESPONSEURL}

Klik op de volgende link om de individuele reactie te bewerken:
{EDITRESPONSEURL}

Bekijk de statistieken door hier te klikken:
{STATISTICSURL}]]></email_admin_notification>
    <email_admin_responses_subj><![CDATA[Respons inzending op enquête {SURVEYNAME} met resultaten]]></email_admin_responses_subj>
    <email_admin_responses><![CDATA[Hallo,

Er is een nieuwe respons voor  de enquête '{SURVEYNAME}'.

Klik op de volgende link om de enquête te herladen:
{RELOADURL}

Klik op de volgende link om de individuele reactie te bekijken:
{VIEWRESPONSEURL}

Klik op de volgende link om de individuele reactie te bewerken:
{EDITRESPONSEURL}

Bekijk statistieken door hier te klikken:
{STATISTICSURL}


De volgende antwoorden zijn door de deelnemer gegeven:
{ANSWERTABLE}]]></email_admin_responses>
    <surveyls_numberformat><![CDATA[1]]></surveyls_numberformat>
   </row>
  </rows>
 </surveys_languagesettings>
</document>
vvexport_796195.xlsx (9,745 bytes)
Bug heat8
Complete LimeSurvey version number (& build)20160412
I will donate to the project if issue is resolvedNo
Browservarious
Database type & versionmysql 5.5.48-33
Server OS (if known)apache 2.4.6
Webserver software & version (if known)Centos 6.7
PHP Version5.4.45-53

Users monitoring this issue

asshank

Activities

ollehar

ollehar

2016-04-12 12:09

administrator   ~37257

Cannot reproduce. Did you get the error with the survey you attached?

ollehar

ollehar

2016-04-12 12:53

administrator   ~37258

I see a bug with foreign language and dual-scale array, but that's probably not the same thing as you see.

asshank

asshank

2016-04-12 13:29

reporter   ~37260

Hi Olle,
is this of any help?
http://lsfvp.bbvz.nl/jbo_lime/index.php/796195?lang=nl

regards,
joost

ollehar

ollehar

2016-04-12 13:34

administrator   ~37262

Hm, not really. Can you enable debug=2 in config.php, reload the page and give me the stack-trace?

asshank

asshank

2016-04-12 14:23

reporter   ~37263

New link, debug=2
http://lime25.assendelfthankes.nl/index.php/796195?lang=nl

ollehar

ollehar

2016-04-12 14:25

administrator   ~37264

Great, but you would need to go to statistics and look for the error. :) Then paste it here.

asshank

asshank

2016-04-12 14:27

reporter   ~37265

http://lime25.assendelfthankes.nl/index.php/statistics_user/action/surveyid/796195/language/nl

ollehar

ollehar

2016-04-12 14:33

administrator   ~37266

That's interesting. Could you export your responses and attach them here, please?

asshank

asshank

2016-04-12 14:47

reporter   ~37267

Olle,
As you can see in the excel the answers are not saved. I already posted this issue seperately as 10921. Sorry for mixing up.

ollehar

ollehar

2016-04-12 17:38

administrator   ~37269

I just understood that you clicked "Show statistics" in front-end, not back-end. Now I can reproduce it.

asshank

asshank

2016-04-12 22:29

reporter   ~37276

Sorry we were not more explicit about that ;)
Took us a while too to understand what went wrong. Back-end- and rpc-statistics go well, front-end is not.

ollehar

ollehar

2016-04-13 12:30

administrator   ~37305

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=18501

ollehar

ollehar

2016-04-13 12:33

administrator   ~37306

Fix committed to 2.06lts branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=18502

asshank

asshank

2016-04-13 12:46

reporter   ~37312

Thanks... works like a charm now! Awaiting 160414 tomorrow!? :-)

ollehar

ollehar

2016-04-13 12:53

administrator   ~37314

There's still problems with statistics not being shown at all for a survey I've tested. But we release the bugfix now, in 160413.

c_schmitz

c_schmitz

2016-04-15 10:24

administrator   ~37420

Version 2.50+ Build 160415 released

Related Changesets

LimeSurvey: master bc1a369a

2016-04-13 10:29:15

ollehar

Details Diff
Fixes issue 10923: statistics of questiontype array(numbers) not
working

Dev: Problem was query using $query twice instead of $query first and
Dev: $fquery second.
Affected Issues
10923
mod - application/controllers/Statistics_userController.php Diff File

LimeSurvey: 2.06lts 58d604ec

2016-04-13 10:33:06

ollehar

Details Diff
Fixed issue 10923: statistics of questiontype array(numbers) not
working

Dev: $query should be $fquery.
Affected Issues
10923
mod - application/controllers/Statistics_userController.php Diff File

Issue History

Date Modified Username Field Change
2016-04-12 09:58 asshank New Issue
2016-04-12 09:58 asshank File Added: limesurvey_survey_796195 statistics.lss
2016-04-12 12:02 ollehar Assigned To => ollehar
2016-04-12 12:02 ollehar Status new => assigned
2016-04-12 12:09 ollehar Note Added: 37257
2016-04-12 12:09 ollehar Status assigned => feedback
2016-04-12 12:53 ollehar Note Added: 37258
2016-04-12 13:29 asshank Note Added: 37260
2016-04-12 13:29 asshank Status feedback => assigned
2016-04-12 13:30 asshank Issue Monitored: asshank
2016-04-12 13:34 ollehar Note Added: 37262
2016-04-12 14:23 asshank Note Added: 37263
2016-04-12 14:25 ollehar Note Added: 37264
2016-04-12 14:27 asshank Note Added: 37265
2016-04-12 14:33 ollehar Note Added: 37266
2016-04-12 14:42 asshank File Added: vvexport_796195.xlsx
2016-04-12 14:47 asshank Note Added: 37267
2016-04-12 17:38 ollehar Note Added: 37269
2016-04-12 17:38 ollehar Status assigned => confirmed
2016-04-12 22:29 asshank Note Added: 37276
2016-04-13 12:30 ollehar Changeset attached => LimeSurvey master bc1a369a
2016-04-13 12:30 ollehar Note Added: 37305
2016-04-13 12:30 ollehar Resolution open => fixed
2016-04-13 12:30 ollehar Status confirmed => resolved
2016-04-13 12:30 ollehar Fixed in Version => 2.5
2016-04-13 12:33 ollehar Changeset attached => LimeSurvey 2.06lts 58d604ec
2016-04-13 12:33 ollehar Note Added: 37306
2016-04-13 12:46 asshank Note Added: 37312
2016-04-13 12:53 ollehar Note Added: 37314
2016-04-15 10:24 c_schmitz Note Added: 37420
2016-04-15 10:24 c_schmitz Status resolved => closed
2021-08-03 04:38 guest Bug heat 6 => 8