• Resolved stavroscha

    (@stavrosomo)


    Hi there,

    Just wondering gif you can help me this issue i have which bothers me since 2-3 version behind.

    I have installed Query Monitor plugin to see what is going wrong since the specific wbesite is taking a lot of CPU usage from the hosting. From what i can see there are many database errors as the following:

    1) Table ‘*******.wpma_wc_admin_notes’ doesn’t exist

    Automattic\W\A\N\DataStore->get_notes_with_name()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Notes/DataStore.php:432
    WC_Data_Store->__call()
    wp-content/plugins/woocommerce/includes/class-wc-data-store.php:207
    Automattic\W\A\N\WC_Admin_Notes_Woo_Subscriptions_Notes->check_connection()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Notes/WC_Admin_Notes_Woo_Subscriptions_Notes.php:110
    Automattic\W\A\N\WC_Admin_Notes_Woo_Subscriptions_Notes->admin_init()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Notes/WC_Admin_Notes_Woo_Subscriptions_Notes.php:79
    do_action('admin_init')
    wp-includes/plugin.php:478

    2) Table ‘*******.wpma_wc_admin_note_actions’ doesn’t exist

    Automattic\W\A\N\DataStore->save_actions()
    Automattic\W\A\N\DataStore->create()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Notes/DataStore.php:47
    WC_Data_Store->create()
    wp-content/plugins/woocommerce/includes/class-wc-data-store.php:169
    WC_Data->save()
    wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-data.php:218
    Automattic\W\A\N\WC_Admin_Notes_Woo_Subscriptions_Notes->add_no_connection_note()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Notes/WC_Admin_Notes_Woo_Subscriptions_Notes.php:196
    Automattic\W\A\N\WC_Admin_Notes_Woo_Subscriptions_Notes->check_connection()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Notes/WC_Admin_Notes_Woo_Subscriptions_Notes.php:117
    Automattic\W\A\N\WC_Admin_Notes_Woo_Subscriptions_Notes->admin_init()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Notes/WC_Admin_Notes_Woo_Subscriptions_Notes.php:79
    do_action('admin_init')
    wp-includes/plugin.php:478

    Can you please let me know how to fix the specific issues?

    Just to let you know that i do not have Woocommerce Admin plugin installed on the website and i have tried and rebuid the database, clear sessions etc from woocommerce options. Also i disabled all the plugin and used a default theme but the issue still exists..

    Any help will be appreciated! Thanks!

    Kind Regards

    • This topic was modified 4 years, 6 months ago by stavroscha.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter stavroscha

    (@stavrosomo)

    Here are the queries that are causing the specific error messages:

    SELECT note_id
    FROM wpma_wc_admin_notes
    WHERE name = 'wc-admin-wc-helper-connection'
    ORDER BY note_id ASC
    SELECT note_id
    FROM wpma_wc_admin_notes
    WHERE name = 'wc-admin-wc-helper-connection'
    ORDER BY note_id ASC
    SELECT note_id
    FROM wpma_wc_admin_notes
    WHERE name = 'wc-admin-wc-helper-subscription'
    ORDER BY note_id ASC
    SHOW FULL COLUMNS
    FROM <code>wpma_wc_admin_notes</code>
    DELETE
    FROM wpma_wc_admin_note_actions
    WHERE note_id = 0
    SHOW FULL COLUMNS
    FROM <code>wpma_wc_admin_note_actions</code>
    SELECT action_id, name, label, query, status, is_primary
    FROM wpma_wc_admin_note_actions
    WHERE note_id = 0
    SELECT note_id
    FROM wpma_wc_admin_notes
    WHERE name = 'wc-update-db-reminder'
    ORDER BY note_id ASC
    Thread Starter stavroscha

    (@stavrosomo)

    I am pretty sure that the specific issue appears on many websites but most of the people do not understand it. First of all install”Query Monitor” plugin and you will see the usage of the website. If you see a red warning then you need to install plugin “Disable Dashboard for WooCommerce” which will sort out the crappy version of Woocommerce.

    And it is really unbelievable how this has happened. It has such a huge community and there are such massive mistakes. It looks like no testing is done before the release…..So I guess i will consider twice before updating WooCommerce in the future.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Woocommerce Database Errors’ is closed to new replies.