MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1091 - Can't DROP 'ICQTR'; check that column/key exists
Query:
ALTER TABLE mybb_users DROP COLUMN ICQT
This is the error I get when trying to deactivate the Social Buttons plugin.
Go to: Your Hosting control panel > database management > phpmyadmin > your database > your users table > and delete the ICQTR column manually.
Where do I find the columns?
These are inside your mybb_users table. OR simply run the following query;
ALTER TABLE `mybb_users` DROP `ICQTR`;
It's saying the column doesn't exist.
Then where you are getting this error ?
You'll still get this error as the column doesn't exist. You could add the column manually (use any setting you like, as long as the column name is ICQTR) and then deactivate the plugin.
You could also contact the plugin author and advise them to throw IF conditionals around the drop.
if($db->field_exists("ICQTR", "users"))
{
$db->drop_column("users", "ICQTR");
}
How can I create a column?
Run this query through an SQL window in phpMyAdmin (or another database manager):
ALTER TABLE mybb_users ADD ICQTR int(1) NOT NULL
Then try and remove the plugin again.