This thread is resolved. Here is a description of the problem and solution.
Problem:
The client reported multiple PHP warnings and a WordPress database error related to the WPML String Translation plugin and database operations.
Solution:
We identified that the issues are associated with a known bug in WPML version 4.9. We recommend reverting to the previous stable versions of WPML and WPML String Translation until the issue is resolved in the upcoming 4.9.1 release. We have implemented this solution on the staging site, and it appears to resolve the errors. Please verify on your end and contact us if the problem persists or if new issues arise.
Please note that this solution might become outdated or may not apply to your specific situation. We highly recommend checking the related known issues, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the issue persists, please open a new support ticket.
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: ATE
This topic contains 18 replies, has 0 voices.
Last updated by alineY 4 days, 12 hours ago.
Assisted by: Dražen.
| Author | Posts |
|---|---|
| February 18, 2026 at 12:09 pm #17832188 | |
|
alineY |
i have log errors i dont understand what I have to do [error] 33482#33482: *8285937 FastCGI sent in stderr: "s/wpml-string-translation/StringTranslation/Infrastructure/Translation/Query/FindTranslationDetailsQuery.php on line 73; PHP message: PHP Warning: Undefined array key "job_id" in /www/hologrammepariscom_421/public/wp-content/plugins/wpml-string-translation/StringTranslation/Infrastructure/Translation/Query/FindTranslationDetailsQuery.php on line 73; PHP message: PHP Warning: Undefined array key "automatic" in /www/hologrammepariscom_421/public/wp-content/plugins/wpml-string-translation/StringTranslation/Infrastructure/Translation/Query/FindTranslationDetailsQuery.php on line 73; PHP message: PHP Warning: Undefined array key "editor" in /www/hologrammepariscom_421/public/wp-content/plugins/wpml-string-translation/StringTranslation/Infrastructure/Translation/Query/FindTranslationDetailsQuery.php on line 76; PHP message: PHP Warning: Undefined array key "translation_service" in /www/hologrammepariscom_421/public/wp-content/plugins/wpml-string-translation/StringTranslation/Infrastructure/Translation/Query/FindTranslationDetailsQuery.php on line 76; PHP message: PHP Warning: Undefined array key "review_status" in /www/hologrammepariscom_421/public/wp-content/plugins/wpml-string-translation/StringTranslation/Infrastructure/Translation/Query/FindTranslationDetailsQuery.php on line 76; PHP message: PHP Warning: Undefined array key "translator_id" in /www/hologrammepariscom_421/public/wp-content/plugins/wpml-string-translation/StringTranslation/Infrastructure/Translation/Query/FindTranslationDetailsQuery.php on line 73; PHP message: PHP Warning: Undefined array key "editor_job_id" in /www/hologrammepariscom_421/public/wp-content/plugins/wpml-string-translation/StringTranslation/Infrastructure/Translation/Query/FindTranslationDetailsQuery.php on line 73; PHP message: PHP Warning: Undefined array key "job_id" in /www/hologrammepariscom_421/public/wp-content/plugins/wpml-string-translation/StringTranslation/Infrastructure/Translation/Query/Fi [error] 33480#33480: *8281648 FastCGI sent in stderr: "PHP message: WordPress database error Duplicate entry '7854504-nl' for key 'trid_lang' for query INSERT INTO `33n_icl_translations` (`element_type`, `language_code`, `source_language_code`, `trid`, `element_id`) VALUES ('post_attachment', 'nl', 'fr', '7854504', '788615') made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPMLTMATERESTPublicReceive->receive_ate_job, WPMLFPJust->chain, WPMLFPFns::WPMLFP{closure}, call_user_func_array, WPMLFP{closure}, call_user_func_array, WPMLFPFns::WPMLFP{closure}, WPMLFPJust->ap, WPMLFPJust->map, WPMLFP{closure}, call_user_func_array, WPMLTMAPIATE->applyTranslation, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, do_action('wpml_pro_translation_completed'), WP_Hook->do_action, WP_H" while reading response header from upstream, client: 13.223.91.143, server: hologrammeparis.com, request: "GET /fr/wp-json/wpml/tm/v1/ate/jobs/receive/91593 HTTP/2.0", upstream: "hidden link;, host: "hologrammeparis.com:29034" |
| February 18, 2026 at 12:21 pm #17832224 | |
|
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, here is ticket please let me know how it goes. Regards, |
| February 19, 2026 at 4:28 pm #17836726 | |
|
alineY |
I’m still experiencing recurring WPML database errors and would like your help diagnosing and fixing the root cause. Environment WordPress + WooCommerce (multilingual) Plugins involved: WPML Multilingual CMS, String Translation, WooCommerce Multilingual (and WPML Translation Management / ATE features are enabled/used) PHP-FPM 8.3 (server logs show FastCGI stderr) Database: MariaDB/MySQL Site is hosted on Kinsta Main errors seen in logs (examples) Missing WPML table WordPress database error Table '...wp_icl_translate_job' doesn't exist for query SELECT MAX(job_id) FROM wp_icl_translate_job; GET /fr/wp-json/wpml/v1/credits (from WPML Translation Management dashboard) Duplicate key errors (unique constraints) Duplicate entry '7855329-en' for key 'trid_lang' for queries inserting into *_icl_translations with element_type = 'post_attachment' (often triggered when saving WooCommerce variations / media sync) Duplicate entry '398026' for key 'translation_id' for queries inserting into *_icl_translation_status Related PHP warnings PHP Warning: Undefined array key "job_id" / "automatic" / "editor" / "translation_service" / "review_status" / "translator_id" / "editor_job_id" Impact WPML admin screens (TM/ATE credits) generate DB errors Saving products/variations can trigger repeated duplicate-entry DB errors Logs are flooded and I’m worried about data integrity in WPML tables |
| February 19, 2026 at 4:30 pm #17836730 | |
|
alineY |
i have performed another WPML translations and have additionnal errors: |
| February 20, 2026 at 6:48 am #17837513 | |
|
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, Thank you. 1) Could you please share the exact steps to reproduce the issue on your end? That will help me better understand and investigate it. 2) Please create a staging site (you can use the WP Staging plugin) and provide wp-admin access so I can check further. I may need to temporarily disable some plugins or switch the theme during troubleshooting. Looking forward to your reply. Drazen |
| February 20, 2026 at 11:59 am #17838172 | |
|
alineY |
I just click on Translations to launch automatic translations of my products. The errors appear immediately , and more errors appear after I finish the translations process |
| February 20, 2026 at 12:03 pm #17838181 | |
|
alineY |
I have a staging website but I cant share privately anymore can you reply so I can change my answers to private |
| February 20, 2026 at 12:36 pm #17838375 | |
|
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hi, sure, please share the access details of your website, so I can log in and take a look. I’m enabling a private message for the following reply. We have strict policies regarding privacy and access to your information. Please see: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/ - Please backup the site files and database before providing us access. Thanks, |
| February 20, 2026 at 1:39 pm #17838547 | |
|
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, thanks for getting back. I checked your staging site and tried visiting a few pages, updating products, and re-translating products, but I still can’t reproduce any of the errors you mentioned. Could you please review the staging site again, try to reproduce the issue, and then share exact step-by-step instructions so I can see one example of the problem (what page/product to open, what action to take, and what error you see). Once I can reproduce it, I’ll be able to investigate and proceed further. Note: I installed a debug plugin, so you can quickly check the logs from the top admin bar under “Debug quick look”. Regards, |
| February 20, 2026 at 1:57 pm #17838555 | |
|
alineY |
here are the logs from my server side after your tests: 2026.02.20. 13:10:30 this is from your debug [20-Feb-2026 13:56:15 UTC] WordPress database error Table 'hologrammepariscom.wp_icl_translate_job' doesn't exist for query SELECT MAX(job_id) FROM wp_icl_translate_job; made by require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WPML\UserInterface\Web\Infrastructure\WordPress\CompositionRoot\Config\Api->WPML\UserInterface\Web\Infrastructure\WordPress\CompositionRoot\Config\{closure}, WPML\UserInterface\Web\Infrastructure\CompositionRoot\Config\EndpointLoader->handle, WPML\UserInterface\Web\Core\Component\Dashboard\Application\Endpoint\GetCredits\GetCreditsController->handle, WPML\Core\Component\ATE\Application\Service\CreditsService->getCreditsInProgress, WPML\Core\Component\ATE\Domain\Credits\CreditsInProgress->getCount, WPML\Infrastructure\WordPress\Component\ATE\Domain\Credits\Repository\CreditsInProgressRepository->getCreditsInProgressCount$ i ve just clicked on the translation dashboard |
| February 23, 2026 at 6:23 am #17841637 | |
|
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, thanks for getting back to me. I tried to access the site and reproduce what you reported, but while enabling/disabling WPML plugins it seems something caused an issue and now I can no longer access wp-admin it returns a server 500 error. I also tried disabling WPML via FTP, but it did not make much difference, so I am not sure if the FTP access is connected to this staging site. Could you please check and restore the staging site? Once it is accessible again, I will take a copy of the website and continue debugging locally. This will make it easier to avoid the issues above and allow me to review the logs more effectively. Regards, |
| February 23, 2026 at 10:14 am #17842230 | |
|
alineY |
Hello I made a mistake and I gave you my live FTP website credentials with my STAGING wpadmin website, can you confirm you have reverted any modifications please also allow me to send you the new credentials for staging |
| February 23, 2026 at 10:17 am #17842237 | |
|
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, I have only tried to disable WPML plugin, you can check if WPML is activated on your live website and if not activate it. 1) Sure, I will enable private reply. 2) Please confirm it is okay for me to take a copy of your staging website so I can check further locally. Regards, |
| February 23, 2026 at 11:06 am #17842445 | |
|
alineY |
how did you deactivate WPML using FTP? I cant find the files you modified to revert them |
| February 23, 2026 at 11:48 am #17842785 | |
|
Dražen Supporter
Languages: English (English ) Timezone: Europe/Zagreb (GMT+01:00) |
Hello, I did not make any changes to your files. I only temporarily renamed the WPML folder (by adding “1” at the end) and then restored it to its original name. 1) Regarding your website, my current access is quite limited, so there is not much I can check or troubleshoot directly. I also attempted to create a backup/package, but it seems the plugins we normally use (Duplicator, All-in-One Migration) are blocked by your hosting environment. Most errors are also not being recorded in the debug.log, which makes deeper investigation difficult. Additionally, I do not have database access to review the tables or verify whether any indexes are missing. If you have a developer available, they can compare your database tables and indexes against our documentation here: 2) Alternatively, you can provide us with a backup of your website (ZIP files excluding images) together with a database export, so we can deploy it locally and investigate further. At the moment, based on what I can see, it is very likely that some WPML database tables or indexes are corrupted, but unfortunately I cannot continue debugging or attempt fixes with the current level of access. Please let me know. Regards, |
