On gists

Recontruct nav cache

AW

reconcstruct-nav-cache.sql Raw #

TRUNCATE navigation_cache;

INSERT INTO navigation_cache 
(navigation_id, language_id, path, id_path)
(
    SELECT navigation_id, language_id, NavigationPath(navigation_id, language_id, title), CONCAT(NavigationIdPath(navigation_id, language_id), "/")
    FROM navigation_lang
);