Error message in cart: vmError: getNeighborProducts Column 'slug' in where claus

[Lee2008]

Hi,

I raised these error concerns with the tech support at Joomlart first.
And I followed a topic on VM suggesting I

put a new file at:
public_html/administrator/components/com_virtuemart/models
as suggested here https://forum.virtuemart.net/index.php?topic=114063

[/i]

Joomlart tech support also investigated and said:

I tried to check and compare the problem on your site with virtuemart code on our dev but i could not find any difference, this is the problem of database on your site. My best recommendation in this case is that you should also raise this in the Virtuemart component forum, the better answer will be available for you there.

PHP Version    5.3.17
VM 2.0.20b
Joomla! 2.5.8

Error happens on JA Hawkstore template and also std Joomla Beeze 2.0 template.

The error I get is:

        vmError: getNeighborProducts Column 'slug' in where clause is ambiguous SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `jos_virtuemart_products` as `p` JOIN `jos_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `jos_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_categories_en_gb` as `c` using (`virtuemart_category_id`) WHERE `virtuemart_category_id` = 2 and `slug` < "skullface-135cm-x-40cm-wide" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY category_name DESC LIMIT 0,1
        vmError: getNeighborProducts Column 'slug' in where clause is ambiguous SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `jos_virtuemart_products` as `p` JOIN `jos_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `jos_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) LEFT JOIN `jos_virtuemart_categories_en_gb` as `c` using (`virtuemart_category_id`) WHERE `virtuemart_category_id` = 2 and `slug` > "skullface-135cm-x-40cm-wide" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY category_name ASC LIMIT 0,1


Any suggestions on a real solution much appreciated.

[Milbo]

I suggest to download the RC 2.0.21G. I am quite sure it is fixed there. http://dev.virtuemart.net/projects/virtuemart/files

[Lee2008]

Thank you!
That fixed it so fast.

Many thanks.

Lee

[Lee2008]

Since this morning after I turned the site back to live the VM shop stopped working.

Error:
Category id 0 not published

Joomla Menu link to my store VM Categories layout... not displaying anything.



[attachment cleanup by admin]