[Closed] Homepage and menu association issue across languages

Can you make me site administrator? It would seem I have editor or author privileges only, so I can't access and of the WPML settings.

I am unable to find a pattern on why this happens. I would like to test this on my localhost server to exclude possible server caching issue or other possible causes.

To help troubleshoot this issue more efficiently, I would like to use a tool called Duplicator (hidden link) to create a temporary diagnostic copy of the website.

Using this tool, I will generate a lightweight “package” of the site that contains only the database and essential files. All media files (images, videos, etc.) will be excluded to keep the package small and secure.

This package will be used only in a secure local testing environment to reproduce the problem and analyze it in detail. This allows me to test fixes safely without touching or impacting your live website in any way. Your production site will not be modified, slowed down, or affected during this process.

You can find more information about this process here:
https://wpml.org/faq/checklist-before-opening-a-ticket-in-wpml-support/#get-help-from-support

Let me know if this is ok!

I’m checking this with our second-tier team and will keep you updated.

Can you try this?

TRUNCATE TABLE `kc4_yoast_indexable`;
TRUNCATE TABLE `kc4_yoast_indexable_hierarchy`;

Because it contains invalid data.
For example for ID 731, we have the permalink /ru/ instead of /fr/ and for ID 6787, we have the / as permalink instead of /fr/

Hi,

You can follow the steps below. Please make sure you complete the backup step before doing anything else, as this change is not reversible without a backup.

1. Create a database backup
Before making any changes, create a full database backup. You can do this from your hosting control panel (cPanel, Plesk, Site Tools, etc.) by downloading a database backup, or by using an existing WordPress backup plugin such as UpdraftPlus. Make sure the backup file is successfully created and saved.

2. Install the Adminer plugin
Log in to your WordPress admin area and go to Plugins → Add New.
Search for “PexleChris Adminer”, install it, and activate the plugin.
https://wordpress.org/plugins/pexlechris-adminer/

3. Open Adminer and select the database
After activation, go to WP Adminer at the top of the dashboard.
You will see a list of databases. Click the database used by your WordPress site (this is the same database name defined in wp-config.php).

4. Run the SQL queries
Inside Adminer, click on “SQL command”.
Paste the following queries exactly as shown:

TRUNCATE TABLE `kc4_yoast_indexable`;
TRUNCATE TABLE `kc4_yoast_indexable_hierarchy`;

Then click Execute.

If you get an error saying the tables do not exist, look for Yoast tables in the database and replace the “kc4_” prefix with your actual table prefix (for example, wp_).

Check a few pages on the site to confirm the correct language URLs are being generated. If anything looks wrong, restore the database backup you created in step 1.

If you are still not comfortable doing this, let me know and I will be happy to assist. Make sure to have database backup using plugins such as or UpdraftPlus or similar before allowing me to make such changes.

I recommend a full database backup of the WordPress site. A full database backup is the safest option because it allows a complete restore if needed and avoids any risk of missing related tables or data dependencies. Backing up only specific tables is not recommended in this case.

Preferred way to create the backup (either option is fine):

1. Hosting control panel (preferred)
Create a full database export from your hosting panel (cPanel, Plesk, Site Tools, etc.).
Download and store the backup file locally to confirm it is safely saved.

OR

2. Plugin-based backup
Use a reliable plugin such as UpdraftPlus (or an equivalent you already use).
Ensure the database backup completes successfully and is available for restore.

Once the full database backup is completed and confirmed, you can grant access and I will apply the fix directly. If anything unexpected occurs, the database can be restored immediately from the backup.