There is a field in the category and product tables called "tabmoduleid" that needs to be updated. Add a new category and note the tabmoduleid that is added is different from the rest of the records. Issue the following update stmt:
update smith_products where set tabmoduleid = 'your new tabmoduleid'
if you are using an objectqualifer in your database you will need to prefix your table with it.