MyBB Community Forums

Hi to all
when try to deactivate this plugin got error anyone to fix this

MyBB has experienced an internal SQL error and cannot continue.

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

Open plugin file and find;

$db->query("ALTER TABLE ".TABLE_PREFIX."userfields DROP fid".$dpfids['fid']."");

and Change it into;

// $db->query("ALTER TABLE ".TABLE_PREFIX."userfields DROP fid".$dpfids['fid']."");

Now de-activate the plugin.

thanks works