View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
06297 | Bug reports | Import/Export | public | 2012-07-02 14:26 | 2012-08-03 13:48 |
Reporter | de_chris | Assigned To | adamzammit | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.92+ | ||||
Fixed in Version | 1.92+ | ||||
Summary | 06297: QueXML Export broken | ||||
Description | Hi there, | ||||
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 | ||||
Tags | No tags attached. | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 120623 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Firefox 13 | ||||
Database type & version | Postgresql 9 | ||||
Server OS (if known) | MS Win Server 2008 R2 | ||||
Webserver software & version (if known) | Apache | ||||
PHP Version | 5.33 | ||||
related to | 06287 | closed | adamzammit | unable to export QueXML with Postgresql 9.1 |
Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9152 |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9153 |
|
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 |
|
LimeSurvey: Yii 57e61582 2012-07-26 22:44:08 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 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 |
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 |