• Resolved Jason M

    (@ep0ch)


    Should I create this table or it could be an error fixable in some other way? Every time I search a customer number I get one of these errors in error_log within the WordPress document root. I need some help in debugging this please I am in panic mode:

    [16-Dec-2022 14:12:35 UTC] WordPress database error Table 'store_wp557.wp_wc_customer_lookup' doesn't exist for query SELECT SUM(wps.total_sales) 
                                FROM wp_wc_customer_lookup AS wpl 
                                JOIN wp_wc_order_stats as wps ON wpl.customer_id = wps. customer_id 
                                WHERE wpl.user_id=122442
             made by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('wp_loaded'), WP_Hook->do_action, WP_Hook->apply_filters, WC_Form_Handler::process_login, wp_signon, do_action('wp_login'), WP_Hook->do_action, WP_Hook->apply_filters, XLWCTY_Common::update_user_order_count, XLWCTY_Common::get_customer_total_spent
    
    
    
    
Viewing 4 replies - 1 through 4 (of 4 total)
  • Hello,

    May I ask, was the search performed directly on the database? Or via custom code?

    To understand better what is the site’s configuration, please share a copy of your site’s System Status Report: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.

    Thread Starter Jason M

    (@ep0ch)

    WordPress Environment
    
    WordPress address (URL): https://hakaiculture.com
    Site address (URL): https://hakaiculture.com
    WC Version: 7.2.1
    REST API Version: ? 7.2.1
    WC Blocks Version: ? 8.9.2
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.1.1
    WP Multisite: –
    WP Memory Limit: 4 GB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    Server Environment
    
    Server Info: LiteSpeed
    PHP Version: 7.4.33
    PHP Post Max Size: 1 GB
    PHP Time Limit: 60
    PHP Max Input Vars: 1000
    cURL Version: 7.86.0
    OpenSSL/1.1.1s
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.40
    Max Upload Size: 1 GB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    Database
    
    WC Database Version: 7.2.0
    WC Database Prefix: wp0j_
    Total Database Size: 3283.08MB
    Database Data Size: 2298.64MB
    Database Index Size: 984.44MB
    wp0j_woocommerce_sessions: Data: 134.02MB + Index: 0.19MB + Engine InnoDB
    wp0j_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp0j_woocommerce_order_items: Data: 30.55MB + Index: 10.52MB + Engine InnoDB
    wp0j_woocommerce_order_itemmeta: Data: 230.77MB + Index: 168.30MB + Engine InnoDB
    wp0j_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp0j_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_acfw_gift_cards: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_acfw_store_credits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_acfw_virtual_coupons: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_actionscheduler_actions: Data: 68.09MB + Index: 53.30MB + Engine InnoDB
    wp0j_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_actionscheduler_logs: Data: 49.08MB + Index: 29.09MB + Engine InnoDB
    wp0j_aioseo_cache: Data: 0.19MB + Index: 0.06MB + Engine InnoDB
    wp0j_aioseo_notifications: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp0j_aioseo_posts: Data: 0.20MB + Index: 0.02MB + Engine InnoDB
    wp0j_bwf_contact: Data: 1.52MB + Index: 0.92MB + Engine InnoDB
    wp0j_bwf_contact_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_bwf_funnelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_bwf_funnels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_bwf_optin_entries: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_bwf_wc_customers: Data: 1.52MB + Index: 0.19MB + Engine InnoDB
    wp0j_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_ce4wp_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_commentmeta: Data: 0.11MB + Index: 0.14MB + Engine InnoDB
    wp0j_comments: Data: 30.55MB + Index: 20.09MB + Engine InnoDB
    wp0j_ee_products_sync_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_ee_product_sync_call: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_ee_product_sync_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
    wp0j_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0j_e_submissions: Data: 1.52MB + Index: 1.03MB + Engine InnoDB
    wp0j_e_submissions_actions_log: Data: 0.16MB + Index: 0.33MB + Engine InnoDB
    wp0j_e_submissions_values: Data: 0.50MB + Index: 0.22MB + Engine InnoDB
    wp0j_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
    wp0j_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_hfcm_scripts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_litespeed_img_optm: Data: 1.52MB + Index: 0.34MB + Engine InnoDB
    wp0j_litespeed_img_optming: Data: 0.14MB + Index: 0.05MB + Engine InnoDB
    wp0j_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_mailpoet_automation_runs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_newsletters: Data: 0.03MB + Index: 0.03MB + Engine InnoDB
    wp0j_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0j_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp0j_mailpoet_scheduled_tasks: Data: 0.22MB + Index: 0.17MB + Engine InnoDB
    wp0j_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0j_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp0j_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0j_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp0j_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_mailpoet_subscribers: Data: 23.55MB + Index: 28.13MB + Engine InnoDB
    wp0j_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_subscriber_segment: Data: 15.52MB + Index: 10.03MB + Engine InnoDB
    wp0j_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_options: Data: 128.47MB + Index: 23.19MB + Engine InnoDB
    wp0j_postmeta: Data: 1088.98MB + Index: 309.72MB + Engine InnoDB
    wp0j_posts: Data: 29.55MB + Index: 18.06MB + Engine InnoDB
    wp0j_s2w_error_product_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_searchwp_index: Data: 1.52MB + Index: 0.78MB + Engine InnoDB
    wp0j_searchwp_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0j_searchwp_status: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0j_searchwp_tokens: Data: 0.19MB + Index: 0.27MB + Engine InnoDB
    wp0j_serformance_image_optimizer: Data: 0.11MB + Index: 0.02MB + Engine InnoDB
    wp0j_serformance_warmup: Data: 0.05MB + Index: 0.06MB + Engine InnoDB
    wp0j_sms_send: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_sms_subscribes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_sms_subscribes_group: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_snippets: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_swift_performance_image_optimizer: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    wp0j_swift_performance_warmup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp0j_taxjar_record_queue: Data: 0.14MB + Index: 0.06MB + Engine InnoDB
    wp0j_termmeta: Data: 0.09MB + Index: 0.14MB + Engine InnoDB
    wp0j_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp0j_term_relationships: Data: 0.28MB + Index: 0.11MB + Engine InnoDB
    wp0j_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
    wp0j_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_usermeta: Data: 294.83MB + Index: 239.45MB + Engine InnoDB
    wp0j_users: Data: 20.55MB + Index: 14.55MB + Engine InnoDB
    wp0j_wcusage_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wcusage_clicks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wcusage_register: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp0j_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wc_customer_lookup: Data: 16.55MB + Index: 9.03MB + Engine InnoDB
    wp0j_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_wc_order_coupon_lookup: Data: 2.52MB + Index: 3.03MB + Engine InnoDB
    wp0j_wc_order_product_lookup: Data: 27.55MB + Index: 21.06MB + Engine InnoDB
    wp0j_wc_order_stats: Data: 13.52MB + Index: 9.55MB + Engine InnoDB
    wp0j_wc_order_tax_lookup: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
    wp0j_wc_product_attributes_lookup: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
    wp0j_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_wc_product_meta_lookup: Data: 0.31MB + Index: 0.53MB + Engine InnoDB
    wp0j_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_wdp_orders: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0j_wdp_order_items: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp0j_wdp_persistent_rules_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wdp_rules: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wdr_order_item_discounts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0j_wdr_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wfacp_stats: Data: 0.30MB + Index: 0.44MB + Engine InnoDB
    wp0j_wfco_report_views: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp0j_woel_woocommerce_order_emails_log: Data: 5.52MB + Index: 0.00MB + Engine InnoDB
    wp0j_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wpmailsmtp_debug_events: Data: 6.52MB + Index: 0.00MB + Engine InnoDB
    wp0j_wpmailsmtp_emails_log: Data: 53.52MB + Index: 1.64MB + Engine InnoDB
    wp0j_wpmailsmtp_email_tracking_events: Data: 0.23MB + Index: 0.23MB + Engine InnoDB
    wp0j_wpmailsmtp_email_tracking_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_wt_sc_coupon_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp0j_yoast_indexable: Data: 8.52MB + Index: 3.36MB + Engine InnoDB
    wp0j_yoast_indexable_hierarchy: Data: 0.34MB + Index: 0.41MB + Engine InnoDB
    wp0j_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp0j_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp0j_yoast_seo_links: Data: 0.09MB + Index: 0.03MB + Engine InnoDB
    
    Post Type Counts
    
    attachment: 879
    custom_css: 2
    elementor_library: 9
    mailpoet_page: 1
    nav_menu_item: 39
    page: 35
    post: 7
    product: 327
    product_variation: 2496
    revision: 153
    shop_coupon: 421
    shop_order: 101599
    shop_order_refund: 6374
    shop_subscription: 8
    shopengine-template: 1
    wfacp_checkout: 3
    wffn_ty: 1
    wp_global_styles: 1
    wpcode: 2
    xlwcty_thankyou: 1
    
    Security
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    Active Plugins (39)
    
    Coupon Affiliates for WooCommerce: by Elliot Sowersby
    RelyWP – 5.4.0
    
    Advanced Coupons for WooCommerce Free: by Rymera Web Co – 4.5.1.1
    Advanced Coupons for WooCommerce Premium: by Rymera Web Co – 3.5.2
    Afterpay Gateway for WooCommerce: by Afterpay – 3.5.2
    Astra Pro: by Brainstorm Force – 3.9.3
    Attentive Tag WP Plugin: by – 1.0.0
    Caddy - Announcements: by Tribe Interactive – 1.1.0
    Caddy - Premium Edition: by Tribe Interactive – 1.6.10
    Caddy - Smart Side Cart for WooCommerce: by Tribe Interactive – 1.9.5
    GTM4WP: by Thomas Geiger – 1.16.2
    Elementor Pro: by Elementor.com – 3.9.1
    Elementor: by Elementor.com – 3.9.1
    Facebook for WooCommerce: by Facebook – 3.0.6
    Fake Pay For WooCommerce: by Anthony Graddy – 1.1.0
    Header Footer Code Manager: by 99robots – 1.1.32
    Jetpack: by Automattic – 11.6
    Klaviyo: by Klaviyo
    Inc. – 3.0.4
    
    Metorik Helper: by Metorik – 1.5.2
    NitroPack: by NitroPack LLC – 1.5.17
    Privy Website Widget: by Privy Inc. – 2.0.11
    Shopping Feed For Google and Facebook by Simprosys: by Simprosys InfoMedia – 1.8
    Snap Pixel: by Hassan Ali – 1.5.6
    Synctrack Add Paypal Tracking: by Omegatheme – 1.0.0
    TaxJar - Sales Tax Automation for WooCommerce: by TaxJar – 4.1.5
    WooCommerce Thank You Page - NextMove: by XLPlugins – 1.16.0
    UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
    DavidAnderson – 1.22.24
    
    WooCommerce Authorize.Net Gateway (Enterprise): by Pledged Plugins – 5.2.2
    One Click Upsell Funnel for Woocommerce: by WP Swings – 3.2.4
    Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.14
    WooCommerce All Products For Subscriptions: by WooCommerce – 4.0.3
    One Click Upsell Funnel For WooCommerce Pro: by WP Swings – 3.6.9
    WooCommerce PayPal Payments: by WooCommerce – 2.0.1
    WooCommerce Sequential Order Numbers Pro: by SkyVerge – 1.19.0
    WooCommerce Shipment Tracking: by WooCommerce – 1.9.0
    WooCommerce Subscriptions: by WooCommerce – 4.7.0
    WooCommerce: by Automattic – 7.2.1
    FunnelKit Checkout: by FunnelKit – 3.5.7
    WP Mail SMTP Pro: by WPForms – 3.6.1
    YITH PayPal Payments for WooCommerce Extended: by YITH – 2.3.0
    
    Inactive Plugins (2)
    
    FunnelKit Funnel Builder: by FunnelKit – 2.8.2
    WP Mail SMTP: by WPForms – 3.6.1
    
    Dropin Plugins (1)
    
    advanced-cache.php: advanced-cache.php
    
    Must Use Plugins (1)
    
    SSO: by Garth Mortensen
    Mike Hansen – 0.4
    
    Settings
    
    API Enabled: ?
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: bundle (bundle)
    external (external)
    grouped (grouped)
    simple (simple)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription)
    
    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)
    
    Connected to WooCommerce.com: ?
    Enforce Approved Product Download Directories: ?
    Order datastore: WC_Order_Data_Store_CPT
    
    WC Pages
    
    Shop base: #5 - /shop/
    Cart: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.
    Checkout: #7 - /checkout/
    My account: #8 - /my-account/
    Terms and conditions: ? Page not set
    
    Theme
    
    Name: Astra
    Version: 3.9.4
    Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
    Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme
    WooCommerce Support: ?
    
    Templates
    
    Overrides: –
    
    Subscriptions
    
    WCS_DEBUG: ? No
    Subscriptions Mode: ? Live
    Subscriptions Live URL: https://hakaiculture.com
    Subscription Statuses: auto-draft: 2
    wc-active: 4
    wc-pending-cancel: 1
    wc-on-hold: 1
    
    WooCommerce Account Connected: ? Yes
    Active Product Key: ? No
    Report Cache Enabled: ? Yes
    Cache Update Failures: ? 0 failure
    
    Store Setup
    
    Country / State: United States (US) — Washington
    
    Subscriptions by Payment Gateway
    
    Authorize.Net: wc-active: 4
    wc-on-hold: 1
    wc-pending-cancel: 1
    
    Payment Gateway Support
    
    Fake Pay: products
    Authorize.Net: subscriptions
    products
    refunds
    subscription_cancellation
    subscription_reactivation
    subscription_suspension
    subscription_amount_changes
    subscription_payment_method_change
    subscription_payment_method_change_customer
    subscription_payment_method_change_admin
    subscription_date_changes
    multiple_subscriptions
    pre-orders
    add_payment_method
    tokenization
    
    PayPal: refunds
    
    WooCommerce PayPal Payments
    
    Onboarded: ?
    Shop country code: US
    WooCommerce currency supported: ?
    Advanced Card Processing available in country: ?
    Pay Later messaging available in country: ?
    Webhook status: ?
    Vault enabled: ?
    Logging enabled: –
    Reference Transactions: ?
    Used PayPal Checkout plugin: –
    Tracking enabled: ?
    
    Admin
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    woo-mobile-welcome
    wc-pay-promotion
    wc-pay-welcome-page
    
    Disabled Features: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ? Next scheduled: 2022-12-20 19:31:11 -08:00
    Options: ?
    Notes: 39
    Onboarding: completed
    
    All Products for WooCommerce Subscriptions
    
    Template Overrides: –
    
    Action Scheduler
    
    Canceled: 1
    Oldest: 2022-11-19 23:25:23 -0800
    Newest: 2022-11-19 23:25:23 -0800
    
    Complete: 173,180
    Oldest: 2022-11-20 15:23:09 -0800
    Newest: 2022-12-20 06:14:20 -0800
    
    Failed: 17,503
    Oldest: 2022-11-17 02:24:22 -0800
    Newest: 2022-12-15 13:30:17 -0800
    
    Pending: 23
    Oldest: 2022-12-20 06:14:25 -0800
    Newest: 2023-01-19 06:46:33 -0800
    
    Status report information
    
    Generated at: 2022-12-20 06:15:09 -08:00
    `

    Hi,

    Thanks for sending the system status report. I was checking my testing site and the table is present.

    WC Database Prefix: wp0j_

    I was checking your system status report and the table name is different, it appears as wp0j_wc_customer_lookup, because the database prefix is different.

    [More info].


    I hope this provides clarity.

    Plugin Support Gabriel – a11n

    (@gabrielfuentes)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘WordPress error_log filling up with SQL errors’ is closed to new replies.