News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

VIRTUEMART ERROR

Started by THUTO, April 05, 2013, 23:14:35 PM

Previous topic - Next topic

THUTO

WHY AM I GETTING THIS ERROR?


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` = 9 and `slug` < "children-fetching-water2013-03-13-00-32-04" 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` = 9 and `slug` > "children-fetching-water2013-03-13-00-32-04" 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
THUTO

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

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

So what happened when you followed the instructions in the thread I referred you to?
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