Loading...
 
Skip to main content

Exporting tracker items does not work when selecting a custom default sort order field

Status
Closed
Subject
Exporting tracker items does not work when selecting a custom default sort order field
Version
2.x
3.x
4.x
Category
  • Error
Feature
Database MySQL (MyISAM)
Trackers
Submitted by
Beestje
Lastmod by
sylvie greverend
Rating
(0)
Description

Exporting a tracker does not work when selecting a custom default sort order field for the tracker.
Fields that do work :
itemId
Created
Lastmodif

All other fields will result in a csv file containing the error page html code.

It seems that the order by value in the SQL statement is not properly generated.


File tiki-export_tracker.php
Url tiki-export_tracker.php
Query:
select * from `tiki_tracker_items` tti where tti.`trackerId`=? order by `` desc

Values:
0 4
Message:

Built query was probably:
select * from `tiki_tracker_items` tti where tti.`trackerId`='4' order by `` desc

Solution
Fixed commit 23593 in 4.1
Importance
7
Priority
35
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
2909
Created
Tuesday 01 December, 2009 14:50:02 UTC
by Beestje
LastModif
Tuesday 01 December, 2009 14:52:44 UTC


Show PHP error messages