View Issue Details

This issue affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
06564Bug reportsImport/Exportpublic2012-10-19 13:19
Reporteruser21808Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version1.92+ 
Summary06564: First response is discarded when importing with "INSERTANS" field conversion
Description

When importing a survey with the option "Convert resource links and INSERTANS fields?" checked (which unfortunately is the default), the first response will produce messages such as these on the end page:

Notice: Undefined index: srid in /srv/www/vhosts/....../docs/survey/index.php on line 1470

Notice: Undefined index: srid in /srv/www/vhosts/....../docs/survey/index.php on line 1471

(I deleted parts of the path obviously)

This also causes the whole respose to be silently discarded. All following responses (Insha'Allah) are ok.

Steps To Reproduce
  1. (Export any survey)
  2. Import the survey, leave the INSERTANS option on
  3. Activate the survey
  4. Fill in the survey and submit
  5. Look at the end page and the number of responses (which will be 0)
Additional Information

I attached an example survey to facilitate testing. This is proven to trigger the bug for me.

TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)120909
I will donate to the project if issue is resolvedYes
Browser
Database type & versionMySQL Ver 14.12 Distrib 5.0.32
Server OS (if known)Linux 2.6.18-6
Webserver software & version (if known)lighttpd 1.4.29
PHP VersionPHP 5.2.0-8+etch16
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

TMSWhite

TMSWhite

2012-09-18 23:36

reporter   ~20723

I can't reproduce the problem. The attached survey works fine for me. I also don't see any of the srid errors. I also have never had problems exporting then re-importing surveys.

Have you tried doing a fresh installation of LimeSurvey? Perhaps your installation got corrupted somehow.

user21808

2012-09-19 09:38

  ~20724

I have an important survey running so I don't want to experiment too much ATM. The installation is practically new though.

Issues I did have with this installation are permission problems though. On the server, I'm not allowed to create new databases and Limesurvey (PHP that is to say) is not allowed to write to directories even in its own tree. I fixed this where Limesurvey explicitly reported such a problem but maybe some related problem is still lurking somewhere?

c_schmitz

c_schmitz

2012-09-21 10:15

administrator   ~20745

I am sorry but I cannot reproduce that here either.
After you are done with your survey please do a full manual (so not using ComfortUpdate) upgrade to the latest 1.92 version (120919). If the error persists please reopen this issue and attach a database dump of your LimeSurvey database.

user21808

2012-09-23 21:28

  ~20762

This also occurs with 120919.

user21808

2012-09-23 21:30

  ~20763

C_schmitz, as I told you on IRC, I am not comfortable with exposing the whole database dump publicly but I can send you the dump privately on IRC.

I also want to add that this issue now also occurred with a survey that was not imported, either with or without the INSERTANS option. I know this must be very hard to debug. If I find out anything else, I will report it here. The problem did so far indeed never occur with any submit but the first one for any given survey.

c_schmitz

c_schmitz

2012-09-26 09:38

administrator   ~20824

Please send the database dump to (email address removed)

Thank you.

c_schmitz

c_schmitz

2012-10-07 12:08

administrator   ~21102

Mudd1, feedback please?

user21808

2012-10-07 15:39

  ~21112

I already wrote this in an email Carsten but I probably should repeat it here publicly:

I /think/ I now figured out the real reason why most surveys fail and especially why testing was so tricky: it has nothing to do with the content or how a survey is created. The error and the discarding happen if I preview the survey with that green cogwheel button but do not click the final send button (which I usually don't do with previews). Then and seemingly only then the bug is triggered. And probably only for me.

c_schmitz

c_schmitz

2012-10-19 13:19

administrator   ~21455

I cannot reproduce this in 2.0 so I will close this for now.

Issue History

Date Modified Username Field Change
2012-09-18 15:28 user21808 New Issue
2012-09-18 15:28 user21808 File Added: limesurvey_survey_75857.lss
2012-09-18 23:36 TMSWhite Note Added: 20723
2012-09-18 23:36 TMSWhite Status new => feedback
2012-09-19 09:38 user21808 Note Added: 20724
2012-09-19 09:38 user21808 Status feedback => new
2012-09-20 13:26 user21808 Issue Monitored: user21808
2012-09-21 10:15 c_schmitz Note Added: 20745
2012-09-21 10:15 c_schmitz Status new => closed
2012-09-21 10:15 c_schmitz Assigned To => c_schmitz
2012-09-21 10:15 c_schmitz Resolution open => unable to reproduce
2012-09-23 21:28 user21808 Note Added: 20762
2012-09-23 21:28 user21808 Status closed => feedback
2012-09-23 21:28 user21808 Resolution unable to reproduce => reopened
2012-09-23 21:30 user21808 Note Added: 20763
2012-09-23 21:30 user21808 Status feedback => assigned
2012-09-26 09:38 c_schmitz Note Added: 20824
2012-09-26 09:47 c_schmitz Status assigned => feedback
2012-10-07 12:08 c_schmitz Note Added: 21102
2012-10-07 15:39 user21808 Note Added: 21112
2012-10-07 15:39 user21808 Status feedback => assigned
2012-10-19 13:19 c_schmitz Note Added: 21455
2012-10-19 13:19 c_schmitz Status assigned => closed
2012-10-19 13:19 c_schmitz Resolution reopened => unable to reproduce