Upgraded to 3.0.12 (from a 2.x version). While checking attribute configuration, received Database Error 1054. Conducted database structure check and all tables passed except phplist_user_attribute. How to I go about identifying the specific error and correcting it? I would like to avoid performing a reinstall if I could.
You can get to database administration using PHPMyAdmin often from your hosting control panel (CPanel usually).
Then run this command and see if that doesn’t fix it in the simplest way possible:
REPAIR TABLE phplist_user_attribute;
Thanks for the tip, NYChris. I looked at the index names of the failed table and discovered that some table names had changed from my (much) older version. I compared the structures and modified a couple of the table names to be compatible with the new version, and now everything works properly.