Author Topic: Error when editing product  (Read 1115 times)


  • Beginner
  • *
  • Posts: 3
  • A beginner
Error when editing product
« on: May 19, 2017, 17:04:28 pm »
Hi Support!

I am running VM 3.2.2 on a Joomla 3.6.5 platform.

I am trying to edit my products and receiving the follwoing error:

1054 Unknown column 'product_stockhandle' in 'field list' SQL=UPDATE `#__virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='Spy-Pen',`product_gtin`='',`product_mpn`='',`product_weight`=NULL,`product_weight_uom`='KG',`product_length`=NULL,`product_width`=NULL,`product_height`=NULL,`product_lwh_uom`='M',`product_url`='spy-pen',`product_in_stock`='100',`product_ordered`='0',`product_stockhandle`='0',`low_stock_notification`='0',`product_available_date`='2017-05-18 00:00:00',`product_availability`='',`product_special`='1',`product_discontinued`='0',`pordering`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`=NULL,`product_params`='min_order_level=\"1\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='',`published`='1',`created_on`='2017-05-18 08:51:50',`created_by`='2',`modified_on`='2017-05-19 14:50:37',`modified_by`='2' WHERE `virtuemart_product_id`='57

Would anyone be able to tell me what is wrong and how I could fix it? Seems everything else is running fine, just editing products or product categories?

Was working fine when we were adding all other products but now we have an issue.


  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 26801
  • Always on vacation
    • Jenkin Hill Internet

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VM3.2.14.9808 on Joomla 3.8.7 PHP 7.0.30

Testing VM3.2.15.9824 on J3.8.7


  • Beginner
  • *
  • Posts: 3
  • A beginner
Re: Error when editing product
« Reply #2 on: May 22, 2017, 11:20:54 am »
That seemed to have fixed the error thank you!

I didnt see this option there. Helped a lot.... all sorted and ready to rock n roll

Thank you once again.