Joomla Templates Club 406,261 posts

[kiwilee Friend kiwileeJoin date: June 2012Posts: 30Downloads:0Uploads:1 Thanks: 13 Thanked: 13 times in 1 posts]

#188417

Hi Guys,

I have latest version VM version 2.0.20b and Joomlart Hawkstore.
But I get this error after I add an item to cart.

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` = 1 and `slug` < "hell-skull-kite-7m" 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

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

Anyone experiencing this same problem?
Anyone got a solution?

Also when I add item to cart the item shoots to the left of the page but my item is on the right as per template.

Any advice appreciated.

Regards Lee

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#496717

I would need to take a closer look at your site. Please pm me ftp account of your site and cpanel account of your hosting(check it on phpMyAdmin). I shall check it for you.

[kiwilee Friend kiwileeJoin date: June 2012Posts: 30Downloads:0Uploads:1 Thanks: 13 Thanked: 13 times in 1 posts]

#496804

Hi, I have sent you a PM.
Regards Lee

[Ninja Lead Moderator Ninja LeadJoin date: November 2014Posts: 16064Downloads:310Uploads:2864 Thanks: 341 Thanked: 3854 times in 3563 posts]

#496888

<em>@kiwilee 377976 wrote:</em><blockquote>Hi, I have sent you a PM.
Regards Lee</blockquote>

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.

[Author]

Posts