View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 07622 | Bug reports | Survey taking | public | 2013-02-27 20:42 | 2013-03-05 08:45 |
| Reporter | pana | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00+ | ||||
| Fixed in Version | 2.00+ | ||||
| Summary | 07622: Testing survey crashes when moving to group with multiple choice question | ||||
| Description | I created survey with only 2 groups and 1 question in each. Debug printing is enabled but for some reason I get only this printed on the browser: "Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.. The SQL statement executed was: SELECT * FROM lime_questions WHERE parent_qid=30 AND scale_id=0 AND language='en' ORDER BY question_order" | ||||
| Steps To Reproduce |
| ||||
| Additional Information | Debugs enabled but not printed in browser. | ||||
| Tags | No tags attached. | ||||
| Attached Files | limesurvey_survey_654567.lss.xml (15,895 bytes)
<?xml version="1.0" encoding="UTF-8"?>
<document>
<LimeSurveyDocType>Survey</LimeSurveyDocType>
<DBVersion>164</DBVersion>
<languages>
<language>en</language>
</languages>
<answers>
<fields>
<fieldname>qid</fieldname>
<fieldname>code</fieldname>
<fieldname>answer</fieldname>
<fieldname>sortorder</fieldname>
<fieldname>assessment_value</fieldname>
<fieldname>language</fieldname>
<fieldname>scale_id</fieldname>
</fields>
<rows>
<row>
<qid><![CDATA[2]]></qid>
<code><![CDATA[A1]]></code>
<answer><![CDATA[Cool organization]]></answer>
<sortorder><![CDATA[1]]></sortorder>
<assessment_value><![CDATA[0]]></assessment_value>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
</row>
<row>
<qid><![CDATA[2]]></qid>
<code><![CDATA[A2]]></code>
<answer><![CDATA[Warm organization]]></answer>
<sortorder><![CDATA[2]]></sortorder>
<assessment_value><![CDATA[1]]></assessment_value>
<language><![CDATA[en]]></language>
<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>
<fieldname>randomization_group</fieldname>
<fieldname>grelevance</fieldname>
</fields>
<rows>
<row>
<gid><![CDATA[2]]></gid>
<sid><![CDATA[654567]]></sid>
<group_name><![CDATA[Background]]></group_name>
<group_order><![CDATA[1]]></group_order>
<description><![CDATA[Background information]]></description>
<language><![CDATA[en]]></language>
<randomization_group/>
<grelevance/>
</row>
<row>
<gid><![CDATA[5]]></gid>
<sid><![CDATA[654567]]></sid>
<group_name><![CDATA[Second]]></group_name>
<group_order><![CDATA[3]]></group_order>
<description><![CDATA[Ask something]]></description>
<language><![CDATA[en]]></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>
</fields>
<rows>
<row>
<qid><![CDATA[2]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[654567]]></sid>
<gid><![CDATA[2]]></gid>
<type><![CDATA[!]]></type>
<title><![CDATA[Organization]]></title>
<question><![CDATA[What is your organization?]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</row>
<row>
<qid><![CDATA[30]]></qid>
<parent_qid><![CDATA[0]]></parent_qid>
<sid><![CDATA[654567]]></sid>
<gid><![CDATA[5]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[Reservation]]></title>
<question><![CDATA[Ask something]]></question>
<preg/>
<help/>
<other><![CDATA[Y]]></other>
<mandatory><![CDATA[N]]></mandatory>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
<relevance><![CDATA[1]]></relevance>
</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>
</fields>
<rows>
<row>
<qid><![CDATA[31]]></qid>
<parent_qid><![CDATA[30]]></parent_qid>
<sid><![CDATA[654567]]></sid>
<gid><![CDATA[5]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[SQ001]]></title>
<question><![CDATA[First]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[1]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
</row>
<row>
<qid><![CDATA[32]]></qid>
<parent_qid><![CDATA[30]]></parent_qid>
<sid><![CDATA[654567]]></sid>
<gid><![CDATA[5]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[SQ002]]></title>
<question><![CDATA[Second]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[2]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
</row>
<row>
<qid><![CDATA[33]]></qid>
<parent_qid><![CDATA[30]]></parent_qid>
<sid><![CDATA[654567]]></sid>
<gid><![CDATA[5]]></gid>
<type><![CDATA[M]]></type>
<title><![CDATA[SQ003]]></title>
<question><![CDATA[Third]]></question>
<other><![CDATA[N]]></other>
<question_order><![CDATA[3]]></question_order>
<language><![CDATA[en]]></language>
<scale_id><![CDATA[0]]></scale_id>
<same_default><![CDATA[0]]></same_default>
</row>
</rows>
</subquestions>
<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>allowjumps</fieldname>
<fieldname>navigationdelay</fieldname>
<fieldname>nokeyboard</fieldname>
<fieldname>alloweditaftercompletion</fieldname>
<fieldname>googleanalyticsstyle</fieldname>
<fieldname>googleanalyticsapikey</fieldname>
</fields>
<rows>
<row>
<sid><![CDATA[654567]]></sid>
<admin><![CDATA[nano nano]]></admin>
<adminemail><![CDATA[user@admin.com]]></adminemail>
<anonymized><![CDATA[N]]></anonymized>
<faxto/>
<format><![CDATA[G]]></format>
<savetimings><![CDATA[N]]></savetimings>
<template><![CDATA[default]]></template>
<language><![CDATA[en]]></language>
<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[N]]></publicstatistics>
<publicgraphs><![CDATA[N]]></publicgraphs>
<listpublic><![CDATA[N]]></listpublic>
<htmlemail><![CDATA[Y]]></htmlemail>
<sendconfirmation><![CDATA[Y]]></sendconfirmation>
<tokenanswerspersistence><![CDATA[N]]></tokenanswerspersistence>
<assessments><![CDATA[N]]></assessments>
<usecaptcha><![CDATA[D]]></usecaptcha>
<usetokens><![CDATA[N]]></usetokens>
<bounce_email><![CDATA[user@admin.com]]></bounce_email>
<attributedescriptions><![CDATA[a:0:{}]]></attributedescriptions>
<emailresponseto/>
<emailnotificationto/>
<tokenlength><![CDATA[15]]></tokenlength>
<showxquestions><![CDATA[Y]]></showxquestions>
<showgroupinfo><![CDATA[B]]></showgroupinfo>
<shownoanswer><![CDATA[Y]]></shownoanswer>
<showqnumcode><![CDATA[X]]></showqnumcode>
<bounceprocessing><![CDATA[N]]></bounceprocessing>
<showwelcome><![CDATA[Y]]></showwelcome>
<showprogress><![CDATA[Y]]></showprogress>
<allowjumps><![CDATA[N]]></allowjumps>
<navigationdelay><![CDATA[0]]></navigationdelay>
<nokeyboard><![CDATA[N]]></nokeyboard>
<alloweditaftercompletion><![CDATA[N]]></alloweditaftercompletion>
</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>
</fields>
<rows>
<row>
<surveyls_survey_id><![CDATA[654567]]></surveyls_survey_id>
<surveyls_language><![CDATA[en]]></surveyls_language>
<surveyls_title><![CDATA[Sample]]></surveyls_title>
<surveyls_description><![CDATA[Sample]]></surveyls_description>
<surveyls_welcometext><![CDATA[Hello world!]]></surveyls_welcometext>
<surveyls_endtext><![CDATA[Thank you!]]></surveyls_endtext>
<surveyls_url><![CDATA[http://server/install_path/limesurvey/index.php]]></surveyls_url>
<surveyls_urldescription><![CDATA[Surveys]]></surveyls_urldescription>
<surveyls_email_invite_subj><![CDATA[Invitation to participate in a survey]]></surveyls_email_invite_subj>
<surveyls_email_invite><![CDATA[Dear {FIRSTNAME},
you have been invited to participate in a survey.
The survey is titled:
"{SURVEYNAME}"
"{SURVEYDESCRIPTION}"
To participate, please click on the link below.
Sincerely,
{ADMINNAME} ({ADMINEMAIL})
----------------------------------------------
Click here to do the survey:
{SURVEYURL}
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:
{OPTOUTURL}
If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:
{OPTINURL}]]></surveyls_email_invite>
<surveyls_email_remind_subj><![CDATA[Reminder to participate in a survey]]></surveyls_email_remind_subj>
<surveyls_email_remind><![CDATA[Dear {FIRSTNAME},
Recently we invited you to participate in a survey.
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.
The survey is titled:
"{SURVEYNAME}"
"{SURVEYDESCRIPTION}"
To participate, please click on the link below.
Sincerely,
{ADMINNAME} ({ADMINEMAIL})
----------------------------------------------
Click here to do the survey:
{SURVEYURL}
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:
{OPTOUTURL}]]></surveyls_email_remind>
<surveyls_email_register_subj><![CDATA[Survey registration confirmation]]></surveyls_email_register_subj>
<surveyls_email_register><![CDATA[Dear {FIRSTNAME},
You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.
To complete this survey, click on the following URL:
{SURVEYURL}
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 your participation in our survey]]></surveyls_email_confirm_subj>
<surveyls_email_confirm><![CDATA[Dear {FIRSTNAME},
this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.
If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.
Sincerely,
{ADMINNAME}]]></surveyls_email_confirm>
<surveyls_dateformat><![CDATA[10]]></surveyls_dateformat>
<surveyls_attributecaptions><![CDATA[a:0:{}]]></surveyls_attributecaptions>
<email_admin_notification_subj><![CDATA[Response submission for survey {SURVEYNAME}]]></email_admin_notification_subj>
<email_admin_notification><![CDATA[Hello,
A new response was submitted for your survey '{SURVEYNAME}'.
Click the following link to reload the survey:
{RELOADURL}
Click the following link to see the individual response:
{VIEWRESPONSEURL}
Click the following link to edit the individual response:
{EDITRESPONSEURL}
View statistics by clicking here:
{STATISTICSURL}]]></email_admin_notification>
<email_admin_responses_subj><![CDATA[Response submission for survey {SURVEYNAME} with results]]></email_admin_responses_subj>
<email_admin_responses><![CDATA[Hello,
A new response was submitted for your survey '{SURVEYNAME}'.
Click the following link to reload the survey:
{RELOADURL}
Click the following link to see the individual response:
{VIEWRESPONSEURL}
Click the following link to edit the individual response:
{EDITRESPONSEURL}
View statistics by clicking here:
{STATISTICSURL}
The following answers were given by the participant:
{ANSWERTABLE}]]></email_admin_responses>
<surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
</row>
</rows>
</surveys_languagesettings>
</document>
| ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 130226 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Mozilla/5.0 (Windows NT 6.1; WOW64; rv:18.0) Gecko/20100101 Firefox/18.0 | ||||
| Database type & version | MySQL 5.0.95 | ||||
| Server OS (if known) | RHEL | ||||
| Webserver software & version (if known) | Apache/2.2.3 | ||||
| PHP Version | 5.1.6 | ||||
| Git branch / Pull Request URL | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-02-27 20:42 | pana | New Issue | |
| 2013-02-27 20:42 | pana | File Added: limesurvey_survey_654567.lss.xml | |
| 2013-03-02 17:56 | c_schmitz | Assigned To | => c_schmitz |
| 2013-03-02 17:56 | c_schmitz | Status | new => assigned |
| 2013-03-02 17:56 | c_schmitz | Changeset attached | => LimeSurvey master e083fa60 |
| 2013-03-02 17:56 | c_schmitz | Note Added: 24497 | |
| 2013-03-02 17:56 | c_schmitz | Resolution | open => fixed |
| 2013-03-02 17:57 | c_schmitz | Status | assigned => resolved |
| 2013-03-02 17:57 | c_schmitz | Fixed in Version | => 2.00+ |
| 2013-03-03 15:34 | pana | Note Added: 24503 | |
| 2013-03-05 08:45 | c_schmitz | Note Added: 24527 | |
| 2013-03-05 08:45 | c_schmitz | Status | resolved => closed |