class-wc-helper-options.php

  • Resolved ixthus27

    (@ixthus27)


    4 years, 7 months ago

    I am getting the following Warning in my Dashboard:
    Warning: array_key_exists() expects parameter 2 to be array, boolean given in /home/customer/www/rusticlogoriginals.com/public_html/wp-content/plugins/woocommerce/includes/admin/helper/class-wc-helper-options.php on line 48

    I have installed the Health Check & Troubleshooting to troubleshoot the issue. When I enabled WooCommerce, the Warning returned. When I disabled Woo, the Warning went away. When I enabled other plugins and themes, the warning did not return.

    So I deleted WooCommerce and installed a fresh copy from the Plugin page. When activated, the Warning returned. Please advise

    WooCommerce Status Report:

    
### WordPress Environment ###

WordPress address (URL): https://rusticlogoriginals.com
Site address (URL): https://rusticlogoriginals.com
WC Version: 4.3.1
REST API Version: ? 1.0.10
WC Blocks Version: ? 2.7.2
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.3.1
Log Directory Writable: ?
WP Version: 5.4.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: ?

### Server Environment ###

Server Info: Apache
PHP Version: 7.2.32
PHP Post Max Size: 128 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.66.0
OpenSSL/1.1.1g-fips

SUHOSIN Installed: –
MySQL Version: 5.7.25-28-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: 4.3.1
WC Database Prefix: rlo_
Total Database Size: 41.91MB
Database Data Size: 33.11MB
Database Index Size: 8.80MB
rlo_woocommerce_sessions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_woocommerce_order_items: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
rlo_woocommerce_order_itemmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
rlo_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_actionscheduler_actions: Data: 0.34MB + Index: 0.27MB + Engine InnoDB
rlo_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rlo_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rlo_actionscheduler_logs: Data: 0.19MB + Index: 0.17MB + Engine InnoDB
rlo_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rlo_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_comments: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
rlo_ewwwio_images: Data: 1.52MB + Index: 1.69MB + Engine InnoDB
rlo_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rlo_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
rlo_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rlo_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_options: Data: 17.87MB + Index: 0.29MB + Engine MyISAM
rlo_postmeta: Data: 8.96MB + Index: 3.63MB + Engine MyISAM
rlo_posts: Data: 1.23MB + Index: 0.28MB + Engine MyISAM
rlo_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_terms: Data: 0.12MB + Index: 0.26MB + Engine MyISAM
rlo_term_relationships: Data: 0.12MB + Index: 0.24MB + Engine MyISAM
rlo_term_taxonomy: Data: 0.13MB + Index: 0.14MB + Engine MyISAM
rlo_usermeta: Data: 0.06MB + Index: 0.03MB + Engine MyISAM
rlo_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rlo_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rlo_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rlo_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rlo_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rlo_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
rlo_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
rlo_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rlo_wc_product_meta_lookup: Data: 0.25MB + Index: 0.48MB + Engine InnoDB
rlo_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rlo_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rlo_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wordbook_errorlogs: Data: 0.11MB + Index: 0.02MB + Engine MyISAM
rlo_wordbook_postcomments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wordbook_postlogs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wordbook_userdata: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rlo_wpsc_also_bought: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_cart_contents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_cart_item_variations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_categorisation_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_wpsc_category_tm: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_wpsc_checkout_forms: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_claimed_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_coupon_codes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_currency_list: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
rlo_wpsc_download_status: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_item_category_assoc: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_logged_subscriptions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_meta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_wpsc_productmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_wpsc_product_categories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
rlo_wpsc_product_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_product_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_product_list: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_product_order: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_product_rating: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_product_variations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_purchase_logs: Data: 0.00MB + Index: 0.02MB + Engine MyISAM
rlo_wpsc_purchase_statuses: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_region_tax: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_submited_form_data: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
rlo_wpsc_variation_assoc: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_variation_combinations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_variation_properties: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_variation_values: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_wpsc_variation_values_assoc: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
rlo_yoast_indexable: Data: 1.52MB + Index: 0.42MB + Engine InnoDB
rlo_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
rlo_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
rlo_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
rlo_yoast_prominent_words: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
rlo_yoast_seo_links: Data: 0.08MB + Index: 0.03MB + Engine MyISAM
rlo_yoast_seo_meta: Data: 0.09MB + Index: 0.10MB + Engine MyISAM

### Post Type Counts ###

attachment: 1023
custom_css: 2
nav_menu_item: 7
page: 19
post: 4
product: 239
product_variation: 1708
saswp: 5
shop_order: 62

### Security ###

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

### Active Plugins (25) ###

Accelerated Mobile Pages: by Ahmed Kaludi
Mohammed Kaludi – 1.0.61.2

Akismet Anti-Spam: by Automattic – 4.1.6
AMP Blocks: by Magazine3 – 1.6.3
AMP Cache: by AMPforWP Team – 2.2.7
AMP Layouts: by Ahmed Kaludi
Mohammed Kaludi – 1.9.25

AMP Pro Extension Manager: by AMPforWP Team – 1.0.9
AMP Theme Framework: by AMPforWP Team – 1.0
AMP WooCommerce Pro: by AMPforWP Team – 3.3.8 – Installed version not tested with active version of WooCommerce 4.3.1
BackupBuddy: by iThemes – 8.6.0.0
Facebook for WooCommerce: by Facebook – 2.0.0
Health Check & Troubleshooting: by The www.ads-software.com community – 1.4.4
Imagify: by WP Media – 1.9.10
Jetpack by WordPress.com: by Automattic – 8.8
Pinterest for AMP: by AMPforWP Team – 1.1.1
Really Simple SSL: by Really Simple Plugins – 3.3.4
Schema & Structured Data for WP & AMP: by Magazine3 – 1.9.46
SG Optimizer: by SiteGround – 5.6.1
AMP Shortcodes Ultimate: by AMPforWP Team – 1.5.7
Shortcodes Ultimate: by Vladimir Anokhin – 5.9.2
WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.0.3
WooCommerce: by Automattic – 4.3.1
Yoast SEO Premium: by Team Yoast – 14.7
Yoast SEO: Local: by Team Yoast and Arjan Snaterse – 13.4
Yoast SEO: Video: by Team Yoast – 13.2
Yoast SEO: WooCommerce: by Team Yoast – 13.4

### Inactive Plugins (2) ###

AMP Gravity Forms: by Mohammed Kaludi
Ahmed Kaludi – 2.9.9

Product Feed ELITE for WooCommerce: by AdTribes.io – 1.1.7 – Installed version not tested with active version of WooCommerce 4.3.1

### Dropin Plugins (1) ###

object-cache.php: Memcached

### Must Use Plugins (1) ###

Health Check Troubleshooting Mode: by  – 1.7.1

### Settings ###

API Enabled: ?
Force SSL: –
Currency: USD ($)
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: #131 - /shop/
Cart: #132 - /cart/
Checkout: #13 - /products-page/checkout/
My account: #133 - /my-account/
Terms and conditions: #7320 - /policies-and-shipping/

### Theme ###

Name: Twenty Twenty
Version: 1.4
Author URL: https://www.ads-software.com/
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: –

### Action Scheduler ###

Complete: 763
Oldest: 2020-07-05 23:01:21 -0400
Newest: 2020-08-05 22:10:32 -0400

Pending: 1
Oldest: 2020-08-05 22:44:30 -0400
Newest: 2020-08-05 22:44:30 -0400

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

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support kellymetal a11n

    (@kellymetal)

    Hi there,

    Based on the error and taking a look at the code it is referring to, it seems like it is trying to retrieve an option from the wp_options table, however it’s being passed a boolean instead of an array.

    Which page in your admin dashboard is that error being displayed on? Would you mind sending a screenshot of what you are seeing and where it is being shown? I recommend https://snipboard.io for easily sharing screenshots – please follow the instructions on the page, then paste the URL in your reply here.

    Also, if you try going to WooCommerce > Status > Tools, and run the Tools to “Clear Transients” and “Clear WooCommerce Transients”, does that make a difference?

    Please let me know about the above points, or if you have any questions. Thank you!

    Hi @ixthus27,

    It’s been a while since we heard from you, so I’m marking this thread resolved. Hopefully, you’ve been able to resolve this, but if you haven’t, please let open up a new topic and we’ll be happy to help out.

    Thanks!

    Was there every any resolution to this? I have the exact same problem…

    So I solved my problem. It seems to have (most probably) occured during the migration of the site.

    The value of ‘woocommerce_helper_data’ should be an array, and upon first inspection does appear to be a serialixed array. I ended up ‘rebuilding’ the serialised data as an array variable in php and then outputting that array as serialised:

    $str = serialize($array);
    $strenc = urlencode($str);
    print $str . "\n";
    print $strenc . "\n";

    i then took the output from this and copied/pasted it into the MySQL field in phpMyAdmin. Problem solved.

    Thread Starter ixthus27

    (@ixthus27)

    Where did you put this code to execute and get the data?

    I cannot get this error to go away!

    Thread Starter ixthus27

    (@ixthus27)

    @kellymetal, The error shows on all Dashboard pages.

    2020-08-20_20-18-18

    I have cleared transients, but that does not resolve the issue.

    Thread Starter ixthus27

    (@ixthus27)

    @sguilliard Can you explain how you executed the code?

    This is my issue. The value in MySQL is incorrect after a migration. Can you explain more about how to run this code and get the value?

    Hello @sguilliard or @nicolamustone or @ixthus27 — I am having the same problem.

    How do I rebuild the serialised data as an array variable in php?

    Thanks!

    • This reply was modified 3 years, 11 months ago by neilscott.

    The likely reason this occurs when a site is migrated is because the path or domain has changed. Some data is stored in the database in php serialized format. The serialized data contains character counts. Most migration tools perform a simple find and replace in the database and this means the character count no longer matches the actual number of characters rendering the serialized data void.

    To fix this you could manually change the counts to be the right number of characters however there’s some room for human error there, you could code this with some PHP. However a quick solution is to extract the problem data and paste it into a fixer website, fix it then replace it in the database. I used this one (not affiliated to this – it’s a mess but worked), https://puvox.software/tools/serialization-fixer

    So the process is:

    SELECT * FROM wp_options where option_name = 'woocommerce_helper_data';

    Copy the result in the option_value field.

    Use a site or PHP to fix the serialization.

    Update the option_value where option_name = ‘woocommerce_helper_data’ in the wp_options table with the fixed data.

    • This reply was modified 3 years, 9 months ago by louisatwork.
    • This reply was modified 3 years, 9 months ago by louisatwork.

    Thanks @louisatwork

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘class-wc-helper-options.php’ is closed to new replies.