[Waiting for user feedback] Japanese Language issue with Menu Sync

After checking the database, I can definitely understand why you have issues. you have a LOT of corrupt elements on your database, they start in the post and taxonomies and then of course spread into the WPML tables where the content doesn't have a language assigned or has a random one (usually japanese or portuguese) and of course create all the issues you're seeing.

I'm talking to our developers to see if we can do something about this because the other option would be for you to delete all the menus and build them again, making sure you have enough memory, a good database connection with the server, maybe with php 8.0 or 8.1 at most, to make sure the queries are written correctly.

I'll keep you updated as soon as our dev lets me know what we can do for you.

Hi there!

I have an Idea of what is happening. When i checked your database I noticed that your site was missing a LOT of the information WPML required. there were many ghost pages in the wp_posts, which usually means that something went wrong at one point and the entries exist and are assigned to something but they are not formatted properly in the DB so WP doesn't recognize them.

Thanks to this, the ICL tables also have wrong information, missing language data, etc.

- It's ok if you set your previous backup so you don't get blocked but I suspect that it will just buy you time, not fix the problem.

- Before translating anything, try to bulk save the pages, maybe add a tag, category, change the status or something and then undo the changes with another bulk edit process. This could help rewrite the content in the database and assign content.

- Take a note of the amount of pages, posts, etc you have in different languages

- Once you do that try going to WPML -> Support -> Troubleshooting

Press the following buttons:

• "Clear the cache in WPML"
• "Remove ghost entries from the translation tables"
• "Fix element_type collation"
• "Set language information"
• "Fix post type assignment for translations"

See if by any chance something disappears then

--------------

Can you tell me exactly how are you importing the WPML content? I'm still waiting on our dev to let me know what we can do to help you 🙂 so please do not remove the access you had given us to both the cloned site and the superadmin so we can access the DB.

We will not make any change to anything more than the cloned site (ID: 7).

1) The fact that the content appears in the front-end but not in the back-end tells me there is indeed a missing language somewhere in the db. did you try running the troubleshooting options i shared in my last reply? they might help here. you might also want to click the "Fix term counts" option on the troubleshooting page and see if that helps.

2) You mentioned that some posts were skipped on the translated languages but that you could see them as if they were uploaded. When they are skipped it's because the ID of that page (or well the reference you gave to WP All Import) already existed. this part has nothing to do with WPML BUT if they were initially imported and were not connected to WPML or were connected wrongly, then that could be part of the problem. I don't think it could create any ghost entries there, though.

About WPML Import/export, that is usually a plugin that can work with WP All Import but you could probably do it without 🙂 and the fact that they got disconnected and connected again could be part of the issue here, but that's just a theory at the moment.

I think that if you run the troubleshooting and the bulk edit + save (both in the original and the translated pages now that I know that you uploaded them via a plugin) you might save the DB entries.

Just to fully confirm, can you check this guide: https://wpml.org/documentation/related-projects/legacy-wpml-all-import/importing-multiple-languages-with-wp-all-import-and-wpml/

Can you tell me you followed the same procedure seen in this guide or if there was something that didn't appear as in the guide or that was different?

3) For the menu Issue, I'm waiting on our dev about this BUT i noticed that I don't have access to the cloned site anymore via that link you sent, could you verify why and resend it? we do have access to the part with the database though!