Unable to delete Product Categories

[Eamon Moriarty]

I get the following error when trying to delete any product category:

vmError: Could not clear category products
Product Category could not be deleted.

Iam using
Joomla 1.5.26 ,  Virtuemart       2.0.8e, Template: Hot ecommerce.
Menu items Home and Shop pointing to VirtueMart Categories Layout (Top Level) but I temporarily changed these to an article and it didn't solve the problem.
No modules referencing any category at present.

There are no child categories and no products in any of the categories.

[bytelord]

Hello,

Probably you have enabled (and now disabled?) multilingual feature, when you add more languages more tables are been created on the database by adding a country prefix, can you check if other languages still have products or part of products?
You can also check this by accessing your mysql database of your joomla installation and check the tables #___virtuemart_categories_en_gb or any other languages you have, also check please #___virtuemart_categories.
The same on products tables if there are products or part of them in other language that have relation to the categories / #___virtuemart_product and #___virtuemart_categories_en_gb.

Take a look on that and post back.

Regards

[Eamon Moriarty]

Thanks for your reply.
I checked MySQL database and didn't find any products in any of the tables you suggested.
I found tables relating to CSV Advanced component which was used to import the categories originally and I deleted those but that still didn't solve the problem.
I then deleted all the product categories through mySQL so that solved it OK.
I created a new test category and was able to delete it normally.
So the problem is solved (temporarily at least)
Thanks for pointing me in the right direction.

[bytelord]

Hello,

I am thinking that maybe some relations took place and for that reason you were couldn't delete the categories from the front-end.
Maybe sometimes after you use third-party components should be used tools-> tools & migration -> Install tables or if necessary update them.