WPML can't load Woocommerce .mo

This thread is resolved. Here is a description of the problem and solution.

Problem:
You are trying to use default WooCommerce translations for your shop, but WPML can't load the default .mo file.
Solution:
1) Go to Dashboard > Updates and load the latest updates for WordPress.
2) Go to WPML > Theme & Plugin Localization and scan the theme and plugins for strings.
Before running these steps on the staging, ensure to fix collation issues and run WPML troubleshooting options to clean up string tables (WPML > Support > troubleshooting).
If these steps do not resolve the issue, it could be due to various factors such as minimum server requirements, server limitations like missing writing permissions, corrupted data on the string tables, corrupted language files, or issues between plugins or the theme.
If you encounter issues on the live site after applying these steps, we recommend opening a new support ticket. Additionally, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins.
If the solution provided here is not relevant or outdated, please contact us for further assistance at WPML support forum.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: Exception

This topic contains 46 replies, has 2 voices.

Last updated by Andreas W. 10 months ago.

Assisted by: Andreas W..

Author	Posts
October 1, 2024 at 6:34 pm #16242466
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	My apologies, I can see now that this is still not the case for all the text domains. I will keep testing.
October 2, 2024 at 11:24 am #16245113
daivyM	OK, waiting for your investigations, then 🙂
October 3, 2024 at 11:54 am #16249567
daivyM	Hi, any update ?
October 4, 2024 at 2:30 am #16252262
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	While investigating this issue, I realized a Collation problem in your database. - The database itself is set to "latin1_swedish_ci" and should also use "utf8mb4_unicode_520_ci". - All tables and affected table rows should use "utf8mb4_unicode_520_ci". I have fixed those issues partially on the local copy of your site. After that, I rescanned the plugins for new strings and it appears to have solved the issue. Would you like me to send you a copy of the partially fixed database?
October 4, 2024 at 7:35 am #16252704
daivyM	What should I do on the production on the live website then ? I would like to access the staging website but it seems you changed the password.
October 4, 2024 at 2:29 pm #16254782
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	No, I did not change the password on the staging site. I took a local copy of the site, fixed all the DB collation issues manually on most of the tables, cleaned up the string tables, then scanned again for new strings and created the custom language files for WPML. I can send you a copy of this database, or you first contact your hosting support team and ask them for assistance in fixing the collation issues inside your database.
October 4, 2024 at 4:06 pm #16255287
daivyM	Hello, All the tables and rows on the staging website now use "utf8mb4_unicode_520_ci". However, I am still not able to use the dialog box to scan string translations. Could you look at it ? Regards
October 4, 2024 at 7:04 pm #16255727
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	You first need to go to Dashboard > Updates > Translations > Download translations to obtain all the default po-files. Then go to WPML > Theme & Plugin Localization and scan the theme and plugins for new strings. Somehow, when trying to scan for new strings my browser after some times shows this error: Out of Memory Could you please give it a try yourself now, and once you completed the scan, please let me know.
October 4, 2024 at 7:32 pm #16255745
daivyM	Same error. I only selected the woocommerce plugin for scanning, but still no update translations for this one. Problem is not resolved 🙁
October 5, 2024 at 3:34 am #16256008
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	I would like to confirm if the collation issues have been solved properly, but I am not allowed to use any plugin to manage the database on your site. Please provide me access to the database and I will be glad to assist you further. The private reply form is enabled again.
October 5, 2024 at 11:22 am #16256407
daivyM	Hello, You mean having access to phpmyadmin ? This will be difficult to give you access to this, but here is a screenshot showing that all the tables and rows on the staging website now use "utf8mb4_unicode_520_ci" : hidden link If you only need to use WordPress, I already gave you the credentials for the admin password. Please tell how I can help.
October 7, 2024 at 11:30 am #16261038
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	You would need to make this adjustment also for the single rows on each table. Is this the case?
October 7, 2024 at 11:39 am #16261056
daivyM	Yes. I used the Operations -> Collation tools for that. See attached picture. If I may make one criticism, I find your support painfully slow. I've had the ticket open since the end of September, and the problem still hasn't been solved.
October 7, 2024 at 2:49 pm #16262357
Andreas W. WPML Supporter since 12/2018 Languages: English (English ) Spanish (Español ) German (Deutsch ) Timezone: America/Lima (GMT-05:00)	I am really sorry for the delay, but this is a very unexpected issue and I have spent a lot of time in investigating it. On your staging, as a test, I removed the custom mo files from /wp-content/languages/wpml. I took a local backup of the folder and trestored it after my test. While the folder was empty, I went to WPML > Support > Troubleshooting and force the dialog to create custom .mo language files and the dialog will not start. The reason for this usually is missing write permission on the folders on the server. Guide: https://wpml.org/faq/cannot-write-mo-files/#:~:text=WPML%20needs%20the%20languages%20folder%20in%20WordPress%20to%20be%20writable
October 7, 2024 at 3:37 pm #16262610
daivyM	I appreciate your dedication and would like to thank you. The WPML folder has the correct permissions (755), but not the .mo files (644). Please check my sreenshots. Should I change .mo permission to 755 ?