Downloads is broken (SQL Error)

If you don't know where to start, start here! Don't be afraid to ask questions.

Moderator: moderators

rank: <50 posts
rank: <50 posts
Posts: 6
Joined: Mon Apr 23, 2012 1:10 pm
Reputation: 0
Gender: Male

Downloads is broken (SQL Error)

Postby charliez » Sun Apr 29, 2012 12:53 am

This is the file I'm trying to download:

Motherlode 2009

But it gives me this error:

General Error

Couldnt Query file info


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

Please add to your ad blocker white list.
Thank you for your support.

rank: <50 posts
rank: <50 posts
Posts: 1
Joined: Sat Jul 07, 2012 12:40 am
Reputation: 0
Gender: None specified

Postby smithee » Sat Jul 07, 2012 6:07 am

Yes teh downloads link is not working. Is anybody going to check it out?

Return to “beginners forum”