MyBB Community Forums

Full Version: MYSQL HELP! Added rule page and got a MYSQL error.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Just downloaded and uploaded this rules page (http://mods.mybb.com/view/rules-page) by Chris Boulton to inc/plugins/.

Go to admin cp, go to plugins, and I click activate plugin. I get the error:

"MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'a1833896_Forum.mybb_mybb_settinggroups' doesn't exist
Query:
DELETE FROM mybb_mybb_settinggroups WHERE name='rules_page' OR name='Rules'"
I did the query into PHPMYADMIN (PMA) and got ANOTHER error:

"SQL query:

DELETE FROM mybb_mybb_settinggroups WHERE name = 'rules_page' OR name = 'Rules'

MySQL said: Documentation

#1146 - Table 'a1833896_Forum.mybb_mybb_settinggroups' doesn't exist "

Please Help!
Quote:Submitted: 17th September 2006

It's a plugin for MyBB 1.2. If you search the mods site you can find a more up to date rules plugin.
It looks like it's repeating the database table prefix. Open config.php and look for the value of $config['database']['table_prefix'].

You may also need to look at the code in that plugin to see if it hard-codes mybb_ in the queries.
Thanks!