Relationship Graph

View IssueDependency GraphShow Summary
Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
06297Bug reportsImport/Exportpublic2012-07-02 14:262012-08-03 13:48
Reporterde_chris Assigned Toadamzammit  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary06297: QueXML Export broken
Description

Hi there,
the QueXML export is broken. I think this is a sql language dependent issue.

Steps To Reproduce

Select a survey, click QueXML-Export

Additional Information

given error message:

FEHLER: Funktion right(text, integer) existiert nicht LINE 1: SELECT q.,RIGHT('0000000000'||g.gid,10)||RIGHT('0000000000'... ^ HINT: Keine Funktion stimmt mit dem angegebenen Namen und den Argumenttypen überein. Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen.:SELECT q.,RIGHT('0000000000'||g.gid,10)||RIGHT('0000000000'||q.question_order,10) as globalorder FROM lime_questions as q, lime_questions as q2, lime_groups as g, lime_groups as g2 WHERE q.parent_qid = 0 AND q2.parent_qid = 0 AND q.sid=96863 AND q2.sid=96863 AND q2.qid = 785 AND g2.gid =q2.gid AND g.gid = q.gid AND RIGHT('0000000000'||g.gid,10)||RIGHT('0000000000'||q.question_order,10) > RIGHT('0000000000'||g2.gid,10)||RIGHT('0000000000'||q2.question_order,10) ORDER BY globalorder

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)120623
I will donate to the project if issue is resolvedNo
BrowserFirefox 13
Database type & versionPostgresql 9
Server OS (if known)MS Win Server 2008 R2
Webserver software & version (if known)Apache
PHP Version5.33

Relationships

Relationship GraphDependency Graph
related to 06287 closedadamzammit unable to export QueXML with Postgresql 9.1 

Activities

adamzammit

adamzammit

2012-07-27 07:44

developer   ~20001

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

adamzammit

2012-07-27 07:47

developer   ~20003

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

adamzammit

2012-07-27 07:57

developer   ~20006

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

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-07-02 14:26 de_chris New Issue
2012-07-05 22:51 c_schmitz Assigned To => adamzammit
2012-07-05 22:51 c_schmitz Status new => assigned
2012-07-06 14:23 c_schmitz Relationship added related to 06287
2012-07-27 07:44 adamzammit Changeset attached => LimeSurvey Yii 57e61582
2012-07-27 07:44 adamzammit Note Added: 20001
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: 20003
2012-07-27 07:57 adamzammit Note Added: 20006
2012-07-27 07:57 adamzammit Status assigned => closed
2012-07-27 07:57 adamzammit Fixed in Version => 1.92+
2012-07-27 08:43 c_schmitz Status closed => resolved
2012-08-03 13:48 c_schmitz Status resolved => closed