Languages: English (English )Portuguese (Brazil) (Português )
Timezone: America/Sao_Paulo (GMT-03:00)
Hi there,
I checked it and our 2nd tier team has detected one error within the site DB that might be causing the issue.
While we were in the process of installing the fake translation engine to proceed with the tests without spending credits we came across the following error:
WordPress database error Illegal mix of collations
It seems that some of your database tables have different collations, which may cause issues while executing certain SQL queries. It is recommended that all the database tables have the same collation.
You need to ensure that all the database tables are changed to a unicode-aware collation like "utf8mb4_unicode_ci" or "utf8mb4_unicode_520_ci".
For WPML tables, you can try running the option "Fix WPML table collation" under WPML → Support → Troubleshooting:
But for the WordPress and other plugins tables, if you need further assistance, you can ask your hosting provider help to change the DB and tables collation so they're uniform.
Languages: English (English )Portuguese (Brazil) (Português )
Timezone: America/Sao_Paulo (GMT-03:00)
Hello,
Thank you for your efforts, and I apologize for the ongoing back and forth.
It seems there are still issues with the development site, and we're noticing differences between it and the live site. For instance, attempting to access the language edit page to perform the necessary mapping for automatic translation results in a fatal error.
Could you copy the live site onto the development environment, overriding it? If there are any changes on the development site that haven’t been pushed live, would it be possible to create a new staging site using the live site as a model?
The problem is coming on your side, it's a know problem if you type the error on your forum :
Please find the answer of the support agent
Hi,
Thank you for providing the access and confirmations. I was able to see and fix the problem.
Actually, the problem was coming due to "Site is Moved or Copied" message on top of the page. Since it is a staging site, I selected "This is a copy of my original site" and saved.
After that page reloaded itself and most of the languages had their mappings, except the custom ones. So I simply saved and it went fine, means no fatal error.
See following guides for details:
So I think that your dev missed a step with this message and it's the cause of the problem 😉
Languages: English (English )Portuguese (Brazil) (Português )
Timezone: America/Sao_Paulo (GMT-03:00)
Hello Nicolas,
Even the option to unregister and register WPML is unresponsive on the dev site. I tried using Duplicator to make a copy of the site, and while I was able to complete the process on the live site, I can never reach the final step on the dev site. Additionally, there are several pages inside the wp-admin (both WPML and non-WPML related) that throw console errors.
There also seems to be an issue with AJAX. For example, when accessing hidden link, I get the error: "Il y a eu une erreur critique sur ce site. En apprendre plus sur le débogage de WordPress."
In a healthy WordPress site, this usually returns a "0," as it currently does on the live site at hidden link, where you can see just a "0" on the screen.
This, along with the other issues our 2nd tier support reported earlier (such as the collation issue), are not happening on the live site. Therefore, making a fresh copy of the live site onto the dev environment might fix all these issues in one step.
Languages: English (English )Portuguese (Brazil) (Português )
Timezone: America/Sao_Paulo (GMT-03:00)
It is true.
Indeed, now I'm not able to reproduce those errors any longer, I was able to save my changes in the language screen and the language mapping is working as expected.
Thank you for taking care of it.
I'll follow up with the 2nd tier team and get back to you as soon as possible.
Languages: English (English )Portuguese (Brazil) (Português )
Timezone: America/Sao_Paulo (GMT-03:00)
Hi Nicolas,
We attempted to translate a high amount of content in the development site.
We successfully sent it for translation without being able to reproduce the issue once.
Can you please confirm that the issue is fixed on the development site and apply the same fixe to the live site, especially with the DB/tables collation?
My colleague Mateus is currently unavailable, I will take care of your case in the meantime,
Could you please confirm if the last screenshots you sent are from the Dev site and not the live site?
Please retry the test again and use Loom or any other video recording app to record the steps you followed, because we are currently getting different results.
