IntegraMOD

Your phpBB Version: 2.0.
phpBB Type: Integramod 141
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://apdeathtoll.com

PHP Version:
MySQL Version:


What was done before the problem appeared?
nothing


What was done to try to solve the problem?
nothing



De.scription and Message

I cant figure this out please help thanks to all!!!!




Couldn't get file info for this category

DEBUG MODE

SQL Error : 1054 Unknown column 'file_rating' in 'order clause'

SELECT f1.*, f1.file_id, r.votes_file, AVG(r.rate_point) AS rating, COUNT(r.votes_file) AS total_votes, u.user_id, u.username, COUNT(c.comments_id) AS total_comments FROM phpbb_pa_files AS f1 LEFT JOIN phpbb_pa_votes AS r ON f1.file_id = r.votes_file LEFT JOIN phpbb_users AS u ON f1.user_id = u.user_id LEFT JOIN phpbb_pa_comments AS c ON f1.file_id = c.file_id WHERE f1.file_pin = 1 AND f1.file_approved = 1 AND f1.file_catid = 2 GROUP BY f1.file_id ORDER BY file_rating DESC

Line : 898
File : functions_pafiledb.php