Database Tables Not Found After Reset and Reinstall

  • Resolved sjgarth

    (@sjgarth)


    4 years, 3 months ago

    Hi,
    Following advice in another post I reset the plugin using the RESET ALL OPTIONS button on the General page.
    Following this I get errors in the rebuild cache page as the two database tables, reportcache and reportcachelogging no longer exist.
    I uninstalled and reinstalled the plugin with no success.
    How do I get the plugin to completely reset or uninstall and rebuild the required database tables so that it works again?
    yours
    steve

    • This topic was modified 4 years, 3 months ago by sjgarth.
    • This topic was modified 4 years, 3 months ago by sjgarth.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author anmari

    (@anmari)

    That’s really weird. Sounds like the site is having DB problems?
    The plugin checks & recreates the tables at various admin setting pages, as well as at activation time.

    Have you navigated to the admin pages? EG: ‘Overview & Tools’ …..wp-admin/admin.php?page=ameta-admin-overview.php

    If the plugin is being prevented from recreating the tables then you may need to ask your host or check your sql logs or db via phpmyadmin to see what might be the problem.

    I just retested here by blowing way the tables while the plugin was still active and it did recreate the tables once I navigated to ‘Overview’ page.

    Please let me know how you go.

    Thread Starter sjgarth

    (@sjgarth)

    Found the issue, it was database related.
    I (as an enthusiastic amateur) did not realise the importance of the character set and collation.
    I had an error in the debug saying that there was a collation mismatch, so I changed the database to the one collation, and entered that collation in the wp-config file. However, I entered the collation in the character set section, so it was not the correct setting.
    After turning on debug the error was made clear.
    Thanks for the pointer and sorry that I was late to class to learn about my error.

    Plugin Author anmari

    (@anmari)

    Thanks so much for updating – that’s how we all learn!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database Tables Not Found After Reset and Reinstall’ is closed to new replies.