“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.

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

  1. I’m having this problem and tried to do the fix above in my database. However, when I open PHPmyAdmin I don’t see the wp_ig_caticons table. I see a table for another one of my plugins (Democracy) but no caticons.

    I deactivated the plugin and deleted it from my plugins folder and then re-uploaded the caticons folder to plugins. It’s worked on and off as I’ve been testing the upgrade to WP 2.5 but every other time I get the “reactivate” error message.

    What could be happening here?

  2. I’ve come up with a solution, for those of you using Dreamhost. The table wasn’t showing up at all in my database. I added a small bit of code to me wp-config.php file that made it work. See the instructions here if you’re having this problem and hosted by Dreamhost.