siutek

Ok, thanks,
I think this solves my problem ??

The latest version of wordpress has made some changes to the translations. Many sites now have problems because of it.
The question is whether the authors of the Loco Translate plugin can somehow get around this, or do you have to wait for a wordpress fix?

Can anyone of you share your experience in optimizing large tables using partitioning? Does it generally make sense for WordPress and WooCommerce?

Is it capable of increasing the performance of a database that is 5.4 GB and has around 40 million records, including 20 million in wp_postmeta?

Status:

<br>### WordPress Environment ###<br><br>WordPress address (URL): https://xxxxxxxx<br>Site address (URL): https://xxxxxxx<br>WC Version: 9.3.3<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.8.1<br>Log Directory Writable: ?<br>WP Version: 6.6.2<br>WP Multisite: –<br>WP Memory Limit: 768 MB<br>WP Debug Mode: ?<br>WP Cron: ?<br>Language: en_GB<br>External object cache: ?<br><br>### Server Environment ###<br><br>Server Info: nginx/1.21.4<br>PHP Version: 8.1.27<br>PHP Post Max Size: 256 MB<br>PHP Time Limit: 300<br>PHP Max Input Vars: 20000<br>cURL Version: 7.81.0<br>OpenSSL/3.0.2<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.11.8-MariaDB-ubu2204<br>Max Upload Size: 256 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ?<br><br>### Database ###<br><br>WC Database Version: 8.4.0<br>WC Database Prefix: wp_<br>Total Database Size: 40.27MB<br>Database Data Size: 23.35MB<br>Database Index Size: 16.92MB<br>wp_woocommerce_sessions: Data: 0.48MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.19MB + Index: 0.08MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 2.52MB + Index: 1.92MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_acfw_store_credits: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 0.34MB + Index: 0.39MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 0.27MB + Index: 0.23MB + Engine InnoDB<br>wp_cky_banners: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_cky_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cky_cookie_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 1.52MB + Index: 0.66MB + Engine InnoDB<br>wp_feedmanager_channel: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_feedmanager_country: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_feedmanager_feed_status: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_feedmanager_field_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_feedmanager_product_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_feedmanager_product_feedmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_feedmanager_source: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_litespeed_img_optming: Data: 0.05MB + Index: 0.05MB + Engine InnoDB<br>wp_litespeed_url: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_litespeed_url_file: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_options: Data: 4.11MB + Index: 0.09MB + Engine InnoDB<br>wp_postmeta: Data: 7.52MB + Index: 10.03MB + Engine InnoDB<br>wp_posts: Data: 2.52MB + Index: 0.75MB + Engine InnoDB<br>wp_pys_stat_landing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pys_stat_order: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>wp_pys_stat_product_order: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>wp_pys_stat_traffic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pys_stat_utm_campaing: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pys_stat_utm_content: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pys_stat_utm_medium: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pys_stat_utm_source: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pys_stat_utm_term: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.09MB + Index: 0.06MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 1.52MB + Index: 0.64MB + Engine InnoDB<br>wp_users: Data: 0.08MB + Index: 0.05MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.11MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 0.11MB + Index: 0.16MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.11MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmm_subscribers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yoast_indexable: Data: 0.06MB + Index: 0.09MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>zzz_RtnetExportedOrders: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>zzz_RtnetSubsyncSecret: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>zzz_RtnetTasks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br><br>### Post Type Counts ###<br><br>attachment: 110<br>customize_changeset: 11<br>nav_menu_item: 12<br>page: 22<br>post: 25<br>product: 4<br>product_variation: 3<br>revision: 65<br>sh4_calendar: 4<br>sh4_employee: 3<br>sh4_shifttype: 5<br>shop_coupon: 3112<br>shop_order: 768<br>shop_order_refund: 2<br>slider: 6<br>sp_easy_accordion: 2<br>tablepress_table: 2<br>wp_global_styles: 1<br>wpcf7_contact_form: 1<br><br>### Security ###<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ?<br><br>### Active Plugins (25) ###<br><br>Advanced Coupons for WooCommerce Free: by Rymera Web Co – 4.6.3.1<br>Contact Form 7: by Takayuki Miyoshi – 5.9.8<br>WooCommerce Coupon Generator: by Jeroen Sormani – 1.2.0<br>Dodatki Primabiotic.co.uk: by Patryk Siuta - nikograf – 1.0.0<br>GTM4WP - A Google Tag Manager (GTM) plugin for WordPress: by Thomas Geiger – 1.20.2<br>Easy Accordion: by ShapedPlugin LLC – 2.3.9<br>LiteSpeed Cache: by LiteSpeed Technologies – 6.5.1<br>Loco Translate: by Tim Whitlock – 2.6.11<br>Image optimization service by Optimole: by Optimole – 3.13.7<br>Otter – Page Builder Blocks & Extensions for Gutenberg: by ThemeIsle – 3.0.3<br>PixelYourSite PRO: by PixelYourSite – 10.0.1.1<br>Payment Plugins for PayPal WooCommerce: by Payment Plugins<br>[email protected] – 1.0.52<br><br>Server IP & Memory Usage Display: by Apasionados<br>Apasionados del Marketing – 2.1.0<br><br>TablePress: by Tobias B?thge – 2.4.2<br>Trustpilot-reviews: by Trustpilot – 2.5.925<br>Variation Price Display Range for WooCommerce: by WPXtension – 1.3.15<br>WebP Express: by Bj?rn Rosell – 0.25.9<br>Ajax add to cart for WooCommerce: by QuadLayers – 2.4.0<br>Payment Plugins for Stripe WooCommerce: by Payment Plugins<br>[email protected] – 3.3.75<br><br>edrone Integration: by Maciej Mendrela – 1.0.12<br>WooCommerce: by Automattic – 9.3.3<br>Yoast SEO: by Zespó? Yoast – 23.5<br>WP Mail SMTP: by WP Mail SMTP – 4.1.1<br>LightStart - Maintenance Mode, Coming Soon and Landing Page Builder: by Themeisle – 2.6.12<br>WP Product Feed Manager: by WP Marketing Robot – 2.10.0<br><br>### Inactive Plugins (1) ###<br><br>CookieYes | GDPR Cookie Consent: by CookieYes – 3.2.6<br><br>### Dropin Plugins () ###<br><br>object-cache.php: LiteSpeed Cache - Object Cache (Drop-in)<br><br>### Settings ###<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: GBP (￡)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: –<br><br>### Logging ###<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 2 MB<br><br>### WC Pages ###<br><br>Shop base: #69 - /shop/<br>Cart: #70 - /cart/ -  Contains the [woocommerce_cart] shortcode<br>Checkout: #71 - /checkout/ -  Contains the [woocommerce_checkout] shortcode<br>My account: #37 - /my-account/<br>Terms and conditions: ? Page visibility should be public<br><br>### Theme ###<br><br>Name: Niko-theme<br>Version: 1.0.08032024.06<br>Author URL: https://www.nikoraf.pl<br>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<br>WooCommerce Support: ?<br><br>### Templates ###<br><br>Overrides: niko-theme/woocommerce/archive-product.php version 3.4.0 is out of date. The core version is 8.6.0<br>niko-theme/woocommerce/cart/cart-shipping.php version 7.3.0 is out of date. The core version is 8.8.0<br>niko-theme/woocommerce/cart/cart.php<br>niko-theme/woocommerce/checkout/form-billing.php<br>niko-theme/woocommerce/checkout/form-checkout.php<br>niko-theme/woocommerce/checkout/form-coupon.php<br>niko-theme/woocommerce/checkout/review-order.php<br>niko-theme/woocommerce/content-single-product.php<br>niko-theme/woocommerce/loop/add-to-cart.php version 3.3.0 is out of date. The core version is 9.2.0<br>niko-theme/woocommerce/notices/error.php version 3.9.0 is out of date. The core version is 8.6.0<br>niko-theme/woocommerce/notices/notice.php version 3.9.0 is out of date. The core version is 8.6.0<br>niko-theme/woocommerce/notices/success.php version 3.9.0 is out of date. The core version is 8.6.0<br>niko-theme/woocommerce/single-product/add-to-cart/variation.php version 2.5.0 is out of date. The core version is 9.3.0<br>niko-theme/woocommerce/single-product/tabs/tabs.php<br>niko-theme/woocommerce/single-product-reviews.php<br>niko-theme/woocommerce/single-product.php<br><br>Outdated Templates: ?<br>					<br>					<br>						Learn how to update					 |<br>					<br>						<br>					<br>					<br>						Clear system status theme info cache<br><br>### Admin ###<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br><br>Disabled Features: experimental-blocks<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>blueprint<br>reactify-classic-payments-settings<br><br>Daily Cron: ? Next scheduled: 2024-03-20 13:32:07 +00:00<br>Options: ?<br>Notes: 110<br>Onboarding: completed<br><br>### Action Scheduler ###<br><br>Complete: 1,067<br>Oldest: 2024-02-18 08:50:02 +0000<br>Newest: 2024-03-19 16:32:49 +0000<br><br>Pending: 34<br>Oldest: 2024-03-20 09:06:08 +0000<br>Newest: 2024-10-07 09:03:48 +0100<br><br>Failed: 5<br>Oldest: 2023-10-23 08:56:27 +0100<br>Newest: 2024-03-15 06:29:30 +0000<br><br><br>### Status report information ###<br><br>Generated at: 2024-10-01 12:02:20 +01:00<br>

• This reply was modified 1 month, 3 weeks ago by siutek.

The checkout and shopping cart pages are excluded from the cache rules. They cannot be cached.

I changed the theme to Storefront – it didn’t do anything.
I disabled all plugins except WC and Stripe (and LiteSpeed Cache). The card fields appeared in the checkout view. I started enabling one plugin at a time checking which one was causing the problem?

I did not find the cause. I switched all plugins back on and the card payment fields show up correctly.

Previously, when this option was not working properly, I noticed that the problem occurred when the user was logged in. In the Incognito window everything was fine.

Everything can be considered to be working as it should, but the cause has not been found and there is a risk that the error will return.

Thanks, that explains everything ??

I apologize for the silence,
It is only now that I can revisit the topic.

It seems that it is your plugin, in the code unambiguously suggests it.

Checkout page:

Thx ??

Hi @nikhilgadhiya,

I can provide you with the product URL, but I had to disable your plugin. I couldn’t let customers see an incomplete gallery. Do you still want the URL? I have a test page where the variant photo is also not working, provide an email address then I will share the address to it.

Indeed, it was the cookie that caused the error. After removing it, it works better.
Please give me some more hints on how I can change the loading order of the CookieYes banner so that it lands under the GTM code (I’m using the GTM4WP plugin). Currently the banner loads above the GTM code.

• This reply was modified 8 months, 3 weeks ago by siutek.

thx @nikhilgadhiya ??

OK, I found it.
I added a pattern for one of the cookies (ct.pinterest.com), in the waterfall I can see that the cookie has been blocked (on the right), but the browser says that it has saved nevertheless (on the left)

Script URL Pattern??
What do you mean more specifically?

All I did was to assign the cookies (their IDs, domains, descriptions and shelf life) to the appropriate categories

Yes, I noticed.
That’s why I marked the thread as resolved and reported it with a request for removal.