EHM The Blue Line

There's something wrong with downloads section and the files.
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?

We had notiecd that the Latest Files section wasn't working recently.

I'll see if I can get Archi on the case

OK. I was just suprised how many "new files" suddenly appeared, which I haven't known about, and then I realised they are not new

Sorry for the delay in responding - I'm really busy with my job at the moment. I believe I know the source of the problem; the licence key for the site's webhosting software has expired (we have an annual subscription). I've asked Octavian if he can renew it. I imagine as soon as he renews it, we'll be running back to normal. Fingers crossed!

Looks like this one is solved