On the right side of the TBL homepage is section with "Latest Files" - showing very old files, not the latest. And when I go through "Downloads" section, then to "TOP FILES" and choose some certain day (with some files, for example "May 05, 2009 (2)"), I get this message:
Couldnt Query stat info
DEBUG MODE
SQL Error : 1054 Unknown column 'f1.file_id' in 'on clause'
SELECT f1.*, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, c.cat_id, c.cat_name, COUNT(cm.comments_id) AS total_comments, c.cat_name, c.cat_allow_ratings, c.cat_allow_comments FROM forums_pa_files AS f1, forums_pa_cat AS c LEFT JOIN forums_pa_votes AS r ON f1.file_id = r.votes_file LEFT JOIN forums_users AS u ON f1.user_id = u.user_id LEFT JOIN forums_pa_comments AS cm ON f1.file_id = cm.file_id WHERE c.cat_id = f1.file_catid AND f1.file_id IN (575, 574) AND f1.file_approved = '1' GROUP BY f1.file_id ORDER BY file_time DESC
Line : 249
File : pa_toplist.php
It has been there since yesterday, I guess.
Can you see it, too?
