[Resolved] Cannot access WP Menus Sync page

Hi,

Please make a full backup of your site and database then share the backup file with me. I will restore your site on my local host and investigate the issue further. Your next reply is set to private to share the info.

You can use this plugin to create the backup: https://wordpress.org/plugins/duplicator/

Look forward to your reply.
Thanks

Hi,

I can take a backup file on your site with the plugin All In One WP Migration and restore it on my local site. After trying some steps to troubleshoot the issue, it still does not work.
I'm asking our 2nd tier support about this issue and update you here when I have something to share.

Thanks.

Hi,

I got some information from our 2nd tier support: this is a database corruption issue and please follow the workaround below to fix this.

❌ IMPORTANT: Please backup your database and website before proceeding ❌

- Edit the file wp-content/plugins/sitepress-multilingual-cms/inc/wp-nav-menus/wpml-menu-sync-functionality.class.php

- Around line 467-481, replace the code:

private function get_menu_item_depth( $item_id ) {
	$depth = 0;
	do {
		$object_parent = get_post_meta( $item_id, '_menu_item_menu_item_parent', true );
		if ( $object_parent == $item_id ) {
			$depth = 0;
			break;
		} elseif ( $object_parent ) {
			$item_id = $object_parent;
			$depth ++;
		}
	} while ( $object_parent > 0 );

	return $depth;
}

with this one

private function get_menu_item_depth( $item_id ) {
	$depth = 0;
	$processed = [];  // To keep track of visited menu items

	do {
		$object_parent = get_post_meta( $item_id, '_menu_item_menu_item_parent', true );

		// Detect circular reference and break the loop
		if (in_array($item_id, $processed)) {
			$depth = 0;  // or perhaps a special value to indicate an error
			break;
		}

		// Mark the current item as processed
		$processed[] = $item_id;

		if ( $object_parent == $item_id ) {
			$depth = 0;
			break;
		} elseif ( $object_parent ) {
			$item_id = $object_parent;
			$depth++;
		}
	} while ( $object_parent > 0 );

	return $depth;
}

then you can access the page WPML > WP Menus Sync again.

Look forward to your reply.
Thanks