#1885 185: DB error at Tracker sorting by (missing) field

v1.8.5
closed-duplicate
nobody
5
2005-05-05
2005-02-18
No

Using 1.8.5.
Have a tracker with data. When viewing the list of
items registered on the tracker, I click on the column
(a field) to sort registers by that field, but then a
databse error occurs:

(it seems that the filed selected for the sorting is
lkost at the db query)

=============================
Warning: mysql error: Unknown column '' in 'order
clause' in query:

select * from `tiki_tracker_items` where `trackerId`=?
order by `` desc

in
/var/lib/gforge/chroot/home/groups/uniwiki/htdocs/lib/tikidblib.php
on line 134

Notice: Undefined variable: smarty in
/var/lib/gforge/chroot/home/groups/uniwiki/htdocs/lib/tikidblib.php
on line 152
An error occured in a database query!

Context:
File /tiki-view_tracker.php
Url
/tiki-view_tracker.php?status=&find=&trackerId=1&offset=0&sort_mode=_desc
Query:
select * from `tiki_tracker_items` where `trackerId`=?
order by `` desc
Values:
0 1

array(3) {
...
=============================

Discussion

  • oudeis

    oudeis - 2005-03-02

    Logged In: YES
    user_id=1222219

    I have backported a fix for this from 1.9. Find the patches in
    the patch tracker (item [1154957])

     
  • Philippe Cloutier

    • status: open --> closed-duplicate
     

Log in to post a comment.