Background of the issue:
We have 3 languages on our site: SK (default), EN, DE. We are using a custom post type 'service'. We buy credits for automatic translation (also used pay as you go) and run automatic translation from Slovak to English and German language.
Symptoms:
Even if all English translations were correct, German translations were not. Some ACF fields were not even created (repeater / dynamic fields) for the German language.
Questions:
Can you please help us find the reason why German translation translates only a few fields and others are ignored? Currently using pay as you go service for translations.
Hello, it has been a few days since your last response. Have you found out the reasons why the translations are not being translated correctly or why they are getting stuck? Also, I did not find the attachment you mentioned in your last response. Please let me know the current status. Thank you.
In the Advanced Translation Editor Error Logs screen (hidden link), we could see cURL error 28 (it is from July 9). In the message, there is a list of jobs. We can see that the jobs were delivered to the site using our automatic translation server. Therefore, our suspicion is it was a DB issue. Our second-tier supporter suggested sending one of the jobs to translation again. I sent the service - Ošetrenie proti starnutiu pre mužov. I'm unsure if it fixed the problem. We ask you to try WPML's troubleshooting section. Here are the instructions.
1. Take a backup of the DB of your site.
2. Go to WPML -> Support -> Troubleshooting (link)
3. Once on the troubleshooting screen, press the following buttons and check if it helps. Press each button at a time and wait for the process to complete.
- 'Synchronize posts taxonomies' for 'Services'
- 'Clear the cache in WPML'
- 'Remove ghost entries from the translation tables'
- 'Fix element_type collation'
- 'Fix WPML tables collation'
- 'Synchronize local job ids with ATE jobs'
- 'Synchronize translators and translation managers with ATE'
- 'Assign translation status to duplicated content'
- 'Set language information'
- 'Reset languages' Press this button only if you didn't add a custom language!
- 'Fix terms count'
- 'Fix post type assignment for translations'
- 'Cleanup and optimize string tables'
- 'Clear invalid strings'
*** Please make a backup of your database before using this.***
Then please check if it helps.
If it does not help, please let's get back to the initial problem. Can you please specify one Service translation in German where the problem occurs? (missing translation and problem with ACF fields)
I do everythnig mention above, but nothing works. Ošetrenie proti starnutiu pre mužov service still not translated. I don't think that there is problem with DB - at least because SK -> EN translations works fine. Only SK -> DE not working.
I look at hidden link and yes there is cURL err no 28, but dont know why. This could be the reason why it is not working. Also can I find what data are sending or receiving to/from your server? So I can check if data is sending from your servers correctly.
I check the DB and yes there is problem that your query takes very long time. DB is optimized, but your table wp_icl_translate is approx 700MB which is too big. There must be some problem in plugin why it has so many rows (~2 000 000) - and yes I apply your 3 point from previous answer.
The query which takes long is: SELECT SQL_CALC_FOUND_ROWS DISTINCT(s.id) AS string_id, s.language AS string_language, s.string_package_id, s.context, s.gettext_context, s.name, s.value, s.status AS status, s.translation_priority FROM wp_icl_strings s LEFT JOIN wp_icl_string_packages sp ON sp.ID = s.string_package_id
INNER JOIN wp_icl_translate it ON it.field_data_translated = sp.name WHERE 1 AND it.field_type="original_id" AND TRIM(s.value) <> '' ORDER BY string_id DESC LIMIT 0,100;
Also table wp_icl_translation_status looks like have big size (125 MB).
Hi, and thanks for trying my suggestions and adding further information.
I'm sending this information to our second-tier supporters.
Meanwhile, we want to inspect your site's DB. We suspect that the issue is the same as another issue. You can see the ticket with what we suspect is the same problem here.
Alternatively, we can take a copy of your site and check things on the copy of your site. For this, we need your consent to install a plugin like DUplictor or All-in-One WP Migration.
Please let us know which option you would allow us to proceed with.
In any case, please know that we will be able to get back to you early next week.
About the manipulating with DB - yes you have permission to whether install phpmyadmin extension or to use other plugins like AIO WP Migration / Duplicator.
I installed the WP phpMyAdmin plugin, but then I noticed that all the Services posts are translated into German. For example the Ošetrenie proti starnutiu pre mužov service.
hidden link
Please see the attached screenshot.
I also noticed that in WPML -> Translation Management, nothing is stuck. Please see the attached screenshot.
As far as I can see, the problem is solved now.
Can you please confirm this?
Thanks,
Itamar.
The topic ‘[Closed] Automation translation not translate all fields for German language’ is closed to new replies.
