This module will do a query of your database and point out any problems/abnormalities in it.

For example, I ran it on my site and it showed me two categories that had no products in them and had a link I could click to delete them right in the report area.

Zen Cart Versions v1.5.4, v1.5.5, v1.5.6