Why Database Tables Cannot be Deleted?

  • Resolved supertrooper2

    (@supertrooper2)


    2 years, 10 months ago

    After uninstalling a plugin I have several tables in the database, which are no longer needed. e.g.

    Fus41RhR5_ppress_forms
    Known plugins that use this table name:
    wp-user-avatar [not installed]

    Fus41RhR5_ppress_formsmeta
    Known plugins that use this table name:
    wp-user-avatar [not installed]

    Fus41RhR5_ppress_meta_data
    Known plugins that use this table name:
    wp-user-avatar [not installed]

    Clicking on the remove button at first seems to delete them but after refreshing the page the tables are still there!

    Does this functionality in the plugin not work anymore?

Viewing 3 replies - 1 through 3 (of 3 total)

  • @supertrooper2 Yes it should work as expected, Could you please check phpMyAdmin if the tables are listed there, if yes, could you please try to repair the tables and then try to delete the tables from WP-Optimize and check if it gets deleted?

    Regards,
    Harshad

    Thread Starter supertrooper2

    (@supertrooper2)

    @bornforphp Hi Harshad

    The 3 tables are not actually in the PHPMyAdmin table, so I don’t understand why WP Optimize includes them in the list?

    Another anomaly I have found is that there are 37 MyISAM tables listed in both the WP Optimize and PHPMyAdmin lists. All other tables are InnoDB.

    I have clicked the “convert to InnoDB” buttons in the WP Optimize list, get a tick but after refreshing the page nothing has changed.

    Please advise how to resolve this issue.

    @supertrooper2 I’ll report this to our development team for further investigation.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Why Database Tables Cannot be Deleted?’ is closed to new replies.