Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

How to check for Broken Categories?

Quote Reply
How to check for Broken Categories?
Hi,

I know that I can check for broken 'links' using the admin panel, but is there a way I can check for broken categories, ones that don't have a proper parent, e.g.;

/Business
/Business/Companies
/Business/Companies/Training
/Business/Companies/Training/Consulting/On-Site Training *** < this has no parent!

I add most of my new categories manually and I'm not sure if I've occasionally made a mistake - the reason I want to find out about broken categories is that because they don't have a parent, they don't show up in the list of sub-categories like they should.

Any help appreciated.

All the best
Shaun

Quote Reply
Re: How to check for Broken Categories? In reply to
One suggestion is running a query of the CategoryHierarchy and the Category table...basically, if there are no IDs associated with a "parent" ID, then you should get a list of categories that have no parent category.

Hope this helps.

Regards,

Eliot Lee
Quote Reply
Re: How to check for Broken Categories? In reply to
Thanks Eliot - I tried that and it worked fine, just browsed the CategoryHierarchy table from MySQLMan and only the first 21 'top' categories had a parent ID of '0' (zero) so the others are fine - no breaks Smile

All the best
Shaun