• Resolved bobhhh

    (@bobhhh)


    When the plugin is activated the following database errors are shown:

    WordPress database error: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-connection’ ORDER BY note_id ASC

    WordPress database error: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-connection’ ORDER BY note_id ASC

    WordPress database error: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-admin-wc-helper-subscription’ ORDER BY note_id ASC

    WordPress database error: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wc_admin_notes

    WordPress database error: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    DELETE FROM wp_wc_admin_note_actions WHERE note_id = 0

    WordPress database error: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wc_admin_note_actions

    WordPress database error: [Table ‘wordpress.wp_wc_admin_note_actions’ doesn’t exist]
    SELECT action_id, name, label, query, status, is_primary FROM wp_wc_admin_note_actions WHERE note_id = 0

    WordPress database error: [Table ‘wordpress.wp_wc_admin_notes’ doesn’t exist]
    SELECT note_id FROM wp_wc_admin_notes WHERE name = ‘wc-update-db-reminder’ ORDER BY note_id ASC

    I’m using WP 5.3.2 and WooCommerce 4.0.0.

    The plugin seems to be working but I did not create any tests to avoid db issues.

    • This topic was modified 4 years, 1 month ago by bobhhh.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Anonymous User 16972068

    (@anonymized-16972068)

    Hi @bobhhh,

    Thank you for using A/B Testing for WordPress.

    Strange thing about these errors is that they have nothing to do with this plugin, but rather one which makes use of a table called wp_wc_admin_notes which it cannot find.

    Does this error persist after activation, or is it a one time error upon activation?

    I cannot find anything in my plugin which could cause the deletion of the wp_wc_admin_notes table, maybe you can check you database if the table still exists.

    My plugin should have created tables for itself too.

    Kind regards,
    Gaya Kessler

    Thread Starter bobhhh

    (@bobhhh)

    Hi Gaya,

    After updating WC to v4.0.1 the errors are gone. Thanks for getting back to me!

    Anonymous User 16972068

    (@anonymized-16972068)

    @bobhhh Great! Good to hear. If you have any questions: feel free to reach out!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘database errors on activation’ is closed to new replies.