I hope this message finds you well. I'm writing to urgently seek assistance regarding a critical issue I'm facing with the WPML plugin on my website. I have already attempted several troubleshooting steps to resolve the problem, but unfortunately, none of them have been successful.
Issue Description:
I'm encountering a fatal error on my website related to the WPML plugin. The error message is as follows:
Fatal error: Uncaught InvalidArgumentException: No translation entry found for query: s:42:" element_id = %d AND element_type LIKE %s ";a:2:{i:0;s:3:"353";i:1;s:5:"post%";} in /var/www/html/wp-content/plugins/sitepress-multilingual-cms/classes/records/class-wpml-tm-icl-translations.php:193
Steps Taken So Far:
- Verified that WPML is up to date.
- Deactivated and reactivated WPML.
- Cleared cache and tried again.
- Checked for database corruption.
- Verified URL settings in WordPress dashboard.
- Checked database table wp_icl_translations for inconsistencies.
However, none of these steps have resolved the issue. The error persists and is causing a major disruption to the functionality of my website.
Importance:
This issue is of utmost importance to me, as my website heavily relies on the proper functioning of the WPML plugin for multilingual support. The error is impacting user experience and could potentially lead to loss of visitors and business.
I kindly request your urgent attention to this matter. I have invested a considerable amount of time and effort into building my website, and I'm eager to have it functioning smoothly once again.
I would greatly appreciate your assistance in identifying the root cause of this error and providing a solution. Please let me know if there are any specific logs or information you need from my end to further diagnose the issue.
Thank you very much for your prompt support. I look forward to your response.
Hello There,
Thanks for contacting WPML Support. I will try my best to assist you in this matter.
This kind of fatal error most of the time happens due to a corrupted database or a migration that wasn't completed properly. Based on one of your screenshots, I noticed that the `translation_id` for the "post_page" element[Element_id: 353] in the "_icl_translations" table is set to '0' [ Screenshot: hidden link ]. This appears to be the primary source of the problem.
Please try the following steps and check if that helps to solve the Fatal error:
- Take a full backup of the site including the database prior to proceeding.
- Access your site's database through any database management tool.
- Navigate to the "icl_translations" table. ( Do note, the table prefix in your database may differ; ensure you're using the correct prefix. If it's not "wp", adjust accordingly. )
- Execute the following SQL query:
SELECT * FROM `wp_icl_translations` WHERE `element_id`= 353 AND `element_type` LIKE 'post%'
- Check the records. If any record displays a "translation_id" of '0', please delete that specific record.
I hope the issue will be solved after deleting the corrupted records. Additionally, please also make sure that the indexes for the column are set correctly. You can check the documentation below to learn more about the default database structure of WPML: https://wpml.org/documentation/support/wpml-tables/
Let me know the update. I will be happy to help if you need further assistance in this matter.
Hi Prosenjit,
i'm facing a critical issue on my website that I hope you can help me with. After attempting to resolve a translation-related problem, I deleted some entries with translation_id 0 from the icl_translations table as suggested. However, this action led to a broken frontend with a 404 error. It seems that these entries might have been more important than I initially thought.
I've done my best to follow the steps and advice provided, but I'm stuck with this problem. I believe there might be a connection between the deleted entries and the frontend issue.
I kindly ask if you could take a look at my website's situation from your end. I would be willing to provide you temporary access to my WordPress admin area and database if needed. This would allow you to examine the problem firsthand and guide me toward a solution that won't disrupt the functionality of my website.
Your assistance is greatly appreciated, and I'm looking forward to your guidance on resolving this issue.
Hello There,
Thanks for trying out the suggestions.
I'm hoping that the Fatal error issue has been resolved after deleting the entries. Now, if you can't access certain posts in the frontend, please follow the steps mentioned below and check if that helps to solve the issue.
- Please go to "WPML > Support > Troubleshooting" section.
- Click on the buttons mentioned in this screenshot: hidden link [Ensure you follow the sequence mentioned in the screenshot correctly]
- Clear the caches from the caching plugin that you're using and check again.
But, if the issue persists even after that, a closer inspection will be required to understand the root cause. 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.
You will find the needed fields for this below the comment area when you log in to leave your next reply. The information you will enter is private which means only you and I can see and have access to it.
Maybe I'll need to replicate your site locally. For this, I’ll need to temporarily install a plugin called “Duplicator” or "All in One WP Migration" on your site. This will allow me to create a copy of your site and your content. Once the problem is resolved I will delete the local site. Let me know if this is ok with you.
IMPORTANT
-Please make a backup of site files and database before providing us access.
-If you do not see the wp-admin/FTP fields this means your post & website login details will be made PUBLIC. DO NOT post your website details unless you see the required wp-admin/FTP fields. If you do not, please ask me to enable the private box. The private box looks like this: hidden link
