MyBB Community Forums

I'm not sure if this is a hosting error, but it seems like it could be.

I just updated to 1.6.1 and went to find updated templates. However, i received the following SQL Error;

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
Query:
    SELECT t.tid, t.title, t.sid, t.version FROM forum_templates t LEFT JOIN forum_templates m ON (m.title=t.title AND m.sid=-2 AND m.version > t.version) WHERE t.sid > 0 AND m.template != t.template ORDER BY t.sid ASC, title ASC 

As I said, I think this is a host problem, but I just wanted to check.

They need to raise the MAX_JOIN_SIZE limit.

Thought so. Thanks.