When I tried to update some products I realized that they are linked to the wrong category language. Which is creating messed up links. See screenshot Ex : hidden link - this is my staging site that is up to date - the category "body parts" and "nostrils" are English.
It also mess up with the variation which is causing some products to not be available to my customers (variations are not appearing or cannot be clicked on). See screenshot.
This is completely random, it does it in random product without reason or without I did anything. I have to check ALL my product regularly to make sure Its correct and re-enter the variations sometimes. This is super annoying and it last since 1 month, since my former host provider has migrated my website to a new server (I dont know what they did exactly).
Thank you for contacting WPML support, I'd be happy to help you with this issue.
Please follow some troubleshooting steps below and see if it helps:
1. Enable a minimal environment:
- Deactivate all plugins except WPML plugins and WooCommerce.
- Switch to a standard theme of WordPress.
2. Go to WPML > Support > Troubleshooting > Click on some buttons:
- [Products, Variations] Synchronize posts taxonomies
- Clear the cache in WPML
- Remove ghost entries from the translation tables
- Fix element_type collation
- Fix WPML tables collation
- Set language information
- Fix terms count
- Fix post type assignment for translations
❌ IMPORTANT: Please backup your database and website before proceeding ❌
You can use this plugin to create the backup: https://wordpress.org/plugins/duplicator/
Hi there ! Thank you. I did everything as you asked and Its seems that the problem isn't there anymore. But it usually comes back after a while. What should I do next ? Thanks !
Glad to hear it works. You can use the troubleshooting steps above to fix the issue if you see this next time.
If you know how to replicate the issue on your site with clear steps, please share the steps and the temporary access (wp-admin and FTP) to your site to take a better look at the issue. It would be better to have a testing site where the issue is replicated. Your next reply is set to private to share the info.
❌ IMPORTANT: Please backup your database and website before proceeding ❌
You can use this plugin to create the backup: https://wordpress.org/plugins/duplicator/
If not, it's really difficult to fix an issue without replicating it to know what's wrong there.
Ok thanks. The first try I did it on the staging site and until now its still work. But how can I reproduce it on my live website ? Do I have to to also enable a minimal environment ? That is complicated to do in a live website....
On your live site, please backup your database and website before proceeding. And you can try step 2 first, if you see the issue persists, try step 1 later.
Or you can move the staging site to the live site because the issue is fixed there.
Ok sorry, my bad, the bug is fully back and its getting very annoying as I am loosing sell because of it. It reappeared as soon as I created new product or modify a product page (and it does it randomly on different products, without any reasons).
Maybe it's a caching issue. Please update WPML plugins to the new version and deactivate Redis Cache, Permatters plugins or caching method on your hosting and try to replicate the issue.
This is definitely not a caching issue, coz it doesn't solve anything to deactivate these plugins. I will try replicate exactly the issue on the staging site and send you credentials with how to replicate so u can see by yourself.
Ok sorry my bad. I have try deactivating each plugin one by one and it seems that the Redis Cache Object is the one making trouble with the languages of the variations. I have deactivated it for now and will see if the issue comes back at some point. Other wise, is there any way to exclude some redis settings to allow it to work and not mess up with the languages variations ?
Ensure you have the new version of WPML 4.6.7, there is an issue with caching and fixed in the new version. Please read more in the changelog https://wpml.org/download/wpml-multilingual-cms/?section=changelog
Also, you can try to add the code below to the file wp-config.php to exclude some groups from caching:
define ( 'WP_REDIS_IGNORED_GROUPS', ['WPML_Cache_Terms_Per_Lang']);
//or this one
define ( 'WP_REDIS_IGNORED_GROUPS', ['counts', 'plugins', 'category_relationships']);
Hi there, I have updated wpm to version 4.6.7 and tried reactivating redis and it still mess up the variations, tags & categories. I have tried to add both lines (one after another), none are working. What can I do next pls ? I am now 100% sure the problem is compatibility between redis and WPML. Thanks
If it does not help, I would like to request temporary access (wp-admin and FTP) to your site to take a better look at the issue. It would be better to have a testing site where the issue is replicated. Your next reply is set to private to share the info.
❌ IMPORTANT: Please backup your database and website before proceeding ❌
You can use this plugin to create the backup: https://wordpress.org/plugins/duplicator/
✙ I would need your permission to de-activate and re-activate Plugins and the Theme to change configurations on the site if needed. This is also a reason the backup is critical.
Look forward to your reply.
Thanks
The topic ‘[Closed] Categories & variations are messed up’ is closed to new replies.