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

visualize any product shows me this error 1054

Started by dinaweb, September 22, 2016, 10:04:45 AM

Previous topic - Next topic

dinaweb

visualize any product shows me this error.
VirtueMart 3.0.18
Joomla! 3.6.2

1054 - Unknown column 'pr.customer' in 'field list' SQL=SELECT `u`.*,`pr`.*,`l`.`product_name`,`rv`.`vote`, IFNULL(`u`.`name` COLLATE utf8mb4_unicode_ci, `pr`.`customer` COLLATE utf8_unicode_ci) AS customer FROM `#__virtuemart_rating_reviews` AS `pr` INNER JOIN `#__virtuemart_products_es_es` AS `l` ON `l`.`virtuemart_product_id` = `pr`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_rating_votes` AS `rv` on (`pr`.`virtuemart_rating_vote_id` IS NOT NULL AND `rv`.`virtuemart_rating_vote_id`=`pr`.`virtuemart_rating_vote_id` ) XOR (`pr`.`virtuemart_rating_vote_id` IS NULL AND (`rv`.`virtuemart_product_id`=`pr`.`virtuemart_product_id` and `rv`.`created_by`=`pr`.`created_by`) ) LEFT JOIN `#__users` AS `u` ON `pr`.`created_by` = `u`.`id` WHERE `pr`.`virtuemart_product_id` = "96" ORDER BY created_on DESC LIMIT 0, 3

GJC Web Design

and is there a field called 'customer' in your  #__virtuemart_rating_reviews table?

If not try the vm tools table updater or just add it

customer   varchar(128)    utf8_general_ci      No    NULL
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