Multisite DB Call Error

  • Resolved danielspalma

    (@danielspalma)


    3 years, 4 months ago

    Hello. Im having this error at my multisite.

    It calls bdbwewjyrd.wp_wc_order_stats but should be<span style=”text-decoration: underline;”> “.wp_2_wc”</span>

    Look:

    [02-Feb-2023 13:18:46 UTC] WordPress database error Table ‘bdbwewjyrd.wp_wc_order_stats’ doesn’t exist for query
    SELECT customer_id
    FROM wp_wc_order_stats
    WHERE order_id = ‘3526’ made by do_action_ref_array(‘action_scheduler_run_queue’), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->run, ActionScheduler_QueueRunner->do_batch, ActionScheduler_Abstract_QueueRunner->process_action, ActionScheduler_Action->execute, do_action_ref_array(‘wc-admin_import_orders’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Internal\Admin\Schedulers\ImportScheduler::do_action_or_reschedule, call_user_func_array, Automattic\WooCommerce\Internal\Admin\Schedulers\OrdersScheduler::import, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::sync_order, Automattic\WooCommerce\Admin\API\Reports\Orders\Stats\DataStore::update, do_action(‘woocommerce_analytics_update_order_stats’), WP_Hook->do_action, WP_Hook->apply_filters, PixelYourSite\EnrichOrder->woo_update_analytics, PixelYourSite\getWooUserStat

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter danielspalma

    (@danielspalma)

    3 years, 4 months ago

    I think its related:

    [02-Feb-2023 19:32:09 UTC] WordPress database error Table ‘bdbwewjyrd.wp_2_usermeta’ doesn’t exist for query
    SELECT DISTINCT meta_key
    FROM wp_2_usermeta m
    WHERE m.meta_key NOT IN (‘user_url’,’user_email’,’display_name’,’nickname’,’first_name’,’last_name’,’description’,’primary_blog’,’use_ssl’,’comment_shortcuts’,’admin_color’,’rich_editing’,’syntax_highlighting’,’show_admin_bar_front’,’locale’,’community-events-location’,’show_try_gutenberg_panel’,’closedpostboxes_post’,’metaboxhidden_post’,’closedpostboxes_dashboard’,’metaboxhidden_dashboard’,’dismissed_wp_pointers’,’session_tokens’,’source_domain’)
    AND m.meta_key NOT LIKE
    ‘%capabilities’ AND m.meta_key NOT LIKE ‘%user_level’ AND m.meta_key NOT LIKE ‘%user-settings’ AND m.meta_key NOT LIKE ‘%user-settings-time’ AND m.meta_key NOT LIKE ‘%dashboard_quick_press_last_post_id’ AND m.meta_key NOT LIKE ‘wprus%’ AND m.meta_key NOT LIKE ‘%wprus’
    ORDER BY m.meta_key ASC
    ; made by require(‘wp-admin/edit-form-advanced.php’), register_and_do_post_meta_boxes, do_action(‘add_meta_boxes’), WP_Hook->do_action, WP_Hook->apply_filters, Wprus_Settings->add_settings_meta_boxes, Wprus_Settings->get_user_meta_keys

    xue28 (woo-hc)

    (@xue28)

    3 years, 4 months ago

    Hi @danielspalma

    Thanks for reaching out!

    The error log above states that the table bdbwewjyrd.wp_wc_order_stats and bdbwewjyrd.wp_2_usermeta doesn’t exist in the following queries above respectively.

    Can you please share where are you seeing this error on your site?

    If a screenshot would be helpful, I’d recommend using https://snipboard.io or http://skitch.com/. You can share the direct link to the image as a response to this topic.

    Additionally, I’d like to understand your site properly, please share your System Status Report that you can find via WooCommerce > Status. Select Get system report and then Copy for support. Once you’ve done that, you can paste it into your reply here.

    If you could also provide the fatal error logs (if any) under WooCommerce > Status > Logs.

    Thanks!

    Thread Starter danielspalma

    (@danielspalma)

    3 years, 4 months ago

    The only error is “Error completing checkout. Please try again.” at checkout.

    I’d like to send this logs in private, can you tell me a email I can send it?

    The error, to me, looks to be that its a multisite, subsite #2.

    bdbwewjyrd.wp_wc_order_stats doesnt exist

    bdbwewjyrd.wp_2_wc_order_stats do exist.

    Its a plugin multisite support error, right?

    Thanks.

    xue28 (woo-hc)

    (@xue28)

    3 years, 4 months ago

    Hi @danielspalma

    I’m afraid I cannot confirm what is causing the error here, hence, I am asking for your site’s System Status Report as well as the fatal error logs.

    Kindly be informed that this is a public forum, and sending messages privately is prohibited. If there are any sensitive information, please redact it prior to posting it here.

    Thanks!

    Roxy

    (@roxannestoltz)

    3 years, 3 months ago

    Hi @danielspalma ,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if you need any further help with this.

    Cheers!

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

The topic ‘Multisite DB Call Error’ is closed to new replies.