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.

This thread is resolved. Here is a description of the problem and solution.

Problem: Can't add or change anything in the translated menu.

Solution: The database collation for the tables "wp_terms" and "wp_term_taxonomy" needed to be updated.

When WPML works on the menus, it uses data from these tables "wp_posts", "wp_icl_translations", "wp_terms" and "wp_term_taxonomy" so at the client database all the (`varchar` and `longtext`) at the "wp_posts" and the "wp_icl_translations" columns are using the "utf8mb4_unicode_520_ci" collation, but his "wp_terms" and "wp_term_taxonomy" are using "utf8mb4_unicode_ci" and this is making an illegal mix of collation issue, so to fix this issue, we had to change the collation for all the columns to be "utf8mb4_unicode_520_ci" instead of "utf8mb4_unicode_ci".

Relevant Documentation: https://wpml.org/documentation/getting-started-guide/translating-menus/

Author Posts
September 20, 2018 at 5:27 pm

michaelD-67

I try to work with Advanced Translation Editor and tell me that there is no authenticated user to work with this. Also I have problem with translating menus. When I try change a menu or add an element in my existing menus your tool DELETE (yes, delete) the components of my menu and doesn't let me add or change elements in my WP menu.
Thanks in advance!
Michael Diamantidis
Vision Computer Applications
Greece

September 21, 2018 at 5:30 pm #2756139

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hello,
Thank you for contacting WPML support.

1.- I'm truly sorry but I don't understand the issue related to the Advance Translation Editor 🙁

2.- Related to the menu translation, does the issue persists if you deactivate all plugins except WPML plugins and activate a default WordPress theme like Twenty Seventeen?

Kind regards,
Carlos

September 26, 2018 at 6:41 pm #2768428

michaelD-67

Dear Sir,
The Advanced Translation Editor not working in my website. Simple, Not Working, I can't use it.
The menu translation still have problems, it deletes my menus even if I activate the Twenty Seventeen Theme.

Thanks in advance!
Michael Diamantidis
Vision Computer Applications
Greece

September 26, 2018 at 8:41 pm #2768705

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi there,
Thank you very much for your message.

1.- Regarding the Advance Translation Editor. I kindly ask you to complete/try the Translation Management Wizard process from WPML -> Translation Management.

Does the issue persists after finishing the wizard process?

2.- Regarding the menu issue. I would like to ask your authorization to make a copy of the site in order to make further tests in a local environment without affecting the live site.

Looking forward to your answer.
Best regards,
Carlos

September 27, 2018 at 9:11 am #2769881

michaelD-67

Dear Sir,
I complete the Wizard Process, I activate the link from email and I receive this message:

The page you were looking for doesn't exist.

You may have mistyped the address or the page may have moved.

If you are the application owner check the logs for more information.

Also I made a copy of website in a test environment from my provider.

And finally I authorize you to make a coopy of our website to solve the menu problem.

Thanks in advance!
Michael Diamantidis
Vision Computer Applications
Greece

September 27, 2018 at 7:07 pm #2771616

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi,
Thank you very much for your feedback and your authorization.

1.- Regarding the Advanced Translation Editor, I created a test page in the site titled 'Test page in Greek' and translated it using the Advance Translation Editor successfully. I kindly ask you to edit this page and translate it again and compare the behavior with other pages in the site.

Could you confirm that this is working as expected?

2.- I created a copy of the site in order to run more tests on local. I will get back to you as soon as I have an answer.

Best regards,
Carlos

September 28, 2018 at 7:50 am #2772778

michaelD-67

Dear Sir,
1. Finally I receive yesterday an email that I confirm and activate the Advanced Translation Editor. It's a very useful tool and I've already use it.
2. I'm still waiting to solve the menu problem.

Thanks in advance!

Michael Diamantidis
Vision Computer Applications
Greece

September 28, 2018 at 3:55 pm #2774366

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi Michael,

I'm glad to hear that you are using the Advanced Translation Editor already 🙂

Regarding the menus issue, I installed on local a copy of the site and after deactivating all plugins except WPML plugins, the issue disappeared. This means that the cause of the issue is an interacction with a third party functionality. I would like to ask you to follow this steps in order to isolate the cause of the issue:
- Back up your site first before making any change, this is for security reasons.
- Flush all cache memory.
- Deactivate all the plugins that are not related to WPML.
- Double check that the issue is gone and activate the plugins one by one to see with which one there is an interaction issue.

Could you tell me the result of this steps?

Best regards,
Carlos

October 2, 2018 at 7:39 am #2780555

michaelD-67

Dear Sir,
Thank you for your help.
I've already made all these steps and I can't find which of 65 plugins that I have cause the problem. Because the WPML plugin is yours I guess that you should know which plugin(s) cause problems with the menu of wordpress. Can you please tell me which plugin cause this problem? I assume that you have a copy of my website in local installation. And finally we made websites and e-shops and we buy more copies of WPML in future, so we must solve this problem now.

Thanks in advance!
Michael Diamantidis
Vision Computer Applications
Greece

October 2, 2018 at 5:03 pm #2782361

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi Michael,

We have a list of all compatible plugins (https://wpml.org/documentation/plugins-compatibility/), but we don't have a list of all incompatible plugins. The only way to know which plugin is causing this issue in the live site is by following the steps I recommended before.

I kindly ask you to create a staging site with a copy of the live site and follow the steps recommended in my previous message, this way we can find what plugin is causing this issue.

Thank you very much for your understanding!
Best regards,
Carlos

October 3, 2018 at 6:56 pm #2785491

michaelD-67

Dear Sir, I follow all your steps and I deactivate ALL the plugins except WPML but I have the same problem with menus. Also I purge the cache. All these in a live stage environment.
Thanks in advance!

Michael Diamantidis
Vision Computer Applications
Greece

October 5, 2018 at 8:56 pm #2791662

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Hi Michael,
I'm very sorry for the delayed answer.

I made several tests on a local environment but the issue with the menu persists. I have escalated this ticket to our 2nd tier of support. Our specialists in the 2nd tier will take a deeper look at the issue and will try to isolate its cause.

I will get back to you as soon as I get an answer from them.

Thank you very much for your patience and understanding!
Best regards,
Carlos

October 9, 2018 at 4:55 pm #2801264

michaelD-67

Dear Gentlemen,
It's been 20 days since we was purchased your plugin and my problem was not solved. I am very sorry but your attitude is unacceptable. My company and I personally would like to invest in all of our websites buying your plugin but this is not possible due to our unsolved problem. Please very directly to resolve the issue. Thanks in advance!

Michael Diamantidis
Developer
Head of R&D Department
Vision Computer Applications
M.Alexandrou 10, Langadas, Thessaloniki, GREECE, 572 00
Τel: 2394 022964, Fax: 2394 020325
info@visionca.gr, hidden link, hidden link

October 9, 2018 at 6:48 pm #2801583

Carlos Rojas
Supporter

Languages: English (English ) Spanish (Español )

Timezone: America/Montevideo (GMT-03:00)

Dear Michael,
I understand your frustration. Please accept our apologies for the delay.

Our specialists are working on this issue, unfortunately I don't have an answer yet. I just contact them for an update.

I will keep you updated about the evolution of this ticket.

Thank you very much for your patience and understanding!
Best regards,
Carlos

October 13, 2018 at 5:44 am #2813894

michaelD-67

Dear Sir,
How long can I wait to solve my PROBLEM. My client is very angry and wants his money back. You and your tools create a mess in my company and I.

Michael