News:

Looking for documentation? Take a look on our wiki

Main Menu

VIRTUEMART ERROR MESSAGE

Started by THUTO, April 09, 2013, 19:12:09 PM

Previous topic - Next topic

THUTO

I AM USING:

1. Gavick Template
2. Joomla 2.5
3. PHP 5.3
4 VM: 2.0.20b


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` = 12 and `slug` < "mokoros" 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` = 12 and `slug` > "mokoros" 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

jenkinhill

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