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.

Author Posts
December 3, 2015 at 11:59 am #760521

Rainer

I am trying to: change navigation points in the menu. I can do it and save it, but after a other menu is changed. I have for every language 10 menus. total menu 40.
-> I tried to change the URL format to dictatorinternational.de/en and back to en.dictatorinternational.de but it doesn´t work

URL of (my) website where problem appears: hidden link hidden link hidden link

I expected to see: a changed menu

Instead, I got: a other menu changed the navigation points by himself

December 3, 2015 at 12:16 pm #760537

Rainer

*Logs, my host IS Fun says perhaps it´s a problem with the database ?

Dec 2 14:16:10 ger13 httpd: WordPress-Datenbank-Fehler 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 ' CASE p.post_type WHEN 'page' THEN 2 WHEN 'post' THEN 1 ELSE 0 END DESC #012#011#011#011#011' at line 10 für Abfrage #012#011#011#011#011#011#011#011#011#011 SELECT post_type, post_name#012#011#011#011#011#011#011#011#011#011 FROM wp_posts p#012#011#011#011#011#011#011#011#011#011 LEFT JOIN wp_icl_translations t#012#011#011#011#011#011#011#011#011#011#011ON t.element_id = p.ID#012#011#011#011#011#011#011#011#011#011#011 #011AND CONCAT('post_', p.post_type) = t.element_type#012#011#011#011#011#011#011#011#011#011 #011#011AND p.post_type IN ('post','page','attachment','slide','avada_portfolio','avada_faq','themefusion_elastic','tribe_events' ) #012#011#011#011#011#011#011#011#011#011 WHERE post_name = 'unternehmen/ueber-dictator' AND post_type IN ('page')#012#011#011#011#011#011#011#011#011#011 #011AND post_status = 'publish'#012#011#011#011#011#011#011#011#011#011 #011#012#011#011#011#011#011#011#011#011#011 #011, CASE p.post_type WHEN 'page' THEN 2 WHEN 'post' THEN 1 ELSE 0 END DESC #012#011#011#011#011#011#011#011#011 LIMIT 1 von require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, call_user_func_array, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_404_Guess->guess_cpt_by_name

Dec 2 14:17:47 ger13 httpd: WordPress-Datenbank-Fehler 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 ' CASE p.post_type WHEN 'page' THEN 2 WHEN 'post' THEN 1 ELSE 0 END DESC #012#011#011#011#011' at line 10 für Abfrage #012#011#011#011#011#011#011#011#011#011 SELECT post_type, post_name#012#011#011#011#011#011#011#011#011#011 FROM wp_posts p#012#011#011#011#011#011#011#011#011#011 LEFT JOIN wp_icl_translations t#012#011#011#011#011#011#011#011#011#011#011ON t.element_id = p.ID#012#011#011#011#011#011#011#011#011#011#011 #011AND CONCAT('post_', p.post_type) = t.element_type#012#011#011#011#011#011#011#011#011#011 #011#011AND p.post_type IN ('post','page','attachment','slide','avada_portfolio','avada_faq','themefusion_elastic','tribe_events' ) #012#011#011#011#011#011#011#011#011#011 WHERE post_name = 'unternehmen/ueber-dictator' AND post_type IN ('page')#012#011#011#011#011#011#011#011#011#011 #011AND post_status = 'publish'#012#011#011#011#011#011#011#011#011#011 #011#012#011#011#011#011#011#011#011#011#011 #011, CASE p.post_type WHEN 'page' THEN 2 WHEN 'post' THEN 1 ELSE 0 END DESC #012#011#011#011#011#011#011#011#011 LIMIT 1 von require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, call_user_func_array, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_404_Guess->guess_cpt_by_name

Dec 2 14:18:44 ger13 httpd: WordPress-Datenbank-Fehler 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 ' CASE p.post_type WHEN 'page' THEN 2 WHEN 'post' THEN 1 ELSE 0 END DESC #012#011#011#011#011' at line 10 für Abfrage #012#011#011#011#011#011#011#011#011#011 SELECT post_type, post_name#012#011#011#011#011#011#011#011#011#011 FROM wp_posts p#012#011#011#011#011#011#011#011#011#011 LEFT JOIN wp_icl_translations t#012#011#011#011#011#011#011#011#011#011#011ON t.element_id = p.ID#012#011#011#011#011#011#011#011#011#011#011 #011AND CONCAT('post_', p.post_type) = t.element_type#012#011#011#011#011#011#011#011#011#011 #011#011AND p.post_type IN ('post','page','attachment','slide','avada_portfolio','avada_faq','themefusion_elastic','tribe_events' ) #012#011#011#011#011#011#011#011#011#011 WHERE post_name = 'unternehmen/fertigungsstandorte/dictator-productie' AND post_type IN ('page')#012#011#011#011#011#011#011#011#011#011 #011AND post_status = 'publish'#012#011#011#011#011#011#011#011#011#011 #011#012#011#011#011#011#011#011#011#011#011 #011, CASE p.post_type WHEN 'page' THEN 2 WHEN 'post' THEN 1 ELSE 0 END DESC #012#011#011#011#011#011#011#011#011 LIMIT 1 von require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, call_user_func_array, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_404_Guess->guess_cpt_by_name

Dec 3 11:15:02 ger13 httpd: WordPress-Datenbank-Fehler 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 ' CASE p.post_type WHEN 'page' THEN 2 WHEN 'post' THEN 1 ELSE 0 END DESC #012#011#011#011#011' at line 10 für Abfrage #012#011#011#011#011#011#011#011#011#011 SELECT post_type, post_name#012#011#011#011#011#011#011#011#011#011 FROM wp_posts p#012#011#011#011#011#011#011#011#011#011 LEFT JOIN wp_icl_translations t#012#011#011#011#011#011#011#011#011#011#011ON t.element_id = p.ID#012#011#011#011#011#011#011#011#011#011#011 #011AND CONCAT('post_', p.post_type) = t.element_type#012#011#011#011#011#011#011#011#011#011 #011#011AND p.post_type IN ('post','page','attachment','slide','avada_portfolio','avada_faq','themefusion_elastic','tribe_events' ) #012#011#011#011#011#011#011#011#011#011 WHERE post_name = 'les-amortisseurs-de-porte-dictator-non-seulement-protegent-du-bruit-mais-aussi-veillent-a-ce-que-des-portes-soient-fermees-surement' AND post_type IN ('post', 'page', 'attachment', 'slide', 'avada_portfolio', 'avada_faq', 'themefusion_elastic', 'wysijap', 'tribe_events')#012#011#011#011#011#011#011#011#011#011 #011AND post_status = 'publish'#012#011#011#011#011#011#011#011#011#011 #011#012#011#011#011#011#011#011#011#011#011 #011, CASE p.post_type WHEN 'page' THEN 2 WHEN 'post' THEN 1 ELSE 0 END DESC #012#011#011#011#011#011#011#011#011 LIMIT 1 von require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, do_action_ref_array, call_user_func_array, SitePress->parse_query, WPML_Query_Parser->parse_query, WPML_Query_Parser->maybe_adjust_name_var, WPML_404_Guess->guess_cpt_by_name

December 4, 2015 at 1:58 pm #761548

Mladen Andrejic

Hello,

It looks like that is the problem with DB, but you will have to recreate the menus following those instructions :

- Create Backup of your website
- Delete all the menus (in all languages)
- Create the Menus ONLY in default language
- Go to WPML > WP Menus Sync and synchronize the menus to all languages

Thanks.

December 4, 2015 at 2:10 pm #761562

Rainer

you mean all menus????
12 x4 languages = 48 menus = xxxx navigations Points
It´s a big work!!!!!!!
If it possible you look to the website more detailed? To find the 1,2,3,4,5 wrong menu?
Regards
Rainer

December 4, 2015 at 2:13 pm #761564

Rainer

... included the German language?

December 4, 2015 at 2:20 pm #761576

Mladen Andrejic

Hello Rainer,

Yes, I know it's a big work to do, but it's unfortunately the only way to have properly synchronized menus across all languages, as currently it might happen that the menus don't have same trid in the database which will connect them and mark as translations.

Thanks.

December 4, 2015 at 3:16 pm #761649

Rainer

I deleted all menu in en,es,fr not in German. And synchronized it. But now I´m missing the menu only by 10 pages like hidden link

Do you think I can "repair" it? Or delete totally all menus? I don´t want to do it 😉

December 7, 2015 at 7:34 am #762381

Mladen Andrejic

Hello Rainer,

What menus exactly are missing now? In order to be of a better help, I will need to request temporary access (WP-Admin and FTP) to your site.

You will find the needed fields for this below the comment area when you log in to leave your next reply like this hidden link .
The information you will enter is private which means only you and I can see and have access to it.

// NOTE : Make sure that you have performed the backup before you let me access the site.

Thanks.

December 8, 2015 at 10:29 am #763360

Mladen Andrejic

Hello,

Glad to hear that it now works. As the original issue is resolved may I kindly ask you please to open a new ticket for your new question? This will also help other users with similar problems find solutions when searching the forum.

Thanks.

December 8, 2015 at 10:41 am #763381

Rainer

Problem solved