VirtueMart Error!

Joomla 2.5
www.thechildrenofbotswana.org

Hello, not sure why this is happening:


vmError: getNeighborProducts Unknown column 'category_name' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `les86_virtuemart_products` as `p` JOIN `les86_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `les86_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `les86_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 17 and `slug` < "traditional-home" 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 Unknown column 'category_name' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `les86_virtuemart_products` as `p` JOIN `les86_virtuemart_products_en_gb` as `l` using (`virtuemart_product_id`) JOIN `les86_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `les86_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 17 and `slug` > "traditional-home" 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

Hi,

I have similar problem on http://www.elektroelkon.cz after update VM to latest version 2.0.20b on PC browsers on.

Second problem is, that My Cart (Můj košík) is not shown. After click on it is still show "Loading" (Nahrávám), but nothing else.

Please help me.

Hi

Looks like query has been constructed wrong. You should report this to VM developers.

Thanks for quick reply. How I can do it? I never wrote to VM developers.

Hi

Looks like query has been constructed wrong. You should report this to VM developers.