MyBB Community Forums

When i use the search and replace templates in the acp i get
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

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 FROM mybb_templates t LEFT JOIN mybb_templatesets s ON (t.sid=s.sid) LEFT JOIN mybb_templates t2 ON (t.title=t2.title AND t2.sid='1') WHERE t.template LIKE '%modlist%' AND NOT (t.sid = -2 AND NOT ISNULL(t2.tid)) ORDER BY t.title ASC
Please contact the MyBB Group for support.

i have just upgraded to 1.6 and i took a backup before upgrading
any help appreciated

thanks but it works fine on my test forum
on the same server

---

i have now solved this i reverted back to 1.4 re-ran the upgrade and now it works