File section Down - fixed

Post by **vickyg2003** » Mon Jul 04, 2011 6:15 am

I'm getting an SQL error when trying to access the file section.

Couldn't get file info for this category

DEBUG MODE

SQL Error : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

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 = 5 GROUP BY f1.file_id ORDER BY file_name ASC

Line : 899
File : functions_pafiledb.php

Post by **The Robman** » Mon Jul 04, 2011 9:25 am

You can still get individual files, if you know the URL, but you can't get listings of file sections. I'm trying to find a solution.

Post by **The Robman** » Mon Jul 04, 2011 10:29 am

OK, I've deleted the link to the comments table, which seems to have fixed the problem for now.