DEBUG mode for the downloads section

Find our latest site news here. Want to contribute, have an idea or having a problem? Post your feedback here!
Post Reply
User avatar
McQwak
Stanley Cup Winner
Posts: 1439
Joined: Mon Nov 05, 2007 1:59 pm
Custom Rank: Now with capital letters!
Location: Prague, Czech rep.

DEBUG mode for the downloads section

Post by McQwak » Wed May 06, 2009 12:51 pm

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. :dunno:
Can you see it, too?

User avatar
Calv
TBL Admin Team
Posts: 4423
Joined: Tue Jul 06, 2004 9:02 pm
Custom Rank: Goalie....Sieve....!
Favourite Team: Team GB
Location: Manchester, UK

Post by Calv » Wed May 06, 2009 12:53 pm

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

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

User avatar
McQwak
Stanley Cup Winner
Posts: 1439
Joined: Mon Nov 05, 2007 1:59 pm
Custom Rank: Now with capital letters!
Location: Prague, Czech rep.

Post by McQwak » Wed May 06, 2009 1:00 pm

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 8-)

User avatar
archibalduk
TBL Admin Team
Posts: 19465
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Post by archibalduk » Fri May 15, 2009 9:18 pm

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! :D

User avatar
McQwak
Stanley Cup Winner
Posts: 1439
Joined: Mon Nov 05, 2007 1:59 pm
Custom Rank: Now with capital letters!
Location: Prague, Czech rep.

Post by McQwak » Wed Sep 02, 2009 6:33 pm

Looks like this one is solved :thup:

Post Reply

Return to “TBL Announcements and Feedback”