VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: TAIWAR on June 13, 2014, 00:28:34 AM

Title: can't search product on backend
Post by: TAIWAR on June 13, 2014, 00:28:34 AM
VM 266
I can't search a product on backend I have this message (but the name of product exist on database)

vmError: exeSortSearchListQuery Unknown column 'product_gtin' in 'where clause' SQL=SELECT SQL_CALC_FOUND_ROWS p.`virtuemart_product_id` FROM `perle_virtuemart_products` as p INNER JOIN `perle_virtuemart_products_fr_fr` as l using (`virtuemart_product_id`) WHERE ((`product_name` LIKE "%colorant%" OR `product_sku` LIKE "%colorant%" OR `product_gtin` LIKE "%colorant%" OR `product_mpn` LIKE "%colorant%" OR `l`.`slug` LIKE "%colorant%" OR `product_s_desc` LIKE "%colorant%" OR `l`.`metadesc` LIKE "%colorant%")) group by p.`virtuemart_product_id` ORDER BY created_on DESC LIMIT 0, 20
Title: Re: can't search product on backend
Post by: GJC Web Design on June 13, 2014, 01:02:26 AM
answer on other post should fix this...  http://forum.virtuemart.net/index.php?topic=124349.0