• Resolved Toyzi

    (@toyzi)


    On request of my host, I cleaned my database and started for this in the PHPMyAdmin, but I have also to clean all unnecessary tables. To be certain that I would delete the right tables that had left over after deleting unnecessary plugins I installed “Advanced Database Cleaner” recommended by Microsoft copilot and at a certain moment, I ran into the problem I’m here for. More exactly I was deleting tables of the pro versions of plugins because I have no pro versions.

    When you follow the link to it you see at the end it is about next tables that don’t exist:

    “wp9u_posts: Table ‘nexxlitg_nxxtr.wp9u_posts’ doesn’t exist
    wp9u_options: Table ‘nexxlitg_nxxtr.wp9u_options’ doesn’t exist
    wp9u_terms: Table ‘nexxlitg_nxxtr.wp9u_terms’ doesn’t exist
    wp9u_term_taxonomy: Table ‘nexxlitg_nxxtr.wp9u_term_taxonomy’ doesn’t exist
    wp9u_term_relationships: Table ‘nexxlitg_nxxtr.wp9u_term_relationships’ doesn’t exist
    wp9u_termmeta: Table ‘nexxlitg_nxxtr.wp9u_termmeta’ doesn’t exist
    wp9u_commentmeta: Table ‘nexxlitg_nxxtr.wp9u_commentmeta’ doesn’t exist”

    I don’t know if there has ever been something of these tables that are not there ‘anymore’, also mentioned on the page or one of the earlier versions. It is the first table (when you go to the end of the database) and it contains a.o. an enumeration of all the blogs. Thus is this the network table? The main domain page shows an error “Error establishing a database connection”. Normally This is quite easy to solve with optimizing the database, but not this time, I always return to the same page of the link.

    I don’t know if I have to use my backup. Can somebody affirm or contradict this? Otherwise, I don’t see how to get out of this. I also had to put “define(‘WP_ALLOW_REPAIR’, true);” in wp-config.php and it’s always there.

    • This topic was modified 12 months ago by Toyzi. Reason: Mention last sentence

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Younes JFR.

    (@symptote)

    Hello @toyzi,

    It sounds like you deleted tables that were actually part of your main WordPress site, not just from leftover plugins. Specifically, the tables like wp9u_posts, wp9u_options, etc., are core WordPress tables, and if these are missing, your site cannot function and you’ll get the “Error establishing a database connection” message.

    Even though they have the prefix wp9u_, that prefix is set in your wp-config.php file and it doesn’t mean those tables are from a plugin, it means they’re part of your WordPress installation.

    If you have a full database backup from before the cleanup, please restore it. This is the safest and fastest way to recover your site. After restoring your site, you can reinstall the Advanced Database Cleaner, but this time be very cautious when deleting tables. You can mark them as “orphaned” and investigate their origin before deleting.

    Kind regards,
    Younes

Viewing 1 replies (of 1 total)

The topic ‘Ran into problems while cleaning my database’ is closed to new replies.