I get following database error when I try to uninstall the membership module :

Can someone tell me what I need to do to uninstall this module ?

The collation of the name field for Membership sys_options_cats does not match the collation of the table itself.

You need to check the current collation settings for sys_options_cats. Something has changed it.

This is what I find in sys_options_cats :

It doesn't give me any idea of what is wrong

But I also see this one :

Your looking for this. The name field for the table. and it collation. Which applies to all names, not just the Membership one. My mistake.








You also need to look at the collation of the table itself. Found here.





One of those i believe you will find is set to utf8_unicode_ci when it should be utf8_general_ci

This was indeed utf_general_ci

Any idea how this could have been changed ?