Author Topic: 1054 Unknown column when trying to add manufacturer  (Read 1259 times)

websmith

  • Jr. Member
  • **
  • Posts: 122
  • A beginner
1054 Unknown column when trying to add manufacturer
« on: December 20, 2016, 06:50:41 am »
Joomla 3.6.4 VM 3.0.18.5

Im trying to add a new product and manufacturer and get the following error. Any idea on why or how to fix this?  ???
An error has occurred.

    1054 Unknown column 'metadesc' in 'field list' SQL=INSERT INTO `#__virtuemart_manufacturers_en_us` (`virtuemart_manufacturer_id`,`mf_name`,`mf_email`,`mf_desc`,`mf_url`,`metadesc`,`metakey`,`customtitle`,`slug`) VALUES ('231','Red Manufacturing','','','','','','','red-manufacturing')

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 2453
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: 1054 Unknown column when trying to add manufacturer
« Reply #1 on: December 20, 2016, 07:06:45 am »
Hello

Metadesc is fairly new, try to update database tables in the tools menu.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.8
Virtuemart 3.4.x
Olympiantheme Hera (customized)

websmith

  • Jr. Member
  • **
  • Posts: 122
  • A beginner
Re: 1054 Unknown column when trying to add manufacturer
« Reply #2 on: December 20, 2016, 07:11:23 am »
Ahhhhh yes. Thank you very much. Worked like a charm. You just saved me a few more grey hairs.  ;D

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 2453
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: 1054 Unknown column when trying to add manufacturer
« Reply #3 on: December 20, 2016, 07:15:23 am »
Nice to hear  :)

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.8
Virtuemart 3.4.x
Olympiantheme Hera (customized)