• Resolved toulip

    (@toulip)


    Hello there,

    I hope you are doing well.

    I am a little bit confused with the Product attributes lookup table. Although I have regenerated the attributes lookup table and cleaned all transients from woo tools, I still cannot see the attributes’ filters on the shop archive when the option “Use the product attributes lookup table for catalog filtering.” is enabled from the woo products advanced settings.

    I can only see the filters if the above setting is disabled.

    Any ideas why this is happening? It’s the first time I come across with this behavior; I own many WooCommerce websites and all work great with the “Use the product attributes lookup table for catalog filtering.” option enabled.

    Thanks in advance,

    George.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hello,

    For better assistance, can you please share a copy of your site’s System Status Report? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”.?

    And please share a copy of any fatal error log found under WooCommerce > System Status > Logs (if any error is visible).

    This will permit us to get a better idea, thanks.

    Thread Starter toulip

    (@toulip)

    Hello @ihereira,

    Thanks for your quick response.

    Please find below my system status report:

    `
    ### WordPress Environment ###
    
    WordPress address (URL): https://home-electric.gr
    Site address (URL): https://home-electric.gr
    WC Version: 7.3.0
    REST API Version: ? 7.3.0
    WC Blocks Version: ? 9.1.5
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.1.1
    WP Multisite: –
    WP Memory Limit: 768 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: el
    External object cache: ?
    
    ### Server Environment ###
    
    Server Info: Apache
    PHP Version: 7.4.33
    PHP Post Max Size: 256 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 3000
    cURL Version: 7.85.0
    OpenSSL/3.0.8
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.39-42-log
    Max Upload Size: 256 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 7.3.0
    WC Database Prefix: z1tPi_
    Συνολικ? μ?γεθο? β?ση? δεδομ?νων: 29.21MB
    Μ?γεθο? β?ση? δεδομ?νων: 21.29MB
    Μ?γεθο? ευρετηρ?ου β?ση? δεδομ?νων: 7.92MB
    z1tPi_woocommerce_sessions: Δεδομ?να: 2.19MB + Ευρετ?ρια: 0.08MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_api_keys: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_attribute_taxonomies: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_downloadable_product_permissions: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_order_items: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_order_itemmeta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_tax_rates: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_tax_rate_locations: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_shipping_zones: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_shipping_zone_locations: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_shipping_zone_methods: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_payment_tokens: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_payment_tokenmeta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_woocommerce_log: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_actionscheduler_actions: Δεδομ?να: 0.14MB + Ευρετ?ρια: 0.16MB + Μηχαν? InnoDB.
    z1tPi_actionscheduler_claims: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_actionscheduler_groups: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_actionscheduler_logs: Δεδομ?να: 0.17MB + Ευρετ?ρια: 0.16MB + Μηχαν? InnoDB.
    z1tPi_aioseo_cache: Δεδομ?να: 0.33MB + Ευρετ?ρια: 0.09MB + Μηχαν? InnoDB.
    z1tPi_aioseo_notifications: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB.
    z1tPi_aioseo_posts: Δεδομ?να: 0.34MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_commentmeta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_comments: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.09MB + Μηχαν? InnoDB.
    z1tPi_links: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_options: Δεδομ?να: 1.52MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB.
    z1tPi_piraeusbank_transactions: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_postmeta: Δεδομ?να: 8.52MB + Ευρετ?ρια: 4.84MB + Μηχαν? InnoDB.
    z1tPi_posts: Δεδομ?να: 2.52MB + Ευρετ?ρια: 0.56MB + Μηχαν? InnoDB.
    z1tPi_revslider_css: Δεδομ?να: 0.13MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_revslider_css_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_revslider_layer_animations: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_revslider_layer_animations_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_revslider_navigations: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_revslider_navigations_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_revslider_sliders: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_revslider_sliders_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_revslider_slides: Δεδομ?να: 0.05MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_revslider_slides_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_revslider_static_slides: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_revslider_static_slides_bkp: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_sgs_log_events: Δεδομ?να: 3.52MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_sgs_log_visitors: Δεδομ?να: 0.06MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_termmeta: Δεδομ?να: 0.19MB + Ευρετ?ρια: 0.17MB + Μηχαν? InnoDB.
    z1tPi_terms: Δεδομ?να: 0.06MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB.
    z1tPi_term_relationships: Δεδομ?να: 0.23MB + Ευρετ?ρια: 0.17MB + Μηχαν? InnoDB.
    z1tPi_term_taxonomy: Δεδομ?να: 0.06MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB.
    z1tPi_ultimate_post_entries: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_usermeta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_users: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.05MB + Μηχαν? InnoDB.
    z1tPi_wc_admin_notes: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_wc_admin_note_actions: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_wc_category_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_wc_customer_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_wc_download_log: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_wc_order_coupon_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_wc_order_product_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.06MB + Μηχαν? InnoDB.
    z1tPi_wc_order_stats: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.05MB + Μηχαν? InnoDB.
    z1tPi_wc_order_tax_lookup: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.03MB + Μηχαν? InnoDB.
    z1tPi_wc_product_attributes_lookup: Δεδομ?να: 0.11MB + Ευρετ?ρια: 0.14MB + Μηχαν? InnoDB.
    z1tPi_wc_product_download_directories: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_wc_product_meta_lookup: Δεδομ?να: 0.13MB + Ευρετ?ρια: 0.17MB + Μηχαν? InnoDB.
    z1tPi_wc_rate_limits: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_wc_reserved_stock: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_wc_tax_rate_classes: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_wc_webhooks: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_woodmart_wishlists: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_woodmart_wishlist_products: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.02MB + Μηχαν? InnoDB.
    z1tPi_wpmailsmtp_debug_events: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    z1tPi_wpmailsmtp_tasks_meta: Δεδομ?να: 0.02MB + Ευρετ?ρια: 0.00MB + Μηχαν? InnoDB.
    
    ### Post Type Counts ###
    
    attachment: 1206
    cms_block: 7
    custom_css: 2
    ml-slide: 3
    ml-slider: 1
    nav_menu_item: 277
    oembed_cache: 9
    page: 15
    post: 1
    product: 549
    product_variation: 143
    revision: 3
    shop_coupon: 1
    wpcf7_contact_form: 1
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (18) ###
    
    All in One SEO: απ? τον/την All in One SEO Team – 4.3.1.1
    Classic Widgets: απ? τον/την Συντελεστ?? WordPress – 0.3
    Contact Form 7: απ? τον/την Takayuki Miyoshi – 5.7.3
    Google Analytics for WordPress by MonsterInsights: απ? τον/την MonsterInsights – 8.12.1
    WPBakery Page Builder: απ? τον/την Michael M - WPBakery.com – 6.10.0
    Loco Translate: απ? τον/την Tim Whitlock – 2.6.3
    Longer Permalinks: απ? τον/την Giannis Economou – 1.25
    Regenerate Thumbnails: απ? τον/την Alex Mills (Viper007Bond) – 3.1.5
    Slider Revolution: απ? τον/την ThemePunch – 6.6.10
    Safe SVG: απ? τον/την 10up – 2.0.3
    SiteGround Optimizer: απ? τον/την SiteGround – 7.3.1
    SiteGround Security: απ? τον/την SiteGround – 1.4.1
    Piraeus Bank WooCommerce Payment Gateway: απ? τον/την Papaki – 1.6.5.1
    WooCommerce: απ? τον/την Automattic – 7.3.0 (ενημ?ρωση στην ?κδοση 7.4.0 ε?ναι διαθ?σιμη)
    Woodmart Core: απ? τον/την  – 1.0.35
    WP Crontrol: απ? τον/την John Blackbourn & crontributors – 1.15.1
    WP Mail SMTP: απ? τον/την WPForms – 3.7.0
    Smart Image Resize PRO: απ? τον/την Nabil Lemsieh – 1.7.8
    
    ### Inactive Plugins (2) ###
    
    Advanced Database Cleaner PRO: απ? τον/την Younes JFR. – 3.2.2
    Under Construction: απ? τον/την WebFactory Ltd – 3.97
    
    ### Dropin Plugins (1) ###
    
    object-cache.php: Memcached
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: EUR (€)
    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: –
    Enforce Approved Product Download Directories: –
    Order datastore: WC_Order_Data_Store_CPT
    
    ### WC Pages ###
    
    Β?ση καταστ?ματο?: #6 - /shop/
    Καλ?θι: #7 - /cart/
    Ταμε?ο: #8 - /checkout/
    Ο λογαριασμ?? μου: #9 - /my-account/
    ?ροι και Προ?ποθ?σει?: #2128 - /terms-of-use/
    
    ### Theme ###
    
    Name: Woodmart Child
    Version: 1.0.0
    Author URL: https://xtemos.com
    Child Theme: ?
    Parent Theme Name: Woodmart
    Parent Theme Version: 7.0.4
    Parent Theme Author URL: https://themeforest.net/user/xtemos
    WooCommerce Support: ?
    
    ### Templates ###
    
    Overrides: woodmart/woocommerce/archive-product.php
    woodmart/woocommerce/cart/cart-item-data.php
    woodmart/woocommerce/cart/cart.php
    woodmart/woocommerce/cart/cross-sells.php
    woodmart/woocommerce/cart/mini-cart.php
    woodmart/woocommerce/checkout/form-checkout.php
    woodmart/woocommerce/checkout/thankyou.php
    woodmart/woocommerce/content-product-cat.php
    woodmart/woocommerce/content-product.php
    woodmart/woocommerce/content-single-product.php
    woodmart/woocommerce/content-widget-product.php
    woodmart/woocommerce/global/breadcrumb.php
    woodmart/woocommerce/global/form-login.php
    woodmart/woocommerce/global/quantity-input.php ?κδοση 4.0.0 ε?ναι ληγμ?νο. Η βασικ? ?κδοση ε?ναι η 7.2.0
    woodmart/woocommerce/loop/add-to-cart.php
    woodmart/woocommerce/loop/loop-end.php
    woodmart/woocommerce/loop/loop-start.php
    woodmart/woocommerce/loop/no-products-found.php
    woodmart/woocommerce/loop/orderby.php
    woodmart/woocommerce/loop/pagination.php
    woodmart/woocommerce/loop/sale-flash.php
    woodmart/woocommerce/myaccount/form-login.php
    woodmart/woocommerce/product-searchform.php
    woodmart/woocommerce/single-product/add-to-cart/grouped.php
    woodmart/woocommerce/single-product/add-to-cart/variable.php
    woodmart/woocommerce/single-product/meta.php
    woodmart/woocommerce/single-product/product-attributes.php
    woodmart/woocommerce/single-product/product-image.php
    woodmart/woocommerce/single-product/product-thumbnails.php
    woodmart/woocommerce/single-product/rating.php
    woodmart/woocommerce/single-product/related.php
    woodmart/woocommerce/single-product/sale-flash.php
    woodmart/woocommerce/single-product/tabs/description.php
    woodmart/woocommerce/single-product/tabs/tabs.php
    woodmart/woocommerce/single-product/title.php
    woodmart/woocommerce/single-product/up-sells.php
    woodmart/woocommerce/single-product.php
    
    Outdated Templates: ?
    					
    					
    						Μ?θετε πω? να κ?νετε ενημ?ρωση
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    multichannel-marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    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: minified-js
    new-product-management-experience
    settings
    
    Daily Cron: ? Next scheduled: 2023-02-28 09:48:56 +02:00
    Options: ?
    Notes: 23
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Canceled: 1
    Oldest: 2023-02-24 13:16:01 +0200
    Newest: 2023-02-24 13:16:01 +0200
    
    Complete: 334
    Oldest: 2023-01-30 20:40:16 +0200
    Newest: 2023-02-28 09:57:09 +0200
    
    Pending: 4
    Oldest: 2023-02-28 10:12:09 +0200
    Newest: 2023-03-10 05:00:44 +0200
    
    
    ### Status report information ###
    
    Generated at: 2023-02-28 10:09:29 +02:00
    `

    For the errors, I am leaving you one I can see below:

    2023-02-28T08:04:04+00:00 CRITICAL Uncaught Error: Call to a member function get() on null in /home/customer/www/home-electric.gr/public_html/wp-content/themes/woodmart-child/functions.php:118
    Stack trace:
    #0 /home/customer/www/home-electric.gr/public_html/wp-includes/class-wp-hook.php(308): enable_offline_payment_gateway_for_local_pickups(Array)
    #1 /home/customer/www/home-electric.gr/public_html/wp-includes/plugin.php(205): WP_Hook->apply_filters(Array, Array)
    #2 /home/customer/www/home-electric.gr/public_html/wp-content/plugins/woocommerce/includes/class-wc-payment-gateways.php(163): apply_filters('woocommerce_ava...', Array)
    #3 /home/customer/www/home-electric.gr/public_html/wp-content/plugins/woocommerce/src/Admin/Features/OnboardingTasks/Tasks/Payments.php(93): WC_Payment_Gateways->get_available_payment_gateways()
    #4 /home/customer/www/home-electric.gr/public_html/wp-content/plugins/woocommerce/src/Admin/Features/OnboardingTasks/Tasks/Payments.php(71): Automattic\WooCommerce\Admin\Features\OnboardingTasks\Tasks\Payments::has_gateways()
    #5 μ?σα στο /home/customer/www/home-electric.gr/public_html/wp-content/themes/woodmart-child/functions.php στην γραμμ? 118

    I do not believe that the issue is being occurred from the above error. I have tried to remove those lines from my functions.php file to see if the issue will go away but with no luck.

    Thanks in advance,

    George.

    Thread Starter toulip

    (@toulip)

    Hello @ihereira,

    Any updates on my issue? It’s been a while since I left you my system report here.

    Please let me know.

    Thanks in advance,

    George.

    Hi @toulip

    Sorry for the delayed reply and thanks for sharing the requested information above.

    I still cannot see the attributes’ filters on the shop archive when the option “Use the product attributes lookup table for catalog filtering.” is enabled from the woo products advanced settings.

    Going back to your original inquiry here, I would be happy to assist you, but I am not quite sure I understand your inquiry. Could you please provide additional details or clarify your question, so I can better assist you?

    If a screenshot would be helpful, I’d recommend using https://snipboard.io or https://skitch.com/. You can share the direct link to the image as a response to this topic.

    Plugin Support Beauty of Code (woo-hc)

    (@beautyofcode)

    Hi George

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – feel free to create a new topic  should you need any further help.

    Cheers!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Product attributes lookup table’ is closed to new replies.