View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
08513Bug reportsSurvey editingpublic2014-04-16 14:43
ReporterNoein Assigned Toc_schmitz  
PriorityurgentSeverityblock 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.05+ 
Summary08513: ERROR: Invalid last group timing fieldname
Description

Some users are not able to take the survey. They click on the link that arrives by email, the browser loads the survey at the point where it was stopped, but if they try to pursue it returns a page with the message: "Invalid last group timing fieldname"

TagsNo tags attached.
Attached Files
limesurvey_survey_276481.lss.xml (15,119 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Survey</LimeSurveyDocType>
 <DBVersion>174</DBVersion>
 <languages>
  <language>en</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[1]]></gid>
    <sid><![CDATA[276481]]></sid>
    <group_name><![CDATA[G 1]]></group_name>
    <group_order><![CDATA[0]]></group_order>
    <description><![CDATA[<span style="color: rgb(0, 0, 0); font-family: Menlo-Regular; font-size: 11px;">...</span>]]></description>
    <language><![CDATA[en]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
   <row>
    <gid><![CDATA[2]]></gid>
    <sid><![CDATA[276481]]></sid>
    <group_name><![CDATA[G 2]]></group_name>
    <group_order><![CDATA[1]]></group_order>
    <description><![CDATA[<span style="color: rgb(102, 102, 102); font-family: verdana, arial, sans-serif; font-size: 13px; line-height: 20px;">...</span>]]></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[1]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[276481]]></sid>
    <gid><![CDATA[1]]></gid>
    <type><![CDATA[S]]></type>
    <title><![CDATA[e11]]></title>
    <question><![CDATA[Q1]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></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[2]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[276481]]></sid>
    <gid><![CDATA[1]]></gid>
    <type><![CDATA[S]]></type>
    <title><![CDATA[e12]]></title>
    <question><![CDATA[Q2]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[2]]></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[3]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[276481]]></sid>
    <gid><![CDATA[2]]></gid>
    <type><![CDATA[S]]></type>
    <title><![CDATA[e21]]></title>
    <question><![CDATA[<span style="color: rgb(102, 102, 102); font-family: verdana, arial, sans-serif; font-size: 13px; line-height: 20px;">Q1</span>]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></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[4]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[276481]]></sid>
    <gid><![CDATA[2]]></gid>
    <type><![CDATA[S]]></type>
    <title><![CDATA[e22]]></title>
    <question><![CDATA[<span style="color: rgb(102, 102, 102); font-family: verdana, arial, sans-serif; font-size: 13px; line-height: 20px;">Q2</span>]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[Y]]></mandatory>
    <question_order><![CDATA[2]]></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>
 <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[276481]]></sid>
    <admin><![CDATA[Rui Gonçalves]]></admin>
    <adminemail><![CDATA[rgoncalves@di.uminho.pt]]></adminemail>
    <anonymized><![CDATA[N]]></anonymized>
    <faxto/>
    <format><![CDATA[G]]></format>
    <savetimings><![CDATA[Y]]></savetimings>
    <template><![CDATA[default]]></template>
    <language><![CDATA[en]]></language>
    <additional_languages/>
    <datestamp><![CDATA[Y]]></datestamp>
    <usecookie><![CDATA[N]]></usecookie>
    <allowregister><![CDATA[N]]></allowregister>
    <allowsave><![CDATA[Y]]></allowsave>
    <autonumber_start><![CDATA[6]]></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[rgoncalves@di.uminho.pt]]></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>
    <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[276481]]></surveyls_survey_id>
    <surveyls_language><![CDATA[en]]></surveyls_language>
    <surveyls_title><![CDATA[Test Experiment]]></surveyls_title>
    <surveyls_description><![CDATA[Test description...]]></surveyls_description>
    <surveyls_welcometext><![CDATA[Welcome...]]></surveyls_welcometext>
    <surveyls_endtext><![CDATA[Thanks for your participation!]]></surveyls_endtext>
    <surveyls_url/>
    <surveyls_urldescription/>
    <surveyls_email_invite_subj><![CDATA[Invitation to participate in a 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}<br />
<br />
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />
{OPTOUTURL}<br />
<br />
If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:<br />
{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},<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}<br />
<br />
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />
{OPTOUTURL}]]></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 your participation in our 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} on {ADMINEMAIL}.<br />
<br />
Sincerely,<br />
<br />
{ADMINNAME}]]></surveyls_email_confirm>
    <surveyls_dateformat><![CDATA[9]]></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,<br />
<br />
A new response was submitted for your survey '{SURVEYNAME}'.<br />
<br />
Click the following link to reload the survey:<br />
{RELOADURL}<br />
<br />
Click the following link to see the individual response:<br />
{VIEWRESPONSEURL}<br />
<br />
Click the following link to edit the individual response:<br />
{EDITRESPONSEURL}<br />
<br />
View statistics by clicking here:<br />
{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,<br />
<br />
A new response was submitted for your survey '{SURVEYNAME}'.<br />
<br />
Click the following link to reload the survey:<br />
{RELOADURL}<br />
<br />
Click the following link to see the individual response:<br />
{VIEWRESPONSEURL}<br />
<br />
Click the following link to edit the individual response:<br />
{EDITRESPONSEURL}<br />
<br />
View statistics by clicking here:<br />
{STATISTICSURL}<br />
<br />
<br />
The following answers were given by the participant:<br />
{ANSWERTABLE}]]></email_admin_responses>
    <surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
   </row>
  </rows>
 </surveys_languagesettings>
</document>
Bug heat4
Complete LimeSurvey version number (& build)131206
I will donate to the project if issue is resolvedYes
Browser
Database type & versionmysql 5.5.21-cll
Server OS (if known)Linux
Webserver software & version (if known)Apache/2.2.3 (CentOS)
PHP Version5.3.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-01-17 13:59

administrator   ~27953

Please attach a minimum sample survey which demonstrates the issue describing the exact stepts to reproduce. Thank you.

rcgoncalves

rcgoncalves

2014-01-21 19:18

reporter   ~28052

Last edited: 2014-01-22 12:01

I'm experiencing the same problem in a simple test survey.
I attached the survey that caused the issue.
Regarding the steps to reproduce:

  • Click on "Execute this survey" from the admin area
  • Click "Next" to skip the welcome message
  • Reply two the question on the next page (any answer should work; you can use "1")
  • Click "Next" to go to the next group
  • Reply two the question on the next page (any answer should work; you can use "1")
  • Click "Submit"
    After this last step, I get the message "Invalid last group timing fieldname".

I changed the source code of the file where this error occurs to print the array $aColumnNames and the string $setField.
These were the results:
$aColumnNames:
Array
(
[0] => id
[1] => interviewtime
[2] => 276481X1time
[3] => 276481X1X1time
)

$setField:
276481X2time

rcgoncalves

rcgoncalves

2014-01-22 12:00

reporter   ~28068

Some additional details: I created a new survey, and I filled it in. There was no problem. Then I edited the survey, adding a new group/question, and I tried again to fill in the survey. This second time, I got the error.

I believe the problem is with method 'getTableSchema()', that is not returning an updated value. That is, the table columns added after editing the survey are not being returned by this method.

In my case, a temporary fix for this bug is to remove the 'if (!in_array($setField,$aColumnNames)) die('Invalid last group timing fieldname');' line, in file 'application/libraries/Save.php'.

c_schmitz

c_schmitz

2014-01-23 14:30

administrator   ~28111

This should be resolved in 2.05. If you can still reproduce this please let us know.

rcgoncalves

rcgoncalves

2014-01-23 17:37

reporter   ~28118

I guess I have "Version 2.05+ Build 140116" installed.

c_schmitz

c_schmitz

2014-01-25 17:22

administrator   ~28142

2.05+ Build 140125 released

c_schmitz

c_schmitz

2014-04-16 14:43

administrator   ~29815

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

Related Changesets

LimeSurvey: master b0127e89

2014-04-16 12:43:19

c_schmitz

Details Diff
Fixed issue 08513: ERROR: Invalid last group timing fieldname when reactivating a modified survey and using timings Affected Issues
08513, 08966
mod - application/helpers/admin/activate_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-01-07 10:58 Noein New Issue
2014-01-17 13:59 c_schmitz Note Added: 27953
2014-01-17 13:59 c_schmitz Assigned To => c_schmitz
2014-01-17 13:59 c_schmitz Status new => feedback
2014-01-21 19:04 rcgoncalves File Added: limesurvey_survey_276481.lss.xml
2014-01-21 19:18 rcgoncalves Note Added: 28052
2014-01-22 12:00 rcgoncalves Note Added: 28068
2014-01-22 12:00 rcgoncalves Note Edited: 28052
2014-01-22 12:01 rcgoncalves Note Edited: 28052
2014-01-23 14:30 c_schmitz Note Added: 28111
2014-01-23 14:30 c_schmitz Status feedback => resolved
2014-01-23 14:30 c_schmitz Fixed in Version => 2.05+
2014-01-23 14:30 c_schmitz Resolution open => fixed
2014-01-23 17:37 rcgoncalves Note Added: 28118
2014-01-23 17:37 rcgoncalves Note View State: 28118: private
2014-01-23 17:38 rcgoncalves Note View State: 28118: public
2014-01-25 17:22 c_schmitz Note Added: 28142
2014-01-25 17:22 c_schmitz Status resolved => closed
2014-04-16 14:43 c_schmitz Changeset attached => LimeSurvey master b0127e89
2014-04-16 14:43 c_schmitz Note Added: 29815
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing