vmError: getNeighborProducts Unknown column 'category_description'

[madredeuz]

I updated virtuemart 2.0.18a to 2.0.20b, and appears this error in the product details.



        vmError: getNeighborProducts Unknown column 'category_description' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `j25_virtuemart_products` as `p` JOIN `j25_virtuemart_products_es_es` as `l` using (`virtuemart_product_id`) JOIN `j25_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `j25_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 34 and `slug` < "pegamento-cianocrilato-roket-hot" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY category_description DESC LIMIT 0,1
        vmError: getNeighborProducts Unknown column 'category_description' in 'order clause' SQL=SELECT `l`.`virtuemart_product_id`, `l`.`product_name` FROM `j25_virtuemart_products` as `p` JOIN `j25_virtuemart_products_es_es` as `l` using (`virtuemart_product_id`) JOIN `j25_virtuemart_product_categories` as `pc` using (`virtuemart_product_id`) LEFT JOIN `j25_virtuemart_product_shoppergroups` as `psgr` on (`psgr`.`virtuemart_product_id`=`l`.`virtuemart_product_id`) WHERE `virtuemart_category_id` = 34 and `slug` > "pegamento-cianocrilato-roket-hot" AND ( psgr.`virtuemart_shoppergroup_id`= "2" OR psgr.`virtuemart_shoppergroup_id` IS NULL ) AND p.`published`= 1 ORDER BY category_description ASC LIMIT 0,1



Any idea?, I have search in the forum, but nothing related with category_description

thank´s
Yeray

[jenkinhill]

See https://forum.virtuemart.net/index.php?topic=114063

[madredeuz]

I allready saw that post, but it didn´t worked when I did it, but now is working fine, thank´s a lot.

Regards
Yeray

[madredeuz]

Ok, no, I notced that is not working when logged in, very strange.

[andrew86576]

it seems that  in vm shopfont core settings ,this option: Show the product navigation?   just make it not work.    the problem settled.