#15 search & sorting function

closed-fixed
Page View (7)
7
2005-11-08
2005-11-04
Anonymous
No

i tried the search function for the first time now on
my testsite, i ran into a bunch of problems with the
sorting function:

Name: only yields descending list (top:z, bottom: a)

Size: only yields descending
(top:highest->bottom:lowest) list.

Number of files: the same

Seeders: the same

Downloads: only yields ascending list (top

Leechers: both ascending and descending run into an
error message:

Error executing SQL Query SELECT torrent_torrents.*,
IF(torrent_torrents.numratings < '1', NULL,
ROUND(torrent_torrents.ratingsum /
torrent_torrents.numratings, 1)) AS rating,
torrent_categories.name AS cat_name,
torrent_categories.image AS cat_pic,
U.username,IF(U.name IS NULL, U.username, U.name) as
user_name FROM torrent_torrents LEFT JOIN
torrent_categories ON category = torrent_categories.id
LEFT JOIN torrent_users U ON torrent_torrents.owner =
U.id WHERE banned = 'no' AND search_text LIKE ('%%')
ORDER BY times_completed DESC LIMIT 0,10;
Error ID: 1054
Error Message: Unknown column 'times_completed' in
'order clause'

Total Peers: both ascending and descending run into an
error message:

Error executing SQL Query SELECT torrent_torrents.*,
IF(torrent_torrents.numratings < '1', NULL,
ROUND(torrent_torrents.ratingsum /
torrent_torrents.numratings, 1)) AS rating,
torrent_categories.name AS cat_name,
torrent_categories.image AS cat_pic,
U.username,IF(U.name IS NULL, U.username, U.name) as
user_name FROM torrent_torrents LEFT JOIN
torrent_categories ON category = torrent_categories.id
LEFT JOIN torrent_users U ON torrent_torrents.owner =
U.id WHERE banned = 'no' AND search_text LIKE ('%%')
ORDER BY attivato DESC LIMIT 0,10;
Error ID: 1054
Error Message: Unknown column 'attivato' in 'order clause'

what i also noticed is that the "Demnow 11/05/05" was
excluded when i searched for "Demnow", for some reason.
i tried both checking and unchecking the "include dead
torrent" box.

i hope this helps...

Discussion

  • lodp

    lodp - 2005-11-04

    Logged In: YES
    user_id=1356011

    sorry, forgot to log in again... that was me submitting the
    support request

     
  • Antonio Anzivino

    • assigned_to: nobody --> djechelon
     
  • Antonio Anzivino

    Logged In: YES
    user_id=1041943

    Interesting... This must be fixed before release...
    I'll take a look...

     
  • Antonio Anzivino

    • labels: --> Page View
    • priority: 5 --> 7
     
  • Antonio Anzivino

    Logged In: YES
    user_id=1041943

    The bug you reported has just been fixed.

    The CVS Repository has just been updated. Please use CVS
    Checkout to retrieve all the fixed files. If the problem still persists,
    do not hesistate to contact us again by re-opening this entry.

     
  • Antonio Anzivino

    • status: open --> closed
     
  • Antonio Anzivino

    • status: closed --> closed-fixed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks