Woocommerce – Error Connecting to Database

  • Hi
    I have been receiving frequent website crashes “error connecting to database” whenever there are heavy queries like database backup or even normal customer checkouts lately. The page keep loading and then the whole site is down for a few mins.

    I have paste the report below & error log below:

    
### WordPress Environment ###

WordPress address (URL): https://www.pizzaexpress.com.my
Site address (URL): https://www.pizzaexpress.com.my
WC Version: 3.7.0
REST API Version: ? 1.0.2
Log Directory Writable: ?
WP Version: 5.2.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: –
Language: en_GB
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.1.30 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 128 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.59.0
OpenSSL/1.0.2r

SUHOSIN Installed: –
MySQL Version: 5.6.40-84.0-log
Max Upload Size: 128 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.7.0
WC Database Prefix: wpvl_
Total Database Size: 918.52MB
Database Data Size: 495.39MB
Database Index Size: 423.13MB
wpvl_woocommerce_sessions: Data: 6.02MB + Index: 0.06MB + Engine InnoDB
wpvl_woocommerce_api_keys: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
wpvl_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpvl_woocommerce_order_items: Data: 11.52MB + Index: 6.52MB + Engine InnoDB
wpvl_woocommerce_order_itemmeta: Data: 139.69MB + Index: 68.19MB + Engine InnoDB
wpvl_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpvl_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpvl_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpvl_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpvl_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpvl_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpvl_comments: Data: 41.58MB + Index: 34.09MB + Engine InnoDB
wpvl_datalist: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpvl_ewwwio_images: Data: 2.52MB + Index: 2.83MB + Engine InnoDB
wpvl_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_gf_entry: Data: 5.52MB + Index: 1.95MB + Engine InnoDB
wpvl_gf_entry_meta: Data: 11.52MB + Index: 20.55MB + Engine InnoDB
wpvl_gf_entry_notes: Data: 0.13MB + Index: 0.06MB + Engine InnoDB
wpvl_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_gf_form_meta: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wpvl_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpvl_gf_form_view: Data: 0.41MB + Index: 0.33MB + Engine InnoDB
wpvl_image_compression_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_options: Data: 4.30MB + Index: 0.25MB + Engine InnoDB
wpvl_pmxe_exports: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
wpvl_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wpvl_pmxe_posts: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wpvl_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_postmeta: Data: 165.72MB + Index: 181.47MB + Engine InnoDB
wpvl_posts: Data: 14.52MB + Index: 10.06MB + Engine InnoDB
wpvl_po_plugins: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wpvl_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_rg_form_meta: Data: 0.39MB + Index: 0.00MB + Engine InnoDB
wpvl_rg_form_view: Data: 0.41MB + Index: 0.33MB + Engine InnoDB
wpvl_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_rg_lead: Data: 5.52MB + Index: 0.91MB + Engine InnoDB
wpvl_rg_lead_detail: Data: 7.52MB + Index: 17.06MB + Engine InnoDB
wpvl_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_rg_lead_meta: Data: 4.52MB + Index: 7.55MB + Engine InnoDB
wpvl_rg_lead_notes: Data: 0.13MB + Index: 0.06MB + Engine InnoDB
wpvl_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpvl_site: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_sitemeta: Data: 0.16MB + Index: 0.03MB + Engine InnoDB
wpvl_social_users: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_stock_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_termmeta: Data: 0.11MB + Index: 0.16MB + Engine InnoDB
wpvl_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wpvl_term_relationships: Data: 0.25MB + Index: 0.19MB + Engine InnoDB
wpvl_term_taxonomy: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wpvl_usermeta: Data: 55.59MB + Index: 57.17MB + Engine InnoDB
wpvl_users: Data: 3.52MB + Index: 4.55MB + Engine InnoDB
wpvl_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpvl_wc_points_rewards_user_points: Data: 1.52MB + Index: 3.03MB + Engine InnoDB
wpvl_wc_points_rewards_user_points_log: Data: 3.52MB + Index: 4.55MB + Engine InnoDB
wpvl_wc_point_of_sale_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wc_point_of_sale_sale_reports: Data: 0.08MB + Index: 0.01MB + Engine MyISAM
wpvl_wc_poin_of_sale_grids: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wc_poin_of_sale_outlets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wc_poin_of_sale_receipts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wc_poin_of_sale_registers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wc_poin_of_sale_tabs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wc_poin_of_sale_tabs_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wc_poin_of_sale_tiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
wpvl_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_wpaccounting_ledger: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wpvl_wpaccounting_meta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wpvl_wpfront_ure_options: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wp_wc_poin_of_sale_cache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpvl_wsluserscontacts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpvl_wslusersprofiles: Data: 0.22MB + Index: 0.03MB + Engine InnoDB
wpvl_yoast_seo_links: Data: 0.14MB + Index: 0.05MB + Engine InnoDB
wpvl_yoast_seo_meta: Data: 4.52MB + Index: 0.00MB + Engine InnoDB

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (31) ###

Gravity Forms: by rocketgenius – 2.4.10.9
WooCommerce eGHL Payment Gateways: by eGHL – 1.0.5 – Not tested with the active version of WooCommerce
Webcraftic Assets manager: by Webcraftic  – 1.0.7
Anti-Malware Security and Brute-Force Firewall: by Eli Scheetz – 4.18.76
Gravity Forms MailChimp Add-On: by rocketgenius – 4.6
Mailchimp for WordPress: by ibericode – 4.5.3
One Click Order Re-Order: by CedCommerce – 1.1.3
PayPal for WooCommerce: by Angell EYE – 1.5.7 – Not tested with the active version of WooCommerce
SG Optimiser: by SiteGround – 5.2.4
User Role Editor: by Vladimir Garagulya – 4.51.2
W3 Total Cache: by Frederick Townes – 0.9.7.5
WooCommerce Open Close: by Jaed Mosharraf – 2.5.7 – Not tested with the active version of WooCommerce
Advanced Order Export For WooCommerce: by AlgolPlus – 3.0.1 – Not tested with the active version of WooCommerce
Prevent Customers To Cancel WooCommerce Orders: by Tyche Softwares – 1.1 – Not tested with the active version of WooCommerce
WooCommerce Payment Gateway Based Fees: by InoPlugs – 3.1.5 – Not tested with the active version of WooCommerce
WooCommerce Checkout Add-Ons: by SkyVerge – 1.12.5 – Not tested with the active version of WooCommerce
Woocommerce Cooking Tracker: by Vijay Hardaha – 1.0.0 – Not tested with the active version of WooCommerce
WooCommerce Print Invoice & Delivery Note: by Tyche Softwares – 4.4.8 – Not tested with the active version of WooCommerce
WooCommerce Dynamic Pricing: by Lucas Stark – 3.1.13 – Not tested with the active version of WooCommerce
WooCommerce Email Customizer: by WooCommerce – 1.1.10 – Not tested with the active version of WooCommerce
WooCommerce Google Analytics Pro: by SkyVerge – 1.7.1 – Not tested with the active version of WooCommerce
WooCommerce Gravity Forms Product Add-Ons: by Lucas Stark – 3.3.8 – Not tested with the active version of WooCommerce
WooCommerce Order Status Manager: by SkyVerge – 1.9.4 – Not tested with the active version of WooCommerce
WooCommerce Points and Rewards: by WooCommerce – 1.6.22 – Not tested with the active version of WooCommerce
WooCommerce POS: by kilbot – 0.4.24
Woocommerce Rider Column: by Vijay Hardaha – 1.0.0 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 3.7.0
Yoast SEO Premium: by Team Yoast – 11.5
WordPress Social Login: by Miled – 2.3.3
WP-Members: by Chad Butler – 3.2.9.3
Yoast SEO: News: by Team Yoast – 11.5

### Inactive Plugins (3) ###

WooCommerce Point of Sale: by Actuality Extensions – 4.5.8 – Not tested with the active version of WooCommerce
WP-Sweep: by Lester 'GaMerZ' Chan – 1.1.0
WP Accounting: by David Barnes – 0.6.2

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
db.php: db.php

### Settings ###

API Enabled: ?
Force SSL: –
Currency: MYR (RM)
Currency Position: left
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 WooCommerce.com: –

### WC Pages ###

Shop base: #152486 - /shop/
Basket: #15 - /cart-online-food-delivery/
Checkout: #16 - /checkout-online-food-delivery/
My account: #17 - /food-delivery-account/
Terms and conditions: #12970 - /terms-conditions/

### Theme ###

Name: Pizza Express Malaysia
Version: 3.0
Author URL: 
Child Theme: ?
Parent Theme Name: Flatsome
Parent Theme Version: 3.8.4
Parent Theme Author URL: https://www.uxthemes.com/
WooCommerce Support: ?

### Templates ###

Overrides: flatsome/woocommerce/archive-product.php
flatsome/woocommerce/cart/cart-empty.php
flatsome/woocommerce/cart/cart-shipping.php
flatsome/woocommerce/cart/cart.php
flatsome/woocommerce/checkout/form-checkout.php
flatsome/woocommerce/checkout/form-coupon.php
flatsome/woocommerce/checkout/thankyou.php
flatsome/woocommerce/content-product.php
flatsome/woocommerce/content-product_cat.php
flatsome/woocommerce/content-single-product.php
flatsome/woocommerce/content-widget-product.php
flatsome/woocommerce/global/breadcrumb.php
flatsome/woocommerce/global/quantity-input.php
flatsome/woocommerce/global/wrapper-end.php
flatsome/woocommerce/global/wrapper-start.php
flatsome/woocommerce/loop/loop-end.php
flatsome/woocommerce/loop/loop-start.php
flatsome/woocommerce/loop/pagination.php
flatsome/woocommerce/loop/result-count.php
flatsome/woocommerce/loop/sale-flash.php
flatsome/woocommerce/myaccount/form-login.php
flatsome/woocommerce/myaccount/navigation.php
flatsome/woocommerce/notices/error.php
flatsome/woocommerce/notices/notice.php
flatsome/woocommerce/notices/success.php
flatsome/woocommerce/product-searchform.php
flatsome/woocommerce/single-product/photoswipe.php
flatsome/woocommerce/single-product/price.php
flatsome/woocommerce/single-product/product-image.php
flatsome/woocommerce/single-product/product-thumbnails.php
flatsome/woocommerce/single-product/rating.php
flatsome/woocommerce/single-product/related.php
flatsome/woocommerce/single-product/review.php
flatsome/woocommerce/single-product/sale-flash.php
flatsome/woocommerce/single-product/share.php
flatsome/woocommerce/single-product/short-description.php
flatsome/woocommerce/single-product/tabs/tabs.php
flatsome/woocommerce/single-product/title.php
flatsome/woocommerce/single-product/up-sells.php
flatsome/woocommerce/single-product-reviews.php
flatsome/woocommerce/single-product.php

### Action Scheduler ###

Complete: 18
Oldest: 2019-07-20 03:45:02 +0000
Newest: 2019-08-17 19:28:58 +0000

Pending: 1
Oldest: 2019-08-24 04:15:03 +0000
Newest: 2019-08-24 04:15:03 +0000

Canceled: 0
Oldest: –
Newest: –

In-progress: 0
Oldest: –
Newest: –

Failed: 0
Oldest: –
Newest: –

    Phperrorlog:

    [17-Aug-2019 16:03:15 UTC] status was called incorrectly. Order properties should not be accessed directly. Backtrace: require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action(‘wc_ajax_checkout’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::checkout, WC_Checkout->process_checkout, WC_Checkout->process_order_payment, WC_Gateway_COD->process_payment, WC_Order->update_status, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_changed’), WP_Hook->do_action, WP_Hook->apply_filters, status_changed_processsing, WC_Abstract_Legacy_Order->__get, wc_doing_it_wrong. This message was added in version 3.0.
    [17-Aug-2019 16:05:04 UTC] PHP Warning: A non-numeric value encountered in /home/pizzaexp/public_html/wp-content/plugins/woocommerce/includes/wc-product-functions.php on line 871
    [17-Aug-2019 16:10:12 UTC] PHP Warning: A non-numeric value encountered in /home/pizzaexp/public_html/wp-content/plugins/woocommerce/includes/wc-product-functions.php on line 871
    [17-Aug-2019 16:10:12 UTC] PHP Warning: A non-numeric value encountered in /home/pizzaexp/public_html/wp-content/plugins/woocommerce/includes/wc-product-functions.php on line 871
    [17-Aug-2019 16:19:05 UTC] PHP Warning: A non-numeric value encountered in /home/pizzaexp/public_html/wp-content/plugins/woocommerce/includes/wc-product-functions.php on line 871

Viewing 1 replies (of 1 total)
  • Thread Starter johnwicker

    (@johnwicker)

    [11-Aug-2019 16:01:53 UTC] status was called incorrectly. Order properties should not be accessed directly. Backtrace: require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::do_wc_ajax, do_action(‘wc_ajax_checkout’), WP_Hook->do_action, WP_Hook->apply_filters, WC_AJAX::checkout, WC_Checkout->process_checkout, WC_Checkout->process_order_payment, WC_Gateway_COD->process_payment, WC_Order->update_status, WC_Order->save, WC_Order->status_transition, do_action(‘woocommerce_order_status_changed’), WP_Hook->do_action, WP_Hook->apply_filters, status_changed_processsing, WC_Abstract_Legacy_Order->__get, wc_doing_it_wrong. This message was added in version 3.0.

Viewing 1 replies (of 1 total)
  • The topic ‘Woocommerce – Error Connecting to Database’ is closed to new replies.