View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06287Bug reportsImport/Exportpublic2012-06-28 10:572012-08-03 13:47
Reportertpardon Assigned Toadamzammit  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary06287: unable to export QueXML with Postgresql 9.1
Description

The following error occurs :
ERREUR: l'opérateur n'existe pas : text >= bigint LINE 7: ...gid,10)||RIGHT('0000000000'||q.question_order,10) >= 0000000... ^ HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type.:SELECT q.* FROM questions as q JOIN groups as g ON (g.gid = q.gid) LEFT JOIN conditions as c ON (c.cqid = '112' AND c.qid = q.qid AND c.method LIKE '==' AND c.value NOT LIKE 'A5' ) WHERE q.sid = 41657 AND q.parent_qid = 0 AND RIGHT('0000000000'||g.gid,10)||RIGHT('0000000000'||q.question_order,10) >= 00000000190000000023 AND c.cqid IS NULL ORDER BY RIGHT('0000000000'||g.gid,10)||RIGHT('0000000000'||q.question_order,10)

Steps To Reproduce

import the survey in Limesurvey with a postgresql database and export QueXML

Additional Information

The error is the same with a install on Ubuntu 10.04

TagsNo tags attached.
Attached Files
limesurvey_survey_78369.lss (29,019 bytes)
Bug heat4
Complete LimeSurvey version number (& build)20418
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgresql 9.14
Server OS (if known)Windows 7 (or Ubuntu 10.04)
Webserver software & version (if known)Apache 2.2.2.1
PHP Version5.3.10

Relationships

Relationship GraphDependency Graph
related to 06297 closedadamzammit QueXML Export broken 

Users monitoring this issue

There are no users monitoring this issue.

Activities

adamzammit

adamzammit

2012-07-27 07:44

developer   ~20000

Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9152
adamzammit

adamzammit

2012-07-27 07:47

developer   ~20002

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

adamzammit

2012-07-27 07:56

developer   ~20005

Fix committed to 1.92+ here:

http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9153

And Yii here:

http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9152

The queXML skipTo generation code has been removed, see here for details: http://bugs.limesurvey.org/view.php?id=6288
c_schmitz

c_schmitz

2012-07-27 08:44

administrator   ~20012

Thank you Adam, great work! Just set a issue to resolved - I will close the issue when a new version is released.

Related Changesets

LimeSurvey: Yii 57e61582

2012-07-26 22:44:08

adamzammit

Details Diff 		Fixed issue 06287: unable to export QueXML with Postgresql 9.1 Fixed issue 06297: QueXML Export broken Dev Removed condition checking for queXML export Affected Issues
06287, 06297
mod - application/helpers/export_helper.php Diff File

LimeSurvey: master dd97f583

2012-07-26 22:47:20

adamzammit

Details Diff 		Fixed issue 06287: unable to export QueXML with Postgresql 9.1 Fixed issue 06297: QueXML Export broken Dev Removed condition checking for queXML export Affected Issues
06287, 06297
mod - admin/export_structure_quexml.php Diff File

Issue History

Date Modified Username Field Change
2012-06-28 10:57 tpardon New Issue
2012-06-28 10:57 tpardon File Added: limesurvey_survey_78369.lss
2012-07-06 14:22 c_schmitz Assigned To => adamzammit
2012-07-06 14:22 c_schmitz Status new => assigned
2012-07-06 14:23 c_schmitz Relationship added related to 06297
2012-07-27 07:44 adamzammit Changeset attached => LimeSurvey Yii 57e61582
2012-07-27 07:44 adamzammit Note Added: 20000
2012-07-27 07:44 adamzammit Resolution open => fixed
2012-07-27 07:47 adamzammit Changeset attached => LimeSurvey master dd97f583
2012-07-27 07:47 adamzammit Note Added: 20002
2012-07-27 07:56 adamzammit Note Added: 20005
2012-07-27 07:56 adamzammit Status assigned => closed
2012-07-27 07:56 adamzammit Fixed in Version => 1.92+
2012-07-27 08:43 c_schmitz Status closed => resolved
2012-07-27 08:44 c_schmitz Note Added: 20012
2012-08-03 13:47 c_schmitz Status resolved => closed