MyBB Community Forums

Full Version: deactivating plugins
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i can no longer deactivate the plugins on my forum when i do i get a sql error having checked the db i have noticed some bits of plugins are missing is there any way to set plugins to deactivated manually so i can reactivate and restore the settings that are missing.
What's the exact SQL error?
it varies with different plugins but the main on seems to be
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, t.template 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.title = 'index' AND NOT (t.sid = -2 AND NOT ISNULL(t2.tid)) ORDER BY t.title ASC

and before you say its a host error please be aware it was working fine a few days ago.