Background of the issue:
I am working on a site under development and encountering an issue with WPML. I am using the Woodmart theme.
Symptoms:
There is a problem with the String Translation table in your site. This problem is not causing a problem running the site right now, but can become a critical issue in the future. WPML support team knows how to fix it. Also, the translated strings do not show in frontend in Woodmart theme.
Questions:
Could you help me to fix the issue with the String Translation table?
Why are the translated strings not showing in the frontend in the Woodmart theme?
That error message usually indicates that a column or index is missing from the icl_strings table in your database.
I will need to closely examine your website. Therefore, I will require temporary access (WP-Admin and FTP) to a test site where the problem has been replicated, if possible. This will enable me to provide better assistance and determine if any configurations need to be modified.
Please note that it is important to have a backup for security purposes and to prevent any potential data loss. You can use the UpdraftPlus plugin (https://wordpress.org/plugins/updraftplus/) to fulfill your backup requirements.
Your upcoming reply will be treated with confidentiality and will only be visible to you and me.
✙ To resolve the issue, I may need your consent to deactivate and reactivate plugins and the theme, as well as make configuration changes on the site if necessary. This emphasizes the significance of having a backup.
I am developing the client's website locally, and as it is a e-commerce website I cannot provide full access to you! It contains Orders and private data.
However I am a php WordPress and MySQL developer and with your assistance we can manage to fix the issue remotely. I suggest you to provide me steps to configure or fix the issue. I understand that it is a bit of hard work for you, but please understand my point...
You can resolve this issue on your own by following these steps: First, make sure to back up your site. Then, set up a local test site, install WPML and String Translation, and check the local site's database.
Look for the icl_strings table in the database and compare its columns or indexes with those on the production site. If you find any discrepancies or missing elements, correct them and let me know if this resolves the issue.
I can see differences(missing columns and indexes) in your attached screenshot. Have you corrected it?
Once you corrected it, check your Website backend to see if this notification "There is a problem with the String Translation table in your site." still shows up.
Please make sure to back up the website before making any changes, as I previously advised. I'm not sure what is causing the error you're encountering. Also, if you're using the Advanced Translation Editor for automatic translations, your translations should be saved in the translation memory. You can learn more about this process https://wpml.org/documentation/translating-your-contents/how-wpml-keeps-track-of-your-translations/
This means that if you retranslate the same content, you won’t incur additional translation credits. However, we do not offer refunds for charged credits since we have already paid for the translations on our end.
Unfortunately, we cannot provide an SQL script without confirming the issue. Could you provide a copy of the site? You can follow the instructions https://wpml.org/faq/provide-supporters-copy-site/ to remove your client’s data and payment information. Once we have the copy, we’ll examine it and advise you on how to resolve the issue.
We might be looking in the wrong direction. But it would be best if you could provide a copy of the site and also, tell me which string cannot be translated.
I can provide the site copy in .wpress file format, you can use All in One WP Migrate plugin to restore the copy into bare WordPress, is it Okay? Also this link does not contain any relevant information, it redirects to other page: https://wpml.org/faq/provide-supporters-copy-site/
