Changed Category Name/url, Categories Broken

[opticscamp]

I changed the name and URL of one of my shop categories, and something broke.  That category no longer appears under "categories."  I can see it in the backoffice, modify it, and I can verify that those changes are being made to the database, but it doesn't show up in the front office "categories" block.  

 

The link to that category in my top menu now directs to the root of my domain.  No idea why, the rewrite url in the database appears correct.  Basically, I can't get to that category page.

 

Another major side effect is that all subcategories under this category are now 404.  Again, they show in backoffice, but I can't navigate to them on the site.

 

Thought maybe it was a friendly URL issue, so I removed the htaccess file, turned off friendly URLs, then re-enabled them.  The htaccess file was recreated, but the error still occurs.  

 

At some point during the renaming, the association for this category was enabled for my second shop, which (for some reason) caused the category to default to root, instead of home.  I disabled that association and moved the category to where it was supposed to be.  Might that have something to do with it?

 

I don't want to create another category with that name as a workaround.  I have several hundred products and a dozen or so categories in the tree that will need their associations changed if I go that route, and I'd like to avoid it.

 

Anybody ever see something like this happen?  Any ideas?  

[opticscamp]

An update.

 

Did some poking around the category tables in the database.  The parent of this category keeps getting set to 1, which is root.  It should be 2, which is home.  I changed it back again, and also changed the ps_category.depth_level to 2, which is what my other home categories were set to.  

 

Now, the link to that category in my menu bar is the correct URL for that category.  However, I'm still getting a 404.  It also appears that the subcategories within that category are no longer showing up in the front office.  They are visible in the backoffice however.  

[opticscamp]

Well, the problem has been solved.  I can't explain exactly what it was, but I think the combination of category database values (parent, depth_level) and friendly URLs fixed it.  I had to go into each subcategory of the original category, and save them so that the back office would update the database with the correct values for each one. Everything seems to be working now.