Does WooCommerce use a table called wp_e_notes?

  • Resolved chimac

    (@chimac)


    2 years, 10 months ago

    Hi,

    I installed Woocommerce a decade ago but I believe it may be causing a database issue. When I googled a WordPress table that is in my site called wp_e_notes it came up with Woocommerce as its first hit.

    My issue is simple. I accidentally deleted at some time wp_e_notes and wp_e_notes_users_relations table. If you could tell me how to fix my database so that running:

    https://chimac.net/wp-admin/maint/repair.php

    Doesn’t show this error I would be most grateful. Thank you.

    wp_e_notes: Table ‘en02dii_ruei.wp_e_notes’ doesn’t exist
    wp_e_notes_users_relations: Table ‘en02dii_ruei.wp_e_notes_users_relations’ doesn’t exist

    I have tried installing Woocommerce and then deleting it to see if it would recreate it and it didn’t. I looked in my 14 days of backups and none of them had these tables. I can’t tell you the time frame those tables might be deleted. I also looked at a friends site who never installed Woocommerce and she didn’t have those tables. So I feel confident that it might be Woocommerce. If I am wrong, any help would be appreciated and I would be willing to pay for help.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Shameem – a11n

    (@shameemreza)

    2 years, 9 months ago

    Hi @chimac

    I would like to clarify that the tables you mentioned (wp_e_notes and wp_e_notes_users_relations) are not standard WooCommerce or WordPress tables. WooCommerce tables typically start with woocommerce_ or wc_, and WordPress tables usually start with wp_. Therefore, another plugin or custom code might have created these tables.

    To fix your database issue, you might need to identify which plugin or custom code created these tables, and then reinstall or reactivate that code. If you cannot identify the source, you could try restoring your site from a backup taken before the tables were deleted. However, you mentioned that your backups do not contain these tables, which makes this a bit more challenging.

    Alternatively, if you have access to the structure of these tables from an older backup or another site where they exist, you could manually create these tables in your database using a tool like phpMyAdmin. If you’re uncomfortable doing this yourself, you might consider hiring a developer or a professional service.

    I hope this helps! If you have any other questions, feel free to ask.

    Thanks!

    وردپرس ایرانی

    (@masoudnkh)

    2 years, 9 months ago

    @chimac Please remove the following line from wp-config.php to prevent repair page from being used by unauthorized users.

    define('WP_ALLOW_REPAIR', true);

    Dont send important data in public web

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

The topic ‘Does WooCommerce use a table called wp_e_notes?’ is closed to new replies.

Tags