View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
04528Bug reportsImport/Exportpublic2010-08-11 15:182010-08-24 16:29
Reportertechnicaltitch Assigned Toadamzammit  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.90 
Fixed in Version1.90+ 
Summary04528: SQL error when try to export survey as queXML survey XML format
Description

I have tried re-importing the survey (from an lss file), changing a few questions, I ran a database integrity check, deleted old response and token tables, tried deactivating first. I'm not using tokens, one survey is live but no responses yet.

The error displayed in the browser when I select queXML and click export:

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 '' at line 1:SELECT LENGTH(COUNT(*)) as sc FROM lime_labels WHERE lid =

Steps To Reproduce

Import the lss file attached to this bug report
Select the new survey and click 'Export survey structure'
Click the queXML option and click Export
The error is displayed in the browser

TagsNo tags attached.
Attached Files
limesurvey_survey_51512(6).lss (205,387 bytes)
Bug heat8
Complete LimeSurvey version number (& build)9029
I will donate to the project if issue is resolved
BrowserChrome and Palemoon
Database type & versionmysqli 5.1.46
Server OS (if known)Linux 2.6.18-194.8.1.el5
Webserver software & version (if known)Linux shared host
PHP Version5.2.13

Users monitoring this issue

adamzammit

Activities

technicaltitch

technicaltitch

2010-08-11 15:20

reporter   ~12614

PS. I have no urgent need for this to be fixed - for information only, hence priority just 'normal'.
adamzammit

adamzammit

2010-08-19 06:49

developer   ~12660

Fixed in revision 9073 (removed dependency on lid column of questions table which doesn't exist anymore in 1.9.0)
c_schmitz

c_schmitz

2010-08-24 16:29

administrator   ~12689

New version 1.90+ 9089 released.

Issue History

Date Modified Username Field Change
2010-08-11 15:18 technicaltitch New Issue
2010-08-11 15:18 technicaltitch File Added: limesurvey_survey_51512(6).lss
2010-08-11 15:20 technicaltitch Note Added: 12614
2010-08-11 20:24 c_schmitz Assigned To => adamzammit
2010-08-11 20:24 c_schmitz Status new => assigned
2010-08-19 06:49 adamzammit Note Added: 12660
2010-08-19 06:50 adamzammit Issue Monitored: adamzammit
2010-08-19 21:39 c_schmitz Status assigned => resolved
2010-08-19 21:39 c_schmitz Fixed in Version => 1.90+
2010-08-19 21:39 c_schmitz Resolution open => fixed
2010-08-24 16:29 c_schmitz Note Added: 12689
2010-08-24 16:29 c_schmitz Status resolved => closed