I had some product categories with some products. Everything was ok. I deleted these categories for some reason and later I created the same categories again for the same products.
But now the products won't display in the new (but same) productcategory. It only displays in other categories.
I figured out that if I change the category alias, it will display the products again. So using the same alias as I used before the deletion, will not work somehow.
How can I fix this?
I am using virtuemart 2.0.20b and also the default virtuemart SEF.
I fear there are old relations in the database, because I added a fix in the new release http://forum.virtuemart.net/index.php?topic=115877.0
Ehm, is it caused by a fix, or is this fixed in the new release?
Is it possible to delete these old relations?
It is fixed in the new release, but I do not really understand how it happened. Of course you can delete the old relations, if you know the old category id.
Yes, I do know the ID, but I don't know what to delete.
Where can I find this relation? Do I just need to delete the category itself in table virtuemart_product_categories? Or are there other tables where I have to delete or edit something?
Can someone please help me out with this?
Products (both new products and existing products) won't display in the category. I need to use the same alias of the product category.
You will probably need to edit these directly in the database using phpMyAdmin.
Yes, I do understand that, but my question actually is: which tables/fields do I need to edit in the database?
Every table starting with #_virtuemart_category_ I think.