VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: sjaven on June 01, 2015, 14:19:33 PM

Title: Ghost products
Post by: sjaven on June 01, 2015, 14:19:33 PM
Currently using VM3.0.8 on Joomla! 3.4.1 Stable [ Ember ] 21-March-2015 20:30 GMT PHP Version 5.5.25-1~dotdeb+7.1

Struggling with non existing products showing (product image unavailable graphic) on following page views - Latest products - Selected products - Random products
Clicking on these images will lead you to a 404 - product does not exist error.
Viewing each separate product category will not show these "ghost products"

I have tried:
1 - turning SEF on and off for both joomla and VM
2 - Update tables in VM tools
3 - Trying a different template

Running VM stats it show that I have 75 active products, but checking manually in VM i cannot find more than 48 products total, and they are all active.
I am not an SQL speshitpillt, but I am starting to suspect inconsistencies in the database. Site is: www.signpad.no
Appreciate any help that will point me in the right direction
Title: Re: Ghost products
Post by: GJC Web Design on June 02, 2015, 12:04:50 PM
You need to look directly in your database product table to see what is going on -- perhaps demo english products if u used a quick start
Title: Re: Ghost products
Post by: chetanmadaan on June 03, 2015, 00:05:01 AM
I am sure this is due to database inconsistencies.... Like other extensions uses #__assets table. Try to differentiate between a existing and ghost product and you will be able to get to the bottom of it.
Title: Re: Ghost products
Post by: Milbo on June 03, 2015, 21:31:13 PM
It can be also a language issue. Then you have maybe products without language table, or only language table entries, without product