Database Error SHOW FULL COLUMNS FROM `over_options`

  • Resolved therob

    (@therob)


    2 years, 11 months ago

    Hi there,

    with the help of query monitor i found out that on woocommerece category archive pages where i added extra content AND use woocommerce block elements “selected products” in the content below the product list, i get the following database error.

    Abfrage
    SHOW FULL COLUMNS
    FROM over_options
    add_option()

    Abruffunktion
    wp-includes/option.php:637
    set_transient(‘wc_onboarding_product_data’)
    wp-includes/option.php:945
    Automattic\W\A\F\Onboarding::append_product_data()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Features/Onboarding.php:600
    Automattic\W\A\F\Onboarding::get_allowed_product_types()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/Features/Onboarding.php:462
    Automattic\W\A\A\OnboardingProfile::get_profile_properties()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/OnboardingProfile.php:294
    Automattic\W\A\A\OnboardingProfile->get_item_schema()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/OnboardingProfile.php:469
    WP_REST_Controller->get_context_param()
    wp-includes/rest-api/endpoints/class-wp-rest-controller.php:387
    Automattic\W\A\A\OnboardingProfile->get_collection_params()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/OnboardingProfile.php:500
    Automattic\W\A\A\OnboardingProfile->register_routes()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/OnboardingProfile.php:59
    Automattic\W\A\A\Init->rest_api_init()
    wp-content/plugins/woocommerce/packages/woocommerce-admin/src/API/Init.php:124
    do_action(‘rest_api_init’)
    wp-includes/plugin.php:474
    rest_get_server()
    wp-includes/rest-api.php:553
    Automattic\W\B\RestApi->get_routes_from_namespace()
    wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/RestApi.php:56
    Automattic\W\B\B\AbstractBlock->enqueue_data()
    wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/BlockTypes/AbstractBlock.php:368
    Automattic\W\B\B\AbstractProductGrid->enqueue_data()
    wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/BlockTypes/AbstractProductGrid.php:662
    Automattic\W\B\B\AbstractBlock->enqueue_assets()
    wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/BlockTypes/AbstractBlock.php:339
    Automattic\W\B\B\AbstractBlock->render_callback()
    wp-content/plugins/woocommerce/packages/woocommerce-blocks/src/BlockTypes/AbstractBlock.php:85
    WP_Block->render()
    wp-includes/class-wp-block.php:255
    WP_Block->render()
    wp-includes/class-wp-block.php:241
    WP_Block->render()
    wp-includes/class-wp-block.php:241
    WP_Block->render()
    wp-includes/class-wp-block.php:241
    render_block()
    wp-includes/blocks.php:883
    do_blocks()
    wp-includes/blocks.php:921
    apply_filters(‘the_content’)
    wp-includes/plugin.php:189
    post__shortcode()
    wp-content/themes/generatepress_child/functions.php:295
    do_shortcode_tag()
    wp-includes/shortcodes.php:356
    preg_replace_callback()
    wp-includes/shortcodes.php:356
    do_shortcode()
    wp-includes/shortcodes.php:228
    apply_filters(‘woocommerce_short_description’)
    wp-includes/plugin.php:189
    wc_format_content()
    wp-content/plugins/woocommerce/includes/wc-formatting-functions.php:1091
    bbloomer_display_wp_editor_content()
    wp-content/themes/generatepress_child/functions.php:103
    do_action(‘woocommerce_after_main_content’)
    wp-includes/plugin.php:474
    wc_get_template()
    wp-content/plugins/woocommerce/includes/wc-core-functions.php:345

    How severe is this error? How to fix? is it possible that this is responsible for weird loading time behavoir that i see on those pages as well (long TTFB / Idle times on first views)?

    Thanks a lot for your help!

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter therob

    (@therob)

    System Report

    
### WordPress Environment ###

WordPress address (URL): https://overjoyd.com
Site address (URL): https://overjoyd.com
WC Version: 6.3.1
REST API Version: ? 6.3.1
WC Blocks Version: ? 6.9.0
Action Scheduler Version: ? 3.4.0
WC Admin Version: ? 3.2.1
Log Directory Writable: ?
WP Version: 5.9.3
WP Multisite: –
WP Memory Limit: 4 GB
WP Debug Mode: –
WP Cron: ?
Language: de_DE
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 8.0.16
PHP Post Max Size: 64 MB
PHP Time Limit: 600
PHP Max Input Vars: 10000
cURL Version: 7.74.0
OpenSSL/1.1.1k

SUHOSIN Installed: –
MySQL Version: 10.5.15-MariaDB-1:10.5.15+maria~bullseye-log
Max Upload Size: 32 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 6.3.1
WC Database Prefix: over_
Datenbank-Gesamtgr??e: 422.25MB
Datenbank-Datengr??e: 392.69MB
Datenbank-Indexgr??e: 29.56MB
over_woocommerce_sessions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_api_keys: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_attribute_taxonomies: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_downloadable_product_permissions: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_order_items: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_order_itemmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_tax_rates: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_tax_rate_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_shipping_zones: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_shipping_zone_locations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_shipping_zone_methods: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_payment_tokens: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_payment_tokenmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_woocommerce_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_actionscheduler_actions: Daten: 0.98MB + Index: 0.36MB + Engine MyISAM
over_actionscheduler_claims: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_actionscheduler_groups: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
over_actionscheduler_logs: Daten: 0.66MB + Index: 0.45MB + Engine MyISAM
over_affegg_autoblog: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_affegg_autoblog_item: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_affegg_catalog: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_affegg_egg: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_affegg_price_alert: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_affegg_price_history: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_affegg_product: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_berocket_termmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_cegg_autoblog: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_cegg_price_alert: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_cegg_price_history: Daten: 0.59MB + Index: 0.75MB + Engine MyISAM
over_cegg_product: Daten: 1.49MB + Index: 0.27MB + Engine MyISAM
over_commentmeta: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_comments: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_ewwwio_images: Daten: 0.62MB + Index: 0.32MB + Engine MyISAM
over_ewwwio_queue: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_exi_autoimport: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_exi_autoimport_item: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_exi_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_exi_query: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_exi_task: Daten: 0.05MB + Index: 0.00MB + Engine MyISAM
over_icl_content_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_core_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_flags: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_languages: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
over_icl_languages_translations: Daten: 0.11MB + Index: 0.11MB + Engine MyISAM
over_icl_locale_map: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_message_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_mo_files_domains: Daten: 0.08MB + Index: 0.04MB + Engine MyISAM
over_icl_node: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_reminders: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_strings: Daten: 2.09MB + Index: 1.32MB + Engine MyISAM
over_icl_string_batches: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_string_packages: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
over_icl_string_pages: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_string_positions: Daten: 0.07MB + Index: 0.03MB + Engine MyISAM
over_icl_string_status: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_string_translations: Daten: 1.24MB + Index: 0.20MB + Engine MyISAM
over_icl_string_urls: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_icl_translate: Daten: 77.52MB + Index: 3.97MB + Engine MyISAM
over_icl_translate_job: Daten: 0.50MB + Index: 0.20MB + Engine MyISAM
over_icl_translations: Daten: 0.62MB + Index: 0.96MB + Engine MyISAM
over_icl_translation_batches: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
over_icl_translation_downloads: Daten: 0.02MB + Index: 0.00MB + Engine InnoDB
over_icl_translation_status: Daten: 151.99MB + Index: 0.23MB + Engine MyISAM
over_imagify_files: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_imagify_folders: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_links: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_options: Daten: 4.75MB + Index: 0.35MB + Engine MyISAM
over_postmeta: Daten: 52.88MB + Index: 6.19MB + Engine MyISAM
over_posts: Daten: 18.44MB + Index: 1.12MB + Engine MyISAM
over_termmeta: Daten: 0.42MB + Index: 0.34MB + Engine MyISAM
over_terms: Daten: 0.12MB + Index: 0.16MB + Engine MyISAM
over_term_relationships: Daten: 4.24MB + Index: 8.46MB + Engine MyISAM
over_term_taxonomy: Daten: 0.55MB + Index: 0.10MB + Engine MyISAM
over_toolset_associations: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_toolset_connected_elements: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_toolset_post_guid_id: Daten: 0.01MB + Index: 0.02MB + Engine MyISAM
over_toolset_relationships: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_toolset_type_sets: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_usermeta: Daten: 0.06MB + Index: 0.02MB + Engine MyISAM
over_users: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
over_wc_admin_notes: Daten: 0.02MB + Index: 0.00MB + Engine MyISAM
over_wc_admin_note_actions: Daten: 0.01MB + Index: 0.00MB + Engine MyISAM
over_wc_category_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wc_customer_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wc_download_log: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wc_order_coupon_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wc_order_product_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wc_order_stats: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wc_order_tax_lookup: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wc_product_attributes_lookup: Daten: 1.07MB + Index: 1.00MB + Engine MyISAM
over_wc_product_meta_lookup: Daten: 0.18MB + Index: 0.33MB + Engine MyISAM
over_wc_rate_limits: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wc_reserved_stock: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wc_tax_rate_classes: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
over_wc_webhooks: Daten: 0.00MB + Index: 0.00MB + Engine MyISAM
over_wpr_rucss_resources: Daten: 1.52MB + Index: 0.02MB + Engine MyISAM
over_wpr_rucss_used_css: Daten: 62.38MB + Index: 0.10MB + Engine MyISAM
over_yoast_indexable: Daten: 5.68MB + Index: 1.13MB + Engine MyISAM
over_yoast_indexable_hierarchy: Daten: 0.23MB + Index: 0.56MB + Engine MyISAM
over_yoast_migrations: Daten: 0.00MB + Index: 0.01MB + Engine MyISAM
over_yoast_primary_term: Daten: 0.04MB + Index: 0.05MB + Engine MyISAM
over_yoast_seo_links: Daten: 1.44MB + Index: 0.35MB + Engine MyISAM

### Post Type Counts ###

attachment: 4757
br_labels: 2
custom_css: 3
gp_elements: 68
helpie_faq: 398
nav_menu_item: 1467
page: 202
post: 3
product: 3321
revision: 330
wp_block: 8
wp_global_styles: 602
wp_navigation: 4
wp-types-group: 1

### Security ###

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

### Active Plugins (29) ###

Query Monitor: von John Blackbourn – 3.8.2
WPML Multilingual CMS: von OnTheGoSystems – 4.5.5
WPML SEO: von OnTheGoSystems – 2.0.1
Advanced Cron Manager: von BracketSpace – 2.4.2
WooCommerce Advanced Product Labels: von BeRocket – 1.2.3.7
Affiliate Egg Pro: von keywordrush.com – 10.3.5
FiboSearch - AJAX Search for WooCommerce: von FiboSearch Team – 1.17.0
PublishPress Capabilities Pro: von PublishPress – 2.3.4
Classic Widgets: von WordPress-Mitwirkende – 0.3
Clean and Simple Contact Form: von Alan Fuller – 4.7.10
Content Egg Pro: von keywordrush.com – 10.1.1
Disable WooCommerce Bloat: von ospiotr – 2.6.5
Yoast Duplicate Post: von Enrico Battocchi & Team Yoast – 4.4
GenerateBlocks: von Tom Usborne – 1.4.2
GP Premium: von Tom Usborne – 2.1.2
GutenCon: von Wpsoul – 5.2
Imagify | Prevent Larger WebP: von WP Media –
Imagify: von WP Media – 1.10
Perfmatters: von forgemedia – 1.8.8
Product Filter for WooCommerce: von XforWooCommerce – 8.2.0
UpdraftPlus – Sichern/Wiederherstellen: von UpdraftPlus.Com
DavidAnderson – 2.22.11.1

WPC Smart Wishlist for WooCommerce: von WPClever – 2.9.6
WooCommerce Multilingual: von OnTheGoSystems – 4.12.6
WooCommerce: von Automattic – 6.3.1
Yoast SEO: von Team Yoast – 18.4.1
WP Rocket: von WP Media – 3.10.9
WPML Media: von OnTheGoSystems – 2.7.0
WPML String Translation: von OnTheGoSystems – 3.2.1
Related Products for WooCommerce: von WebToffee – 1.4.2

### Inactive Plugins (5) ###

Better Search Replace: von Delicious Brains – 1.3.4
Bulk Category Editor for WooCommerce: von Consortia – 1.2.1
GDPR Cookie Consent: von WebToffee – 2.1.1
Prosodia VGW OS: von Prosodia – Verlag für Musik und Literatur – 3.25.3
PW WooCommerce Bulk Edit: von Pimwick
LLC – 2.95

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
db.php: Query Monitor Database Class

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right
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-Basis: #136 - geschenkefinder/
Warenkorb: ? Die Sichtbarkeit der Seite sollte  ?ffentlich sein
Kasse: ? Die Sichtbarkeit der Seite sollte  ?ffentlich sein
Mein Konto: #139 - my-account/
Allgemeine Gesch?ftsbedingungen: ? Seite nicht festgelegt

### Theme ###

Name: GeneratePress Child
Version: 0.1
Author URL: https://tomusborne.com
Child Theme: ?
Parent Theme Name: GeneratePress
Parent Theme Version: 3.1.3
Parent Theme Author URL: https://tomusborne.com
WooCommerce Support: ?

### Templates ###

Overrides: generatepress_child/woocommerce/content-single-product.php
generatepress_child/woocommerce/loop/price.php
generatepress_child/woocommerce/single-product.php

### Action Scheduler ###

Abgeschlossen: 3.728
Oldest: 2022-03-06 17:37:08 +0100
Newest: 2022-04-06 09:49:10 +0200

### Status report information ###

Generated at: 2022-04-06 09:59:35 +02:00
    Plugin Support Paulo P – a11n

    (@paulostp)

    Hello,

    Thanks for reaching out!

    I see references to woocommerce-admin and woocommerce-blocks in that error. Can you try installing the standalone WooCommerce Admin and WooCommerce Blocks plugins? WooCommerce core includes portions of both, but not the latest developments.

    Make sure you have a full backup before installing anything, or a staging site to perform tests.

    Let us know how it goes.

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. If you have further questions, please feel free to open a new topic.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Database Error SHOW FULL COLUMNS FROM `over_options`’ is closed to new replies.