View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
03658Bug reportsOtherpublic2009-09-07 03:132009-09-15 12:30
Reporterbkgray Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.85 
Fixed in Version1.85+ 
Summary03658: Import fails with SQL error
Description

Import of attached survey export file fails.

I am running 1.85+ build 7561. The export file was built with the same version, but I saw the same problem with previous builds of 1.85+.

I make extensive use of javascript Custom_On_Load() functions. Based on the error messages that I see during import, I suspect that's where the problem is.

TagsNo tags attached.
Attached Files
common.php (245,884 bytes)
Bug heat4
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2009-09-07 14:47

updater   ~09423

Error message:
Couldn't update INSERTANS in question
UPDATE lime_questions SET question='<script> <!-- function Custom_On_Load(){ if(document.getElementById('answer23859X232X608').value == ""){ document.getElementById('answer23859X232X608').value="{TOKEN:ATTRIBUTE_9}"; } if(document.getElementById('answer23859X232X609').value == ""){ document.getElementById('answer23859X232X609').value="{TOKEN:ATTRIBUTE10}"; } // if ( "{INSERTANS:23859X628X3151}".indexOf("Yes") >= 0 && "{INSERTANS:23859X628X3150}" == "No answer") { // alert("You have asked us to forward your mail.\n\nYou must provided U. S. mailing address."); // document.limesurvey.move.value = 'moveprev'; // document.limesurvey.submit(); // } // if ( "{INSERTANS:23859X628X3151}".indexOf("hold") >= 0 && "{INSERTANS:23859X628X3148}" == "No") { // alert("If you are not returning to St. Stephen's, we can not hold your mail.\n\nPlease change your answers."); // document.limesurvey.move.value = 'moveprev'; // document.limesurvey.submit(); // } // var objRegExp = /(^[a-z]([a-z.])@([a-z_.])([.][a-z]{3})$)|(^a-z@([a-z_.])(.[a-z]{3})(.[a-z]{2})$)/i; //check for valid email // if(objRegExp.test("{INSERTANS:23859X628X3150}")){ // alert("It appears that you have entered an email address instead of a postal mailing address.\n\n You must provided U. S. mailing address."); // document.limesurvey.move.value = 'moveprev'; // document.limesurvey.submit(); // } // hide this question document.getElementById("question738").style.display='none'; // alert("hiding hidden question"); // deal with "stay on campus" if("{INSERTANS:23859X627X3145}" == "Yes"){ document.getElementById('answer23859X232X607d2s').checked='true'; document.getElementById('answer23859X232X608d3s').checked='true'; document.limesurvey.move.value = 'movenext'; document.limesurvey.submit(); } } --> </script>
', help='' WHERE qid=3136 AND language='en'
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 'answer23859X232X608').value == ""){ document.getElementById('answer23859X232' at line 1
c_schmitz

c_schmitz

2009-09-10 00:56

administrator   ~09487

Attached fixed file.

Issue History

Date Modified Username Field Change
2009-09-07 03:13 bkgray New Issue
2009-09-07 03:13 bkgray File Added: limesurvey_survey_23859.csv
2009-09-07 14:47 Mazi Note Added: 09423
2009-09-07 14:47 Mazi Project @2@ => Bug reports
2009-09-07 14:47 Mazi Status new => assigned
2009-09-07 14:47 Mazi Assigned To => c_schmitz
2009-09-10 00:54 c_schmitz Status assigned => resolved
2009-09-10 00:54 c_schmitz Fixed in Version => 1.85+
2009-09-10 00:54 c_schmitz Resolution open => fixed
2009-09-10 00:56 c_schmitz File Added: common.php
2009-09-10 00:56 c_schmitz File Deleted: limesurvey_survey_23859.csv
2009-09-10 00:56 c_schmitz Note Added: 09487
2009-09-15 12:30 c_schmitz Status resolved => closed
2010-05-06 10:27 c_schmitz Category Import / Export => (No Category)