News:

Looking for documentation? Take a look on our wiki

Main Menu

can't modify detail of product

Started by TAIWAR, June 13, 2014, 00:41:30 AM

Previous topic - Next topic

TAIWAR

VM266 :
I try to change a price or add something but I can't :

vmError: Product store TableProducts: :store échoué
Unknown column 'product_gtin' in 'field list' SQL=UPDATE `perle_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='3216 ',`product_gtin`='',`product_mpn`='',`product_weight`='38.0000',`product_weight_uom`='G',`product_length`=NULL,`product_width`=NULL,`product_height`=NULL,`product_lwh_uom`='M',`product_url`='',`product_in_stock`='5',`product_ordered`='0',`low_stock_notification`='2',`product_available_date`='2014-02-18 00:00:00',`product_availability`='',`product_special`='0',`pordering`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`=NULL,`product_params`='min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`created_on`='2014-04-28 13:59:50',`created_by`='924',`modified_on`='2014-06-12 22:33:55',`modified_by`='914' WHERE `virtuemart_product_id`='714'

GJC Web Design

Sounds like your DB tables aren't up to date

back up your DB

enable database tools on Config->Config->Shop tab

then Tools & Migration - click 'Install or if nesscesary update tables' -> agree

Don't click anything else

then check your #__virtuemart_products table to see if the product_gtin is there
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

TAIWAR

its solved Thank you very much !!!!!! :) :) :) :)