“Error in Category Icons : you must deactivate and reactivate this plugin”

Problem :

I’m getting an error message when I get to the Manage Categories page: Error in Category Icons : you must deactivate and reactivate this plugin.

So far, I’ve deactivated and reactivated the plugin, but the problem is not resolved.

Solution :

A very few people encountered this issue. This is when you upgrade from a version older than 1.7 to a new one : there is a new field addedd in the table, named priority, since 1.7, to manage icons priority. If the plugin can’t find this field, it throws the error. I don’t exactly know why that’s happening, since the modification of the table should be done automaticaly, but if you deactivate and reactivate the plugin without success, you must do it manually.

So, if you don’t have that field named ‘priority’ in your wp_ig_caticons table of your WordPress database, deactivate the plugin and paste this SQL command in phpmyadmin, as this SHOULD fix the problem :

ALTER TABLE `wp_ig_caticons` ADD `priority` INT NOT NULL ;

Of course, if your category_icons table is named differently, change it in the SQL command. And then, you should see this in phpmyadmin :

image-3.png

Reactivate the plugin. It should be OK.