Unable To Change Directory For Category

Hi, I've got a problem that I think I know the cause, but I don't know how to fix.

I recently upgraded to a multi-store licence, and have been experimenting with the new store. So have been creating, trying out different things, then deleting the store, recreating the store again.

When doing this, I didn't delete the products and the category first. I just removed the entire store.

Have only just realised that with each store I create, the directory for the category is still remembered. So now when I create the same category, it is showing as "www.example.com/category-en-2/" and I am unable to change it back to "www.example.com/category/".

Could really use someone's help on how I can fix this. I've tried clearing cache, and that didn't seem to work.

Thank you.

It means that another object has the category SEO name. Check the cscart_seo_names table to find this object

It means that another object has the category SEO name. Check the cscart_seo_names table to find this object

Thanks for this.. where do I find the cscart_seo_names table?

Thanks for this.. where do I find the cscart_seo_names table?

Use phpMyAdmin to check your database

Use phpMyAdmin to check your database

Never got back to you on this.. manage to use phpMyAdmin and figure out the issue.
Thanks!

You are welcome!