Robert Bamm

Hello,

I tried that but it doesn’t seem to have changed anything. The Enable table usage was already checked. I did try to enable the other option next to the table option, but didn’t help. I also tried regenerating the attribute table and I emptied the transients. At the moment the Swedish attribute filters are working but the seconday language attribute filters aren’t visible.

Swedish:
https://smedlunds.com/produkt-kategori/klockor/

Finnish:
https://smedlunds.com/fi/tuote-osasto/kellot/

Hi,

Yes, I can confirm that the problem persists even though all plugins except woocommerce is active. I also deactivated Astra and activated storefront. You can have a look here:

https://bammhemsidor.fi/smedlunds/produkt-kategori/ringar/

Can you also mark this thread as not resolved. Now it says it’s resolved, which it isn’t.

It’s not working normally, not even close. At the moment it only displays some of the attribute filters. A lot of them are completely missing, even though they are inserted in the widget sidebar. After regenerating the attribute table it works for an hour or so, then it automatically reverts to the state where it’s not working. I’ve read other threads where the exact same problem is occuring. So it’s not just me ??

I have created a staging site, how should I share the credentials? Just here in normal reply?

System report:

### WordPress Environment ###

WordPress address (URL): https://smedlunds.com
Site address (URL): https://smedlunds.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.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: sv_SE
External object cache: –

### Server Environment ###

Server Info: Microsoft-IIS/10.0
PHP Version: 7.4.28
PHP Post Max Size: 32 MB
PHP Time Limit: 300
PHP Max Input Vars: 20000
cURL Version: 7.70.0
OpenSSL/1.1.1l

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.6.5-MariaDB
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: jnokbk_
Total databasstorlek: 428.64MB
Datastorlek f?r databas: 236.97MB
Indexstorlek f?r databas: 191.67MB
jnokbk_woocommerce_sessions: Data: 2.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.17MB + Motor InnoDB
jnokbk_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_woocommerce_tax_rates: Data: 0.02MB + Index: 0.08MB + Motor InnoDB
jnokbk_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_actionscheduler_actions: Data: 1.50MB + Index: 1.06MB + Motor InnoDB
jnokbk_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_actionscheduler_logs: Data: 0.28MB + Index: 0.20MB + Motor InnoDB
jnokbk_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_cleantalk_sessions: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_cleantalk_sfw: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_commentmeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_comments: Data: 0.02MB + Index: 0.09MB + Motor InnoDB
jnokbk_e_submissions: Data: 0.02MB + Index: 0.27MB + Motor InnoDB
jnokbk_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Motor InnoDB
jnokbk_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_icl_content_status: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_icl_core_status: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_icl_flags: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_icl_languages: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_icl_languages_translations: Data: 0.20MB + Index: 0.17MB + Motor InnoDB
jnokbk_icl_locale_map: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_icl_message_status: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_icl_mo_files_domains: Data: 0.08MB + Index: 0.02MB + Motor InnoDB
jnokbk_icl_node: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_icl_reminders: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_icl_strings: Data: 1.52MB + Index: 2.98MB + Motor InnoDB
jnokbk_icl_string_batches: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_icl_string_packages: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_icl_string_pages: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_icl_string_positions: Data: 0.14MB + Index: 0.02MB + Motor InnoDB
jnokbk_icl_string_status: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_icl_string_translations: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_icl_string_urls: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_icl_translate: Data: 5.48MB + Index: 1.52MB + Motor InnoDB
jnokbk_icl_translate_job: Data: 0.19MB + Index: 0.11MB + Motor InnoDB
jnokbk_icl_translations: Data: 2.52MB + Index: 6.05MB + Motor InnoDB
jnokbk_icl_translation_batches: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_icl_translation_downloads: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_icl_translation_status: Data: 22.48MB + Index: 0.16MB + Motor InnoDB
jnokbk_imagify_files: Data: 0.02MB + Index: 0.08MB + Motor InnoDB
jnokbk_imagify_folders: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_links: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_ninja_table_items: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_options: Data: 12.03MB + Index: 1.38MB + Motor InnoDB
jnokbk_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_postmeta: Data: 102.55MB + Index: 61.89MB + Motor InnoDB
jnokbk_posts: Data: 11.05MB + Index: 4.92MB + Motor InnoDB
jnokbk_rank_math_analytics_objects: Data: 0.11MB + Index: 0.05MB + Motor InnoDB
jnokbk_rank_math_internal_links: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_rank_math_internal_meta: Data: 0.09MB + Index: 0.00MB + Motor InnoDB
jnokbk_termmeta: Data: 0.06MB + Index: 0.06MB + Motor InnoDB
jnokbk_terms: Data: 0.05MB + Index: 0.03MB + Motor InnoDB
jnokbk_term_relationships: Data: 2.38MB + Index: 1.38MB + Motor InnoDB
jnokbk_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Motor InnoDB
jnokbk_usermeta: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_users: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Motor InnoDB
jnokbk_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_wc_download_log: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
jnokbk_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_wc_product_meta_lookup: Data: 1.52MB + Index: 1.64MB + Motor InnoDB
jnokbk_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_wc_webhooks: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wdr_order_item_discounts: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wdr_rules: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wfblockediplog: Data: 0.30MB + Index: 0.00MB + Motor InnoDB
jnokbk_wfblocks7: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_wfconfig: Data: 1.34MB + Index: 0.00MB + Motor InnoDB
jnokbk_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wffilechanges: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wffilemods: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wfhits: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_wfhoover: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_wfissues: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
jnokbk_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_wflocs: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wflogins: Data: 0.02MB + Index: 0.03MB + Motor InnoDB
jnokbk_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Motor InnoDB
jnokbk_wfls_settings: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wfnotifications: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
jnokbk_wfreversecache: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_wfstatus: Data: 0.13MB + Index: 0.09MB + Motor InnoDB
jnokbk_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Motor InnoDB
jnokbk_wpr_rucss_resources: Data: 0.02MB + Index: 0.06MB + Motor InnoDB
jnokbk_wpr_rucss_used_css: Data: 0.02MB + Index: 0.05MB + Motor InnoDB
jnokbk_wsal_metadata: Data: 56.59MB + Index: 96.36MB + Motor InnoDB
jnokbk_wsal_occurrences: Data: 10.52MB + Index: 9.03MB + Motor InnoDB

### Post Type Counts ###

attachment: 7755
bsf-sidebar: 1
custom_css: 1
customize_changeset: 1
elementor_library: 7
nav_menu_item: 46
ninja-table: 1
oembed_cache: 1
page: 17
post: 3
postman_sent_mail: 117
product: 4301
product_variation: 10399
revision: 112
shop_coupon: 4
shop_order: 12
wp_global_styles: 1

### Security ###

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

### Active Plugins (30) ###

ManageWP - Worker: av GoDaddy – 4.9.13
WPML Multilingual CMS: av OnTheGoSystems – 4.5.5
Advanced Product Fields for WooCommerce: av StudioWombat – 1.4.6
All-in-One WP Migration Unlimited Extension: av ServMask – 2.44
All-in-One WP Migration: av ServMask – 7.56
Astra Pro: av Brainstorm Force – 3.6.6
Astra Bulk Edit: av Brainstorm Force – 1.2.6
Astra Widgets: av Brainstorm Force – 1.2.9
Classic Widgets: av Bidragsgivare till WordPress – 0.3
Anti-Spam by CleanTalk: av СleanTalk  – 5.173
Customizer Search: av Brainstorm Force – 1.1.6
Elementor Pro: av Elementor.com – 3.6.3
Elementor: av Elementor.com – 3.5.6
Head, Footer and Post Injections: av Stefano Lissa – 3.2.2
Imagify: av WP Media – 1.10
Kadence WooCommerce Email Designer: av Kadence WP – 1.4.10
Klarna Checkout for WooCommerce: av Krokedil – 2.7.1
Klarna Order Management for WooCommerce: av klarna
krokedil – 1.6.9

Ninja Tables: av WPManageNinja LLC – 4.1.12
Post SMTP: av Yehuda Hassine – 2.0.24
PW WooCommerce Gift Cards Pro: av Pimwick
LLC – 1.364

Rank Math SEO: av Rank Math – 1.0.84
WooCommerce Multilingual: av OnTheGoSystems – 4.12.6
WooCommerce: av Automattic – 6.3.1
Wordfence Security: av Wordfence – 7.5.8
Analytify - Google Analytics Dashboard: av Analytify – 4.1.7
WP Rocket: av WP Media – 3.10.8
WP Activity Log: av WP White Security – 4.4.0
WPML String Translation: av OnTheGoSystems – 3.2.1
WPS Hide Login: av WPServeur
NicolasKulka
wpformation – 1.9.3

### Inactive Plugins (2) ###

Sidebar Manager: av Brainstorm Force – 1.1.7
Woo Discount Rules: av Flycart – 2.3.13

### Dropin Plugins (1) ###

advanced-cache.php: advanced-cache.php

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

ManageWP - Worker Loader: av GoDaddy – 1.0.0

### Settings ###

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right_space
Thousand Separator: 
Decimal Separator: ,
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
pw gift card (pw-gift-card)
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 ###

Butikbas: #12 - /butik/
Varukorg: #13 - /varukorg/
Kassan: #14 - /kassan/
Mitt konto: #15 - /mitt-konto/
Allm?nna villkor: #68 - /kop-och-leveransvillkor/

### Theme ###

Name: Astra
Version: 3.7.9
Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
Child Theme: ? – Om du modifierar WooCommerce p? ett modertema som du sj?lv inte byggt
s? rekommenderar vi att du anv?nder ett barntema ist?llet. L?s: Hur du skapar ett barntema

WooCommerce Support: ?

### Templates ###

Overrides: –

### Klarna Checkout Request Log ###

No KCO errors: 

### Action Scheduler ###

Complete: 2?404
Oldest: 2022-02-13 20:47:57 +0200
Newest: 2022-03-15 23:49:12 +0200

Failed: 2
Oldest: 2022-01-09 16:58:02 +0200
Newest: 2022-01-27 18:45:13 +0200

Pending: 1
Oldest: 2022-03-22 13:33:41 +0200
Newest: 2022-03-22 13:33:41 +0200

### Status report information ###

Generated at: 2022-03-16 01:08:07 +02:00

Error report:

2022-02-13T03:21:33+00:00 CRITICAL Allowed memory size of 134217728 bytes exhausted (tried to allocate 135168 bytes) t?ss? D:\vhosts\smedlunds.com\httpdocs\wp-content\plugins\elementor-pro\modules\theme-builder\documents\theme-document.php rivill? 165

2022-02-13T20:06:17+00:00 CRITICAL Allowed memory size of 134217728 bytes exhausted (tried to allocate 360448 bytes) i D:\vhosts\smedlunds.com\httpdocs\wp-content\plugins\sitepress-multilingual-cms\vendor\composer\ClassLoader.php p? rad 444

Hi,

I’m gonna set up a staging site for the webshop. I’ll have it up and runnin later today. I noticed that in the Woocommerce changelog it said:

“Product attributes lookup table – Added two database indices to the product attributes lookup table, these are intended to improve the performance of the table querying when there’s a lot of products and attributes.”

So I think we can be quite sure that this is what causes the problem. It’s a bug.

Actually the problem isn’t solved ?? Recreating the attribute table did solve the problem yesterday, but apparently it came back today. So the same problem came back. Now, after recreating the table again, it’s temporarily okay, but I’m guessing it will come back later today or tomorrow..

This has to be a bug withing woocommerce right?

Thanx alot madmax, I read your post and found the solution. I just needed to regenerate the product attributes lookup table. I didn’t actually try to disable it though. But after regenerating it, it started working. Is there any benefit to disabling it? Doesn’t that break anything?

Hello Maykato,

I tested this, but it didn’t change anything. As you can see here, the sidebar is empty, even though there should be several “Filter by attribute” widgets there.

https://smedlunds.com/produkt-kategori/ringar/

(The widgets are there, but since they don’t reconize any products belonging to a specific attribute, they aren’t showing).

Hi. I searched the WPML forums and it seems other people have had the same problem. I tried this solution:

Please go to WPML -> Languages -> Language filtering for AJAX operations and enable the option for “Store a language cookie to support language filtering for AJAX”.

It seems to maybe have solved the problem. I’m not getting the problem on my iPad anymore atleast.

Thank you very much, it worked! Strangely enough I had already used that exact code, but then it didn’t work. Maybe it was because I hadn’t emptied the cache, but then again other codes did take effect directly even though I hadn’t emptied it. I also put the code a bit higher up among the other codes. I don’t know if the order of the codes matter, but anyways, it seems to work now, so thanks!

Hey JNash,

You were right about the odd page. Now I see it too. The strange thing is though, that I just deleted the domain account from WHM, like completely removed all the files and everything. And then when I typed in my adress, I got to that strange page. How is that even possible?

I don’t use any caching plugin at the moment, so it shouldn’t be that. And I haven’t gotten any A1 cabins site when accessing my site. I can access it, but I have to accept to proceed to an “unsecure site”. I also tried the sucuri check and tested some other sites of mine that are working normally, but it said the same thing, that it can’t reach the sites. So it seems it’s not the sites, but the sucuri scanner not working properly. At least it doesn’t seem to work on my sites.

I honestly don’t think the site’s hacked, because it does work normally in itself. It’s just the certificate that’s causing problems.

Also, I was in contact with the let’s encrypt support, and they also renewed it. But it still says that it’s expired.

Yeah, I’m doing that, but it seems they don’t really know what the problem is.. It’s just so weird. I mean, yesterday everything was working fine, and the certificate was set to expire in december. Today, it’s like the browser only recognizes the date of the certificate before it was renewed in August. Right now it says that it was issued in april and expired in August. It doesn’t make any sense, that it suddenly started recognizing some old version of the certificate, which was renewed normally in August.

In order to see the issue I was referring to, you would need to use Firefox. I tried it with several desktops and they all present the area to the right of the logo as a clickable area/link. It wouldn’t be a big deal if it wouldn’t affect the navigation, but it does.

This particular issue doesn’t exist in Chrome. In Chrome my only issue is that it doesn’t present a sharp logo. I can see a noticeable difference in logo sharpness in Chrome/Firefox. Can’t you see it?