There's a DB column being wasted for nav_menu_items and i was driving crazy because post_name was always returning a NUMBER! in my navigation menu items.
Then I found out SOME have a text-slug, and SOME DONT.
I don't know why the oddity. I then figured out in the DB that the nav_menu_item is a "type" of post. So I removed the menu items, Created new ones (permalinks as /%postname%/) , new id numbers were assigned, and YET no slug.
Earlier, I already tried manually modifying the slug in the post editor, but the menu items have their own entry, and there seems to be no script to update them based on the post changes (page, not post)
I also tried a plugin to re-create the slugs… no success (it seems to work on the pages only, not the nav_menu_item type posts.
I'm out of ideas.
I need it to style the menu items with a different icon each, and I can't rely on the ID to be always the same.
Is that a bug?
Should they update automatically?
How did some good post_names managed to get there correctly?