MyBB Community Forums

Hey,

I'm trying to deactivate "Advanced MyCode permission" but when I click the deactivate button, it shows this error :

---

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1091 - Can't DROP 'amp_groups'; check that column/key exists
Query:
ALTER TABLE mybb_mycode DROP amp_groups

---

I've checked MySQL and it really does not have 'amp_groups' there.... Now what should I do to deactivate the plugin?

though not perfect solution :
try renaming that plugin's main file with .OLD extension OR move that file to another folder ...

(2011-12-12, 06:33 AM)ranjani Wrote: [ -> ]though not perfect solution :
try renaming that plugin's main file with .OLD extension OR move that file to another folder ...

Well, I want to re-activate it. So I don't think renaming it or removing it will allow me to re-activate it

Open plugin file, and find;

	$db->query("ALTER TABLE `".TABLE_PREFIX."mycode` DROP `amp_groups`");

and Comment out the line like this;

//	$db->query("ALTER TABLE `".TABLE_PREFIX."mycode` DROP `amp_groups`");

(2011-12-12, 06:51 AM)Yaldaram Wrote: [ -> ]Open plugin file, and find;

	$db->query("ALTER TABLE `".TABLE_PREFIX."mycode` DROP `amp_groups`");

and Comment out the line like this;

//	$db->query("ALTER TABLE `".TABLE_PREFIX."mycode` DROP `amp_groups`");

Worked! Thanks alot!