MyBB Community Forums

Full Version: Search/Replace does not work
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
The Search/ Replace function does not work. When I use it appears:

MyBB Has Experienced An internal SQL error and can not continue.

Error SQL:
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 FROM mybb_templates mybb_templatesets s LEFT JOIN t ON (t.sid = S.sid) mybb_templates LEFT JOIN t2 ON (AND t2.sid t2.title t.title = = '1 ' ) t.template WHERE LIKE '%%' AND NOT (t.sid = -2 AND NOT ISNULL (t2.tid)) ORDER BY ASC t.title

Please contact the MyBB Group for support.
Ask your host to make the MAX_JOIN_SIZE bigger. If they refuse then I suggest you switch hosts.
Who I do that?
Where are you hosted at?
On my own host I think xP www.forum-pt.com
No, what's your webhosting company? 000webhost? HostGator? ByetHost?
ByetHost
Alright. Contact ByetHost and tell them to make the MAX_JOIN_SIZE bigger.