I have noticed that certain categories in the database don’t have entries. Once they are saved manually, the entries appear, but there are much too many of them to save them all manually.
This is what the query “SELECT * FROM catalog_category_entity_text” shows before you save the category
and this is what the query shows after you save the category.
I need these database entries because I am planning on adding data to the categories and updating via the database makes it much faster. Thus I need to resave all the categories so I can use the database to update them. I tried the advice in this question Fastest way to load category and save programmatically in Magento 2, but I had the same “Invalid URL Key” error that the OP had. I am wondering if anyone knows how to resolve the category save issue or knows another way to “refresh” the database so that these entries appear.