View Issue Details

This bug affects 1 person(s).
 14
IDProjectCategoryView StatusLast Update
09658Bug reportsSurvey takingpublic2015-08-04 15:08
Reportercegar Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version2.05+ 
Summary09658: Responses cannot be saved
Description

Responses for a token cannot be saved if the survey is closed in the first page in a previous access with that token.

Steps To Reproduce
  1. Configure as "Restricted access" the attached survey.
  2. Create a dummy token.
  3. Access the test survey with the dummy token and answer the question Q1.
  4. Press the button "Previous" twice to get to the welcome page of the survey.
  5. Close the browser.
  6. Access the survey with the same token again.
  7. Press "Next"
  8. Error: an error message is shown to the user saying:

Did not save

An unexpected error has occurred and your responses cannot be saved.

Your responses have not been lost and have been emailed to the survey administrator and will be entered into our database at a later point.

The administrator of the survey receives an email with the token that caused the error and the codes of questions and responses introduced.

TagsNo tags attached.
Attached Files
error_message_653935.png (21,846 bytes)   
error_message_653935.png (21,846 bytes)   
Error.rar (200,716 bytes)
Bug heat14
Complete LimeSurvey version number (& build)Versión 2.05+ Build 150211
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql 5.1.46-log
Server OS (if known)centos
Webserver software & version (if known)apache
PHP Versionphp 5.3

Relationships

duplicate of 09772 closedDenisChenu Using "Previous" Button to Navigate back to Welcome Screen before Exit Makes ReVisiting Fail 

Users monitoring this issue

greenglaz

Activities

tpartner

tpartner

2015-06-04 12:18

partner   ~32287

I cannot reproduce this in Firefox or Chrome. cegar, can you please update to the latest release and retest?

greenglaz

greenglaz

2015-06-19 00:15

reporter   ~32431

Last edited: 2015-06-19 00:33

I have the same problem.
Browsers - Opera 30.0, IE 11.0.9600

  1. If parameters in the menu of 'Control - Representation & navigation - the Group group' that at the beginning of poll everything is all right, but at the end of poll (when there are all answers go to a database) it is reported about a error:
    "Internal error of server
    CDbCommand it wasn't succeeded to execute SQL-запрос: SQLSTATE[42000]: Syntax error or access violation: 1064 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 sid=829222' at line 1"
    Debug message in file "829222-1.html"

  2. If parameters in the menu of Control - 'Representation & navigation - the Group group' that at start of poll appears the message:
    'Did not save
    An unexpected error has occurred and your responses cannot be saved.
    Your responses have not been lost and have been emailed to the survey administrator and will be entered into our database at a later point'
    and at the end of poll (when there are all answers go to a database) it is reported about a same error:
    'Internal error of server
    CDbCommand it wasn't succeeded to execute SQL-запрос: SQLSTATE[42000]: Syntax error or access violation: 1064 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 sid=829222' at line 1'
    Debug message in file "829222.html"
    Survey 829222

jelo

jelo

2015-06-19 12:07

partner   ~32434

Is that still the case with a higher build number than 150211? of the 2.05+ branch?

c_schmitz

c_schmitz

2015-06-19 12:33

administrator   ~32436

Please upgrade to the latest version and let us know if you can still reproduce the issue.

greenglaz

greenglaz

2015-06-19 13:38

reporter   ~32438

My version 2.06+ Build 150618.

greenglaz

greenglaz

2015-06-26 00:34

reporter   ~32521

Now my version is 2.06+ Build 150625.
The problem remained.

c_schmitz

c_schmitz

2015-06-26 08:41

administrator   ~32527

greenglaz: your porblem is caused by an equation giving back a string with a space in front. (DaysAll). Either trim the string or force the equation to give back a number by settings 'Numbers only' to true in the advanced question settings of the equation question.

c_schmitz

c_schmitz

2015-06-26 08:42

administrator   ~32528

I am closing this issue because the original problem cannot be reproduced and the author is not giving feedback.

cegar

cegar

2015-07-16 13:52

reporter   ~32706

Last edited: 2015-07-16 14:44

Sorry, I could not upgrade to the lastest version until now.

I have just tested the "Test survey" in a clean installation of the latest version, 2.06+ Build 150629.

I get this error in step 6 on the top of the page (with debug = 1):

"Notice: Undefined index: gid in /srv/www/enquisas/htdocs/application/helpers/SurveyRuntimeHelper.php on line 776 Notice: Undefined index: gname in /srv/www/enquisas/htdocs/application/helpers/SurveyRuntimeHelper.php on line 777 Notice: Undefined index: gtext in /srv/www/enquisas/htdocs/application/helpers/SurveyRuntimeHelper.php on line 778 Notice: Undefined index: gid in /srv/www/enquisas/htdocs/application/helpers/SurveyRuntimeHelper.php on line 822"

When I press Next (step 7) a new page is shown with these error messages:

"Notice: Undefined offset: -2 in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 5974 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 5985 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6052 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6611 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6683 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6688 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6709 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6749 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6750 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6751 Notice: Undefined offset: -1 in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 5141 Notice: Undefined offset: -1 in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 5185 Notice: Undefined offset: -1 in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 5974 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 5985 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6052 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6611 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6683 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6688 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6709 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6749 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6750 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 6751 Notice: Undefined index: in /srv/www/enquisas/htdocs/application/helpers/expressions/em_manager_helper.php on line 5197 Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'field list'. The SQL statement executed was: UPDATE lime_survey_653935 SET lastpage=0, ``=NULL WHERE ID=12"

cegar

cegar

2015-07-21 09:28

reporter   ~32729

This is the same bug that describes issue 09772 (already fixed although not yet released).

DenisChenu

DenisChenu

2015-07-24 09:31

developer   ~32770

150723 released : please test with last version :)

c_schmitz

c_schmitz

2015-08-04 15:08

administrator   ~32880

Closed due to missing feedback.

Issue History

Date Modified Username Field Change
2015-06-02 14:56 cegar New Issue
2015-06-02 14:57 cegar File Added: limesurvey_survey_653935.lss
2015-06-02 15:00 cegar File Added: error_message_653935.png
2015-06-04 12:18 tpartner Note Added: 32287
2015-06-19 00:09 greenglaz File Added: Error.rar
2015-06-19 00:13 greenglaz File Added: limesurvey_survey_829222.lss
2015-06-19 00:15 greenglaz Note Added: 32431
2015-06-19 00:33 greenglaz Note Edited: 32431
2015-06-19 00:34 greenglaz Issue Monitored: greenglaz
2015-06-19 12:07 jelo Note Added: 32434
2015-06-19 12:31 c_schmitz Assigned To => c_schmitz
2015-06-19 12:31 c_schmitz Status new => assigned
2015-06-19 12:33 c_schmitz Note Added: 32436
2015-06-19 12:33 c_schmitz Status assigned => feedback
2015-06-19 13:38 greenglaz Note Added: 32438
2015-06-26 00:34 greenglaz Note Added: 32521
2015-06-26 08:41 c_schmitz Note Added: 32527
2015-06-26 08:42 c_schmitz Note Added: 32528
2015-06-26 08:42 c_schmitz Status feedback => closed
2015-06-26 08:42 c_schmitz Resolution open => unable to reproduce
2015-07-16 13:52 cegar Note Added: 32706
2015-07-16 13:52 cegar Status closed => feedback
2015-07-16 13:52 cegar Resolution unable to reproduce => reopened
2015-07-16 14:44 cegar Note Edited: 32706
2015-07-21 09:28 cegar Note Added: 32729
2015-07-21 09:28 cegar Status feedback => assigned
2015-07-23 01:43 DenisChenu Relationship added duplicate of 09772
2015-07-24 09:31 DenisChenu Note Added: 32770
2015-08-04 15:08 c_schmitz Note Added: 32880
2015-08-04 15:08 c_schmitz Status assigned => closed
2015-08-04 15:08 c_schmitz Resolution reopened => unable to reproduce