MyBB Community Forums

Hello,

I'm using Labrocca's Ficon v2.1 plugin for my MyBBoard site.

I'm getting the following internal error when trying to activate the plugin:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1060 - Duplicate column name 'ficon'
Query:
    ALTER TABLE `mybb_forums` ADD `ficon` VARCHAR(120) NOT NULL DEFAULT 'shim.gif' AFTER `defaultsortorder` 

I know what it means, I need to remove all the ficons entries from phpMyAdmin so I can readd the plugin as I've used it before.

The only problem is I don't know how to remove the "ficon" from phpMyAdmin found in "mybb_forums".

Can someone guide me how to quickly remove all references of ficons?

Regards,
George.

Click the structure tab when you're viewing the forums table and press the red cross next to the ficon column.

Thanks Matt, it worked