Page 1 of 1

Downloads is broken (SQL Error)

Posted: Sun Apr 29, 2012 12:53 am
by charliez
This is the file I'm trying to download:

Motherlode 2009

But it gives me this error:

General Error




Couldnt Query file info

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 f.*, 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 f LEFT JOIN phpbb_pa_votes AS r ON f.file_id = r.votes_file LEFT JOIN phpbb_users AS u ON f.user_id = u.user_id LEFT JOIN phpbb_pa_comments AS c ON f.file_id = c.file_id WHERE f.file_id = 59 AND f.file_approved = 1 GROUP BY f.file_id

Line : 64
File : pa_file.php

Posted: Sat Jul 07, 2012 6:07 am
by smithee
Yes teh downloads link is not working. Is anybody going to check it out?