Database issues -> Woocommerce trying to create a table

  • Resolved ellieangelica

    (@ellieangelica)


    4 years, 7 months ago

    So i’ve recently installed woocommerce 4.1 onto a new site im developing but my error logs are just filling up with this

    WordPress database error Table '(DB Name).wp_wc_admin_notes' doesn't exist for query SELECT note_id FROM wp_wc_admin_notes WHERE name = 'wc-admin-wc-helper-connection' ORDER BY note_id ASC made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->admin_init, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->check_connection, WC_Data_Store->__call, Automattic\WooCommerce\Admin\Notes\DataStore->get_notes_with_name
[24-Apr-2020 08:06:31 UTC] WordPress database error Table '(DB Name).wp_wc_admin_notes' doesn't exist for query SELECT note_id FROM wp_wc_admin_notes WHERE name = 'wc-admin-wc-helper-connection' ORDER BY note_id ASC made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->admin_init, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->check_connection, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->remove_notes, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes::delete_notes_with_name, WC_Data_Store->__call, Automattic\WooCommerce\Admin\Notes\DataStore->get_notes_with_name
[24-Apr-2020 08:06:31 UTC] WordPress database error Table '(DB Name).wp_wc_admin_notes' doesn't exist for query SELECT note_id FROM wp_wc_admin_notes WHERE name = 'wc-admin-wc-helper-subscription' ORDER BY note_id ASC made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->admin_init, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->check_connection, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->remove_notes, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes::delete_notes_with_name, WC_Data_Store->__call, Automattic\WooCommerce\Admin\Notes\DataStore->get_notes_with_name
[24-Apr-2020 08:06:31 UTC] WordPress database error Table '(DB Name).wp_wc_admin_notes' doesn't exist for query SHOW FULL COLUMNS FROM <code>wp_wc_admin_notes</code> made by do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->admin_init, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->check_connection, Automattic\WooCommerce\Admin\Notes\WC_Admin_Notes_Woo_Subscriptions_Notes->add_no_connection_note, WC_Data->save, WC_Data_Store->create, Automattic\WooCommerce\Admin\Notes\DataStore->create

    I’ve never had this with previous versions of Woocommerce and its starting to really overflow my error logs.

    All permissions for the DB are setup

    • This topic was modified 4 years, 7 months ago by ellieangelica.
Viewing 6 replies - 1 through 6 (of 6 total)
  • mother.of.code

    (@imazed)

    The Mother of Code

    Hi there!

    Can you please post your Status Report here, so we can see if there are any red flags we can spot?

    Thanks in advance!

    Plugin Support Job a11n

    (@jobthomas)

    Automattic Happiness Engineer

    Hey @ellieangelica – before we continue, are you using the release candidate plugin? WooCommerce 4.1 is only coming out in about 2 weeks. The current version is 4.0.1.

    If it’s 4.0.1 you’re using, can you have a look at WP Admin > WooCommerce > Status > System Status**. At the top, you’ll see the WooCommerce version, can you scroll down until you see “WooCommerce database version:” to confirm is this is the same.

    If it is not the same, can you go to WP Admin > WooCommerce > Status > Tools > Update database > Click – Update (Button on right)**. That could potentially fix this problem.

    If that’s not the case, can you paste your system status report in this thread? Thanks.

    Thread Starter ellieangelica

    (@ellieangelica)

    Hi Both,

    Sorry i meant to put 4.0.1!

    So after installing Woocommerce Admin, Its seems to have corrected itself which is kinda annoying as i didn’t need Admin.

    Thanks!

    Plugin Support Job a11n

    (@jobthomas)

    Automattic Happiness Engineer

    @ellieangelica WooCommerce Admin is a plugin that’s now part of WooCommerce core. You can still install it if you want to see all the features before the are released into WooCommerce core. Otherwise, what happens if you deactivate and delete this plugin?

    Thread Starter ellieangelica

    (@ellieangelica)

    When i deactivate Admin and delete it the errors dont come back!

    Kinda weird but i’ll accept it as before my error logs we’re fulling up fast

    In the future, is there anyway Admin and Core can be bundled together?

    Plugin Support Job a11n

    (@jobthomas)

    Automattic Happiness Engineer

    @ellieangelica At the moment, all the proven and tested tools of WC Admin are already in core. The plugin is currently used for testing new features.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Database issues -> Woocommerce trying to create a table’ is closed to new replies.