News:

Support the VirtueMart project and become a member

Main Menu

Can't display product in particular category

Started by EIF, June 18, 2013, 09:57:25 AM

Previous topic - Next topic

EIF

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.




Milbo

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
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

EIF

Ehm, is it caused by a fix, or is this fixed in the new release?

Is it possible to delete these old relations?

Milbo

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

EIF

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?

EIF

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.

jenkinhill

You will probably need to edit these directly in the database using phpMyAdmin.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

EIF

Yes, I do understand that, but my question actually is: which tables/fields do I need to edit in the database?

Milbo

Every table starting with #_virtuemart_category_ I think.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/