Print Page - 1054 Unknown column when trying to add manufacturer

Title: 1054 Unknown column when trying to add manufacturer
Post by: websmith 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')

Title: Re: 1054 Unknown column when trying to add manufacturer
Post by: Jörgen 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

Title: Re: 1054 Unknown column when trying to add manufacturer
Post by: websmith 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

Title: Re: 1054 Unknown column when trying to add manufacturer
Post by: Jörgen on December 20, 2016, 07:15:23 AM

Nice to hear :)

regards

Jörgen @ Kreativ Fotografi

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Product creation => Topic started by: websmith on December 20, 2016, 06:50:41 AM