• Resolved jacs2023

    (@jacs2023)


    Woocommerce database not updating, now have critical error with checkout – not accepting any payment.

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello there.

    Thanks for contacting WooCommerce support.

    Could you please share a screenshot of the screen when the database is not updated and also when you see the critical error? I want to see what exact errors have occurred.

    Also, I’d like to review your site’s System Status Report.
    You can find it via WooCommerce > Status.
    Select Get system report and then Copy for support.

    Once you’ve done that, you can paste the text in https://gist.github.com
    After that, you can paste the Gist link here in your reply.

    Looking forward to your response. 🙂

    Best regards.

    Thread Starter jacs2023

    (@jacs2023)

    Hello @doublezed2

    I am not on GitHub.

    However I am attaching the screenshots here of the failed scheduled actions + system report + error at checkout.

    We have already sone conflict tests 3 times so know it is not related to any other plugin etc. We deactivated everything except storefront and woocommerce to be certain and it is a woocommerce payment issue.

    <ul class="woocommerce-error" role="alert"> <li> Invalid or missing payment details. Please ensure the provided payment method is correctly entered. </li> </ul>
    
    
    ` WordPress Environment
    
    WordPress address (URL): https://pinkcityliving.com
    Site address (URL): https://pinkcityliving.com
    WC Version: 8.7.0
    REST API Version:  8.7.0
    Action Scheduler Version:  3.7.2
    Log Directory Writable: 
    WP Version: 6.4.3
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: 
    Language: en_US
    External object cache:  Server Environment
    
    Server Info: LiteSpeed
    PHP Version: 8.1.27
    PHP Post Max Size: 256 MB
    PHP Time Limit: 300
    PHP Max Input Vars: 5000
    cURL Version: 7.87.0
    OpenSSL/1.1.1w
    
    SUHOSIN Installed: –
    MySQL Version: 10.11.7-MariaDB-cll-lve
    Max Upload Size: 256 MB
    Default Timezone is UTC: 
    fsockopen/cURL: 
    SoapClient: 
    DOMDocument: 
    GZip: 
    Multibyte String: 
    Remote Post: 
    Remote Get:  Database
    
    WC Database Version: 8.7.0
    WC Database Prefix: wp_
    Total Database Size: 52.11MB
    Database Data Size: 45.60MB
    Database Index Size: 6.51MB
    wp_woocommerce_sessions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_actions: Data: 0.20MB + Index: 0.16MB + Engine InnoDB
    wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_actionscheduler_logs: Data: 0.16MB + Index: 0.09MB + Engine InnoDB
    wp_aioseo_cache: Data: 0.14MB + Index: 0.03MB + Engine InnoDB
    wp_aioseo_crawl_cleanup_blocked_args: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_aioseo_crawl_cleanup_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_aioseo_notifications: Data: 0.19MB + Index: 0.06MB + Engine InnoDB
    wp_aioseo_posts: Data: 1.52MB + Index: 0.02MB + Engine InnoDB
    wp_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ce4wp_contacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_comments: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
    wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
    wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
    wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
    wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gla_attribute_mapping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gla_budget_recommendations: Data: 0.20MB + Index: 0.11MB + Engine InnoDB
    wp_gla_merchant_issues: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_jetpack_waf_blocklog: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_litespeed_avatar: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_litespeed_img_optming: Data: 0.44MB + Index: 0.53MB + Engine InnoDB
    wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_automation_runs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.23MB + Engine InnoDB
    wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_options: Data: 6.47MB + Index: 0.16MB + Engine InnoDB
    wp_postmeta: Data: 9.52MB + Index: 0.48MB + Engine InnoDB
    wp_posts: Data: 3.52MB + Index: 0.20MB + Engine InnoDB
    wp_rafflepress_contestants: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rafflepress_entries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_rafflepress_giveaways: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_css: Data: 0.13MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_css_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_revslider_sliders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_slides: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_static_slides: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_sellkit_applied_funnel: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_sellkit_contact_segmentation: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_sellkit_funnel_contact: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_userfeedback_surveys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_userfeedback_survey_responses: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_usermeta: Data: 0.14MB + Index: 0.03MB + Engine InnoDB
    wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
    wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
    wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_orders: Data: 0.02MB + Index: 0.13MB + Engine InnoDB
    wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfconfig: Data: 0.48MB + Index: 0.00MB + Engine InnoDB
    wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wffilemods: Data: 9.52MB + Index: 0.00MB + Engine InnoDB
    wp_wfhits: Data: 0.08MB + Index: 0.05MB + Engine InnoDB
    wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfknownfilelist: Data: 6.52MB + Index: 0.00MB + Engine InnoDB
    wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wflogins: Data: 0.20MB + Index: 0.06MB + Engine InnoDB
    wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
    wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
    wp_wfpklist_template_data: Data: 0.09MB + Index: 0.00MB + Engine InnoDB
    wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfsecurityevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wfstatus: Data: 0.36MB + Index: 0.19MB + Engine InnoDB
    wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wfwaffailures: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB
    wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB Post Type Counts
    
    attachment: 619
    customize_changeset: 3
    e-landing-page: 1
    elementor_library: 19
    inavii_account: 1
    inavii_feed: 1
    mailpoet_page: 1
    nav_menu_item: 20
    page: 21
    post: 9
    product: 35
    product_variation: 18
    revision: 303
    seedprod: 1
    shop_coupon: 4
    shop_order: 16
    shop_order_refund: 2
    testimonials: 3
    wp_global_styles: 1
    wp_navigation: 1
    wp_template: 2
    wpcf7_contact_form: 2
    wpz-insta_user: 1 Security
    
    Secure connection (HTTPS): 
    Hide errors from visitors:  Active Plugins (14)
    
    All in One SEO: by All in One SEO Team – 4.5.9.2
    Aramex Shipping WooCommerce: by aramex.com – 1.1.16
    Contact Form 7: by Takayuki Miyoshi – 5.9.3
    Elementor Pro: by Elementor.com – 3.20.2
    Elementor: by Elementor.com – 3.20.3
    Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.25.0
    Inavii for Elementor Social Feed: by INAVII – 2.5.2
    LiteSpeed Cache: by LiteSpeed Technologies – 6.1
    Mailchimp for WooCommerce: by Mailchimp – 3.7
    Gift Wrapper: by Little Package – 6.1.5
    WooPayments: by Automattic – 7.4.0
    WooCommerce: by Automattic – 8.7.0
    Wordfence Security: by Wordfence – 7.11.4
    WP File Manager: by mndpsingh287 – 7.2.6 Inactive Plugins (1)
    
    WPForms Lite: by WPForms – 1.8.7.2 Dropin Plugins ()
    
    object-cache.php: object-cache.php Settings
    
    API Enabled: –
    Force SSL: –
    Currency: AED (د.إ)
    Currency Position: right_space
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)
    
    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 Woo.com: –
    Enforce Approved Product Download Directories: 
    HPOS feature screen enabled: –
    HPOS feature enabled: –
    Order datastore: WC_Order_Data_Store_CPT
    HPOS data sync enabled: – Logging
    
    Enabled: 
    Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
    Retention period: 30 days
    Level threshold: –
    Log directory size: 475 KB WC Pages
    
    Shop base: #2434 - /collections/
    Cart: #363 - /cart-2/
    Checkout: #2557 - /checkout/
    My account: #350 - /my-account-2/
    Terms and conditions: #359 - /terms-conditions/ Theme
    
    Name: Hello Elementor
    Version: 3.0.1
    Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash
    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: – WooPayments
    
    Version: 7.4.0
    Connected to WPCOM: Yes
    WPCOM Blog ID: 221640815
    Account ID: acct_1O6QDDFswY4H1TNk
    Payment Gateway: Enabled
    Test Mode: Disabled
    Enabled APMs: card
    WooPay: Not eligible
    Apple Pay / Google Pay: Enabled (product,cart,checkout)
    Fraud Protection Level: basic
    Multi-currency: Disabled
    Public Key Encryption: Enabled
    Auth and Capture: Enabled
    Documents: Disabled
    Logging: Enabled Admin
    
    Enabled Features: activity-panels
    analytics
    product-block-editor
    coupons
    core-profiler
    customer-effort-score-tracks
    import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    product-variation-management
    product-virtual-downloadable
    product-external-affiliate
    product-grouped
    product-linked
    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: customize-store
    minified-js
    new-product-management-experience
    product-pre-publish-modal
    settings
    async-product-editor-category-field
    
    Daily Cron:  Next scheduled: 2024-04-02 18:23:41 +00:00
    Options: 
    Notes: 113
    Onboarding: completed Action Scheduler
    
    Complete: 97
    Oldest: 2024-03-30 04:58:45 +0000
    Newest: 2024-04-02 11:08:32 +0000
    
    Failed: 357
    Oldest: 2023-08-02 10:31:57 +0000
    Newest: 2024-04-02 11:07:15 +0000
    
    Pending: 6
    Oldest: 2024-04-02 11:09:52 +0000
    Newest: 2024-04-09 11:07:15 +0000 Status report information
    
    Generated at: 2024-04-02 11:09:08 +00:00
    `

    https://drive.google.com/file/d/1FmUIi4YB7ucsNh3Uvf–5_JNFmWVnksA/view?usp=sharing

    https://drive.google.com/file/d/1Fs37TM7OwPaPi1M1pYBQ61kYYXY1_40g/view?usp=sharing

    https://drive.google.com/file/d/1FkowWK451HHpiocxMqNUPWl20dYYbbWm/view?usp=sharing

    https://drive.google.com/file/d/1Fa3j4uJCUM3lK1iza0Pgngd6qCMITiTV/view?usp=sharing

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello jacs2023

    Thank you for your reply and for providing screenshots.

    After reviewing your site’s System Status Report, I noticed that the WooCommerce database is already updated to the latest 8.7.0 version.

    To further assist you with the Checkout page error, could you share a screenshot of your WooPayments settings? This can often give me more insight into the configuration and any potential misalignment with the update.

    To find the settings, Navigate to WooCommerce → Settings and click on the Payments tab, then click WooPayments.

    Additionally, it would be helpful to know if WooPayments was functioning correctly before the WooCommerce update. Any context about when the error first appeared and whether it coincided with any specific change on your site will be incredibly useful for troubleshooting.

    I look forward to your reply. 🙂

    Best regards.

    Thread Starter jacs2023

    (@jacs2023)

    Hello @doublezed2

    WooPayments stoped working after 20th February. We had one successful purchase on that day and then everything post that was a failed checkout. We had made absolutely no changes to the website at that time or afterwards.

    I have had to roll the website back to 18th February today to see if we can get to a point where it was working. It still is not because it’s updated the woo plugin.

    Here is the screen capture of the payments tab:

    https://drive.google.com/file/d/1GIIFlYJ-ttagbzvK56t07J202PHtDye4/view?usp=sharing

    It would be great if we can resolve this today.

    Thank you.

    Thread Starter jacs2023

    (@jacs2023)

    Hello @doublezed2

    I forgot to give you this critical error information:

    2024-04-03T08:56:03+00:00 Critical Uncaught Error: Failed opening required ‘/home/u929138311/domains/pinkcityliving.com/public_html/wp-content/plugins/woocommerce-payments/vendor/automattic/jetpack-config/src/class-config.php’ (include_path=’.:/opt/alt/php81/usr/share/pear:/opt/alt/php81/usr/share/php:/usr/share/pear:/usr/share/php’) in /home/u929138311/domains/pinkcityliving.com/public_html/wp-content/plugins/woocommerce-payments/vendor/jetpack-autoloader/class-php-autoloader.php:90 CONTEXT: {“error”:{“type”:1,”file”:”\/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/wp-content\/plugins\/woocommerce-payments\/vendor\/jetpack-autoloader\/class-php-autoloader.php”,”line”:90},”backtrace”:[“”,”#0 \/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/wp-content\/plugins\/woocommerce-payments\/woocommerce-payments.php(76): Automattic\\Jetpack\\Autoloader\\jpc77c6f448183a14790ec1fee9fc3636e\\PHP_Autoloader::load_class()”,”#1 \/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/wp-includes\/class-wp-hook.php(324): wcpay_jetpack_init()”,”#2 \/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/wp-includes\/class-wp-hook.php(348): WP_Hook->apply_filters()”,”#3 \/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/wp-includes\/plugin.php(517): WP_Hook->do_action()”,”#4 \/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/wp-settings.php(506): do_action()”,”#5 \/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/wp-config.php(112): require_once(‘\/home\/u92913831…’)”,”#6 \/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/wp-load.php(50): require_once(‘\/home\/u92913831…’)”,”#7 \/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/wp-blog-header.php(13): require_once(‘\/home\/u92913831…’)”,”#8 \/home\/u929138311\/domains\/pinkcityliving.com\/public_html\/index.php(17): require(‘\/home\/u92913831…’)”,”#9 {main}”,”thrown”]}

    Thread Starter jacs2023

    (@jacs2023)

    Hello @doublezed2

    and also this:

    2024-04-03T10:16:39+00:00Critical Uncaught TypeError: call_user_func_array(): Argument #1 ($callback) must be a valid callback, class “Freemius” not found in /home/u929138311/domains/pinkcityliving.com/public_html/wp-includes/class-wp-hook.php:324 Additional context

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello jacs2023

    Thank you for your reply.

    I have reviewed the screenshot and the error log.
    Since you have already conducted a conflict test multiple times, we can rule out the conflict between plugins or the current theme.

    To capture the error log of WooPayments please enable the Log error messages in the Advanced Settings.

    Then try to make a few purchases so that the Log entries are captured.
    You can find these entries under WooCommerce > System Status > Logs.

    Next, I suggest trying the checkout process in Test Mode.
    This step will clarify if there is any issue with the live settings of the Woopayments extension. For more details and instructions please check this guide.

    Let me know about your findings. 🙂

    Best regards.

    Thread Starter jacs2023

    (@jacs2023)

    Hello @doublezed2

    I have been doing the above for over a week already and am getting the same error message. Sorry but I am constantly being asked to do the same thing.

    I have also played with disabling the 2FA as this is also now an issue:

    2024-04-04T08:07:25+00:00 Info ENVIRONMENT: array ( ‘WP_User’ => ‘hello’, ‘HTTP_REFERER’ => ‘https://pinkcityliving.com/wp-admin/admin.php?page=wc-settings&tab=checkout&section=woocommerce_payments&#8217;, ‘HTTP_USER_AGENT’ => ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Safari/605.1.15’, ‘REQUEST_URI’ => ‘/wp-json/wc/v3/payments/settings?_locale=user’, ‘DOING_AJAX’ => false, ‘DOING_CRON’ => false, ‘WP_CLI’ => false, ) 2024-04-04T08:07:25+00:00 Info REQUEST POST https://public-api.wordpress.com/wpcom/v2/sites/%s/wcpay/fraud_ruleset 2024-04-04T08:07:25+00:00 Info HEADERS: array ( ‘Content-Type’ => ‘application/json; charset=utf-8’, ‘User-Agent’ => ‘WooCommerce Payments/7.4.0’, ‘Idempotency-Key’ => ‘8f06a976-c399-433e-8880-3ec72e0d6d64’, ) 2024-04-04T08:07:25+00:00 Info BODY: array ( ‘test_mode’ => false, ‘ruleset_config’ => array ( ), ) 2024-04-04T08:07:25+00:00 Info RESPONSE: array ( ‘wcpay_fraud_ruleset_id’ => 444379, ‘wcpay_account_id’ => 1340270, ‘ruleset_config’ => array ( ), ‘created’ => ‘2024-03-26 10:10:15’, ) 2024-04-04T08:16:09+00:00 Info ENVIRONMENT: array ( ‘WP_User’ => ‘hello’, ‘HTTP_REFERER’ => ‘https://pinkcityliving.com/wp-admin/admin.php?page=wc-settings&tab=checkout&#8217;, ‘HTTP_USER_AGENT’ => ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Safari/605.1.15’, ‘REQUEST_URI’ => ‘/wp-json/wc/v3/payments/settings?_locale=user’, ‘DOING_AJAX’ => false, ‘DOING_CRON’ => false, ‘WP_CLI’ => false, ) 2024-04-04T08:16:09+00:00 Info REQUEST GET https://public-api.wordpress.com/wpcom/v2/sites/%s/wcpay/fraud_ruleset?test_mode=0 2024-04-04T08:16:09+00:00 Info HEADERS: array ( ‘Content-Type’ => ‘application/json; charset=utf-8’, ‘User-Agent’ => ‘WooCommerce Payments/7.4.0’, ) 2024-04-04T08:16:10+00:00 Info RESPONSE: array ( ‘wcpay_fraud_ruleset_id’ => 444379, ‘wcpay_account_id’ => 1340270, ‘ruleset_config’ => array ( ), ‘created’ => ‘2024-03-26 10:10:15’, ) 2024-04-04T08:16:10+00:00 Info ENVIRONMENT: array ( ‘WP_User’ => ‘hello’, ‘HTTP_REFERER’ => ‘https://pinkcityliving.com/wp-admin/admin.php?page=wc-settings&tab=checkout&#8217;, ‘HTTP_USER_AGENT’ => ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Safari/605.1.15’, ‘REQUEST_URI’ => ‘/wp-json/wc/v3/payments/settings?_locale=user’, ‘DOING_AJAX’ => false, ‘DOING_CRON’ => false, ‘WP_CLI’ => false, ) 2024-04-04T08:16:10+00:00 Info REQUEST GET https://public-api.wordpress.com/wpcom/v2/sites/%s/wcpay/fraud_ruleset?test_mode=0 2024-04-04T08:16:10+00:00 Info HEADERS: array ( ‘Content-Type’ => ‘application/json; charset=utf-8’, ‘User-Agent’ => ‘WooCommerce Payments/7.4.0’, ) 2024-04-04T08:16:10+00:00 Info RESPONSE: array ( ‘wcpay_fraud_ruleset_id’ => 444379, ‘wcpay_account_id’ => 1340270, ‘ruleset_config’ => array ( ), ‘created’ => ‘2024-03-26 10:10:15’, ) 2024-04-04T08:18:00+00:00 Info ENVIRONMENT: array ( ‘WP_User’ => ‘hello’, ‘HTTP_REFERER’ => ‘https://pinkcityliving.com/wp-admin/admin.php?page=wc-settings&tab=shipping&section=options&#8217;, ‘HTTP_USER_AGENT’ => ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Safari/605.1.15’, ‘REQUEST_URI’ => ‘/wp-admin/admin.php?page=wc-status’, ‘DOING_AJAX’ => false, ‘DOING_CRON’ => false, ‘WP_CLI’ => false, ) 2024-04-04T08:18:00+00:00 Info REQUEST GET https://public-api.wordpress.com/wpcom/v2/sites/%s/wcpay/fraud_ruleset?test_mode=0 2024-04-04T08:18:00+00:00 Info HEADERS: array ( ‘Content-Type’ => ‘application/json; charset=utf-8’, ‘User-Agent’ => ‘WooCommerce Payments/7.4.0’, ) 2024-04-04T08:18:01+00:00 Info RESPONSE: array ( ‘wcpay_fraud_ruleset_id’ => 444379, ‘wcpay_account_id’ => 1340270, ‘ruleset_config’ => array ( ), ‘created’ => ‘2024-03-26 10:10:15’, ) 2024-04-04T08:18:01+00:00 Info ENVIRONMENT: array ( ‘WP_User’ => ‘hello’, ‘HTTP_REFERER’ => ‘https://pinkcityliving.com/wp-admin/admin.php?page=wc-settings&tab=shipping&section=options&#8217;, ‘HTTP_USER_AGENT’ => ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Safari/605.1.15’, ‘REQUEST_URI’ => ‘/wp-admin/admin.php?page=wc-status’, ‘DOING_AJAX’ => false, ‘DOING_CRON’ => false, ‘WP_CLI’ => false, ) 2024-04-04T08:18:01+00:00 Info REQUEST GET https://public-api.wordpress.com/wpcom/v2/sites/%s/wcpay/fraud_ruleset?test_mode=0 2024-04-04T08:18:01+00:00 Info HEADERS: array ( ‘Content-Type’ => ‘application/json; charset=utf-8’, ‘User-Agent’ => ‘WooCommerce Payments/7.4.0’, ) 2024-04-04T08:18:01+00:00 Info RESPONSE: array ( ‘wcpay_fraud_ruleset_id’ => 444379, ‘wcpay_account_id’ => 1340270, ‘ruleset_config’ => array ( ), ‘created’ => ‘2024-03-26 10:10:15’, ) 2024-04-04T08:22:34+00:00 Info ENVIRONMENT: array ( ‘WP_User’ => ‘hello’, ‘HTTP_REFERER’ => ‘https://pinkcityliving.com/wp-admin/admin.php?page=WFLS&#8217;, ‘HTTP_USER_AGENT’ => ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Safari/605.1.15’, ‘REQUEST_URI’ => ‘/wp-admin/admin.php?page=wc-status’, ‘DOING_AJAX’ => false, ‘DOING_CRON’ => false, ‘WP_CLI’ => false, ) 2024-04-04T08:22:34+00:00 Info REQUEST GET https://public-api.wordpress.com/wpcom/v2/sites/%s/wcpay/fraud_ruleset?test_mode=0 2024-04-04T08:22:34+00:00 Info HEADERS: array ( ‘Content-Type’ => ‘application/json; charset=utf-8’, ‘User-Agent’ => ‘WooCommerce Payments/7.4.0’, ) 2024-04-04T08:22:34+00:00 Info RESPONSE: array ( ‘wcpay_fraud_ruleset_id’ => 444379, ‘wcpay_account_id’ => 1340270, ‘ruleset_config’ => array ( ), ‘created’ => ‘2024-03-26 10:10:15’, ) 2024-04-04T08:22:34+00:00 Info ENVIRONMENT: array ( ‘WP_User’ => ‘hello’, ‘HTTP_REFERER’ => ‘https://pinkcityliving.com/wp-admin/admin.php?page=WFLS&#8217;, ‘HTTP_USER_AGENT’ => ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Safari/605.1.15’, ‘REQUEST_URI’ => ‘/wp-admin/admin.php?page=wc-status’, ‘DOING_AJAX’ => false, ‘DOING_CRON’ => false, ‘WP_CLI’ => false, ) 2024-04-04T08:22:34+00:00 Info REQUEST GET https://public-api.wordpress.com/wpcom/v2/sites/%s/wcpay/fraud_ruleset?test_mode=0 2024-04-04T08:22:34+00:00 Info HEADERS: array ( ‘Content-Type’ => ‘application/json; charset=utf-8’, ‘User-Agent’ => ‘WooCommerce Payments/7.4.0’, ) 2024-04-04T08:22:34+00:00 Info RESPONSE: array ( ‘wcpay_fraud_ruleset_id’ => 444379, ‘wcpay_account_id’ => 1340270, ‘ruleset_config’ => array ( ), ‘created’ => ‘2024-03-26 10:10:15’, )

    I have also tried the same last week in test mode and get the same error.

    Please outline what else you require as this is taking so long with what seems like no resolution. I am more than happy to provide you with credentials if you wish to view the backend.

    Thanks

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @jacs2023,

    Thanks for sharing additional information. I understand how frustrating it can be when things don’t work as expected, especially when it impacts the functionality of your website.

    However, from the error logs you’ve shared, the issue seems to occur due to file corruption or incorrect file permissions.

    Given the complexity of the issue, I recommend the following steps:

    • Deactivate and delete the WooCommerce and WooPayments, then reinstall them. Please note that deleting the plugin will not erase your settings or data. However, to be safe, make sure to keep a complete backup.
    • If the issue still persists, there might be a deeper issue at the server level. In this case, I recommend contacting your hosting provider. Share the error messages with them and ask if they can assist in identifying any server configuration issues.

    If none of the above steps resolve the issue, we might need to take a closer look at your site. In this case, please contact us at Woo.com > My Account > Support. You may need to create an account before you can access that page.

    Please include a link to this forum thread, so that we can keep track of what’s already been done.

    We will be able to help you further there.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @jacs2023,

    I’m marking this topic as “resolved” due to recent inactivity. If more assistance is needed, feel free to post back here or open a new topic.

    Thanks!

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘Critical Error – Woocommerce Database Update’ is closed to new replies.