woocommerce throwing errors

  • Resolved minterrors

    (@minterrors)


    10 months, 1 week ago

    When I visit my website, I am able to see the main home page. When I click on an article, I get the “critical error has occurred on this website”. As I type, I am able to get into the back end of the website and there are no major errors in the site health.

    I am running win server 2022, MySQL, PHP.

    I went to the PHP error file and I have a copy of this. I will attempt to attach.

    [29-Dec-2023 16:36:09 UTC] PHP Warning: Trying to access array offset on value of type bool in E:\Websites\MintErrors\wp-content\plugins\woo-product-feed-pro\pages\admin\woosea-generate-feed-step-1.php on line 246
    [05-Jan-2024 17:22:37 UTC] PHP Warning: filesize(): stat failed for E:\Websites\MintErrors\wp-content\cache\object\1bc/f89/1bcf893d6fe3f37b75cf9506204c27ff.php in E:\Websites\MintErrors\wp-content\plugins\w3-total-cache\Cache_File.php on line 159
    [12-Jan-2024 17:46:05 UTC] PHP Warning: Undefined property: W3TC\DbCache_WpdbNew::$wc_orders in E:\Websites\MintErrors\wp-includes\class-wpdb.php on line 783
    [12-Jan-2024 17:46:05 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE payment_method = ‘ppec_paypal” at line 1 for query SELECT 1 FROM WHERE payment_method = ‘ppec_paypal’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, WooCommerce\PayPalCommerce{closure}, WooCommerce\PayPalCommerce\init, {closure}, WooCommerce\PayPalCommerce\Compat\CompatModule->run, WooCommerce\PayPalCommerce\Compat\CompatModule->initialize_ppec_compat_layer, WooCommerce\PayPalCommerce\Compat\PPEC\SubscriptionsHandler->maybe_hook, WooCommerce\PayPalCommerce\Compat\PPEC\PPECHelper::use_ppec_compat_layer_for_subscriptions, WooCommerce\PayPalCommerce\Compat\PPEC\PPECHelper::site_has_ppec_subscriptions, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection_QueryCaching->query, W3TC_CallUnderlying->query, W3TC\DbCache_WpdbNew->query, W3TC\DbCache_WpdbInjection->query, W3TC\DbCache_WpdbNew->default_query
    [12-Jan-2024 17:46:05 UTC] PHP Fatal error: Uncaught TypeError: mysqli_num_fields(): Argument #1 ($result) must be of type mysqli_result, bool given in E:\Websites\MintErrors\wp-includes\class-wpdb.php:3868
    Stack trace: 0 E:\Websites\MintErrors\wp-includes\class-wpdb.php(3868): mysqli_num_fields() 1 E:\Websites\MintErrors\wp-includes\class-wpdb.php(780): wpdb->load_col_info() 2 E:\Websites\MintErrors\wp-content\plugins\w3-total-cache\DbCache_WpdbInjection_QueryCaching.php(218): wpdb->__get() 3 E:\Websites\MintErrors\wp-content\plugins\w3-total-cache\DbCache_WpdbNew.php(122): W3TC\DbCache_WpdbInjection_QueryCaching->query() 4 E:\Websites\MintErrors\wp-includes\class-wpdb.php(3031): W3TC\DbCache_WpdbNew->query() 5 E:\Websites\MintErrors\wp-content\plugins\woocommerce-paypal-payments\modules\ppcp-compat\src\PPEC\PPECHelper.php(79): wpdb->get_var() 6 E:\Websites\MintErrors\wp-content\plugins\woocommerce-paypal-payments\modules\ppcp-compat\src\PPEC\PPECHelper.php(117): WooCommerce\PayPalCommerce\Compat\PPEC\PPECHelper::site_has_ppec_subscriptions() 7 E:\Websites\MintErrors\wp-content\plugins\woocommerce-paypal-payments\modules\ppcp-compat\src\PPEC\SubscriptionsHandler.php(56): WooCommerce\PayPalCommerce\Compat\PPEC\PPECHelper::use_ppec_compat_layer_for_subscriptions() 8 E:\Websites\MintErrors\wp-content\plugins\woocommerce-paypal-payments\modules\ppcp-compat\src\CompatModule.php(76): WooCommerce\PayPalCommerce\Compat\PPEC\SubscriptionsHandler->maybe_hook() 9 E:\Websites\MintErrors\wp-content\plugins\woocommerce-paypal-payments\modules\ppcp-compat\src\CompatModule.php(43): WooCommerce\PayPalCommerce\Compat\CompatModule->initialize_ppec_compat_layer() 10 E:\Websites\MintErrors\wp-content\plugins\woocommerce-paypal-payments\bootstrap.php(67): WooCommerce\PayPalCommerce\Compat\CompatModule->run() 11 E:\Websites\MintErrors\wp-content\plugins\woocommerce-paypal-payments\woocommerce-paypal-payments.php(75): {closure}() 12 E:\Websites\MintErrors\wp-content\plugins\woocommerce-paypal-payments\woocommerce-paypal-payments.php(90): WooCommerce\PayPalCommerce\init() 13 E:\Websites\MintErrors\wp-includes\class-wp-hook.php(324): WooCommerce\PayPalCommerce{closure}() 14 E:\Websites\MintErrors\wp-includes\class-wp-hook.php(348): WP_Hook->apply_filters() 15 E:\Websites\MintErrors\wp-includes\plugin.php(517): WP_Hook->do_action() 16 E:\Websites\MintErrors\wp-settings.php(506): do_action() 17 E:\Websites\MintErrors\wp-config.php(99): require_once(‘…’) 18 E:\Websites\MintErrors\wp-load.php(50): require_once(‘…’) 19 E:\Websites\MintErrors\wp-blog-header.php(13): require_once(‘…’) 20 E:\Websites\MintErrors\index.php(17): require(‘…’) 21 {main}

    thrown in E:\Websites\MintErrors\wp-includes\class-wpdb.php on line 3868

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @minterrors,

    The error log and message you’ve shared indicate that plugins such as WooCommerce PayPal Payments and Product Feed PRO for WooCommerce are causing some issues. It seems like they might not be compatible with your current PHP or WooCommerce, or perhaps they’re conflicting with other plugins or your theme.

    To resolve these issues, you may try the following steps:

    • Ensure all your plugins and themes are up to date.
    • Deactivate all your plugins and then reactivate them one by one to see which one is causing the issue.
    • Check your current PHP version, it should be 74. to 8.1.27.
    • Check what you use on the Cart and Checkout page, Block or shortcode. If you use Block, replace with shortcode found here: https://woo.com/document/woocommerce-shortcodes/

    If the issues persist, please provide us the following:

    • System Status Report: Navigate to WooCommerce → Status. Select Get System Report and then Download for Support.

    You could copy and paste your reply or share it via Mozilla Community Pastebin and share the link here. This will help us investigate further and provide you with a more accurate solution.

    Looking forward to hearing from you!

    Thread Starter minterrors

    (@minterrors)

    Thanks for your quick reply.

    I rebooted the server and I was able to see the posts after Product Feed PRO for WooCommerce updated. The Product Feed PRO for WooCommerce was the only one that was not on “enable updates”. I have now assigned that to update automatically.

    The PHP and MySQL are among the newer versions.

    I will get back to the server here in a day or so and be able to perform the download for support link.

    I will leave this open for a day or two to see if there are any issues. If none, I will close the post.

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi again @minterrors,

    It’s great to hear that you’ve been able to see your posts after updating Product Feed PRO for WooCommerce and setting it to update automatically. By keeping your plugins up-to-date, you are ensuring the smooth running of your website.

    Please feel free to continue monitoring your server and website over the next few days, and don’t hesitate to reach out if you encounter any issues.

    We’re here to help.

    Thread Starter minterrors

    (@minterrors)

    closing post thanks for the quick reply

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘woocommerce throwing errors’ is closed to new replies.