|
Richard Duncan
|
February 4, 2019 at 10:55 am
We encountered some corruption on migration between hosts.
Now we are missing a menu link for Event Posts and Locations
What database tables do we need to inspect/restore in order to resolve the missing link for Event Posts and Locations?
We have a full backup copy of the site when these were functional, I just need some guidance on what we are needing to fix to restore those functions?
Please advise.
Thanks
|
|
Josh
|
February 4, 2019 at 1:13 pm
Hi,
Navigation menu items are stored in the _posts table with post_type = nav_menu_item.
When a new custom menu is added, its entry is added into several tables.
- table: _term_taxonomy with a column taxonomy and value nav_menu
- term_id is also in table:_terms with the title of menu which is shown in admin panel
- table: _term_relationships will contain term_texonomy_id from _term_taxonomy and connection to all object_id which will be linked to all _post table having sub_menu and below level menu
- table: _postmeta will contain all the details related to menu and submenu for each object ID from _posts table (post_id)
|
