Background of the issue:
I am trying to translate a Gravity Form by creating a translation job on the Translation Management page. This process works, and I can translate the form, which displays correctly in both Danish and English. However, I encounter an issue when opening the 'gravity forms' section on the translation management page. This issue occurs on both my development site (hidden link) and live site (hidden link). The error log shows a WordPress database error related to SQL syntax when attempting to display the translation status of the forms.
Symptoms:
I receive a WordPress database error in the error_log file: 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \') LEFT JOIN wpsav_icl_translation_status ts ON ts.translation_id =\' at line 20'. This error occurs when I open the 'gravity forms' section on the translation management page. The translation management shows the forms as not translated (indicated by a red circle), even though they are translated.
Questions:
Why am I receiving a WordPress database error when opening the 'gravity forms' section on the translation management page?
Why does the translation management show the forms as not translated despite being translated?
Welcome to the WPML support forum. I will do my best to assist you in resolving the issue.
Please try the following troubleshooting steps after a full site backup {mandatory} and make sure the issue exists or not.
1) Go to WPML >> Support page, click on the Troubleshooting link (blue link in the middle of the page)
2) On the Troubleshooting page, please click on the following options of the *Clean up* section. Wait for confirmation of processing after each one.
- Clear the cache in WPML
- Remove ghost entries from the translation tables
- Fix element_type collation
- Set language information
- Fix WPML tables collation
- Assign translation status to duplicated content
- Fix terms count
- Fix post type assignment
- Cleanup and optimize string tables
3) Open the Gravity Forms (the one having the issue) for editing
4) Make a minor change to the contents to refresh the translation settings
5) Save the changes
6) Try to translate Gravity Forms again
Thank you for the updates. Please fill in the private details fields (including FTP) after a full site backup. I would like to access the admin area of your site for further checking. Refer to the following links for more details about our private information sharing policies.
Thank you for the details and login information. I can log in to the site. But one question.
The Gravity Forms are not listed in the WPML >> Translation Management dashboard. However, I can see the related translation jobs from Gravity Forms under WPML >> Translation Management >> Translation Jobs, along with a database error message in the dashboard area.
Therefore, I hope you are experiencing the same issues on your live site as well. Please refer to the following screencast and confirm if it matches what you are seeing on your end.
Thank you for the updates. I can now see the forms. In general, creating posts in a secondary language and translating them into the primary language should not cause any issues.
However, have you ever changed the default language of the site (for example, from English to Danish)? This may affect how translations behave.
This requires further testing. So, please grant permission to:
- Deactivate non-WPML plugins
- Switch to the default Twenty Twenty-Five theme on the staging site for further troubleshooting
- Create a copy of the site in case of escalation to our developers
No we haven't changed the default language of the site
Yes I grant permission to:
- Deactivate non-WPML plugins
- Switch to the default Twenty Twenty-Five theme on the staging site for further troubleshooting
- Create a copy of the site in case of escalation to our developers
Thank you for the permission. I performed a few rounds of testing on your staging site, but the issue still exists even after the initial troubleshooting steps.
Interestingly, everything works as expected when I create a new post in English and translate it to Danish. So, it appears that the bug is specifically related to Gravity Forms.
I have made a copy of the site for detailed debugging and escalation to our second-tier team. We will get back to you as soon as possible with further updates. Please wait.
The issue still exists after our initial debugging procedures, so we have escalated the ticket to our second-tier team for further investigation. We will update you as soon as we have more information. Please wait.
We are still working on this bug. The MySQL syntax error was not triggered when we added a third language to the site on our local copy as part of the troubleshooting steps. However, even in a minimal setup, Gravity Forms created in a secondary language are still not listed with their status in the Translation Management dashboard.
We have therefore escalated the ticket to our developers for detailed debugging and fixing. We will update you as soon as we receive their feedback. Please wait.
