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

can't search product on backend

Started by TAIWAR, June 13, 2014, 00:28:34 AM

Previous topic - Next topic

TAIWAR

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

GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation