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 | ||||
| Git branch / Pull Request URL | |||||
| 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-27 00:44 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-27 00:47 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 |