Text only | Text with Images

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: Ghost on June 03, 2016, 12:19:32 PM

Title: 3.0.17 - new manufacturer table columns missing on multilingual site
Post by: Ghost on June 03, 2016, 12:19:32 PM
After installing 3.0.17, new #__virtuemart_manufacturers_xx_yy table columns are not created for secondary languages (on multilingual sites). Saving a new manufacturer for first time works fine, but saving for another language gives a mysql error:
Code Select
Unknown column 'metadesc' in 'field list' SQL=INSERT INTO `#__virtuemart_manufacturers_it_it` (`virtuemart_manufacturer_id`,`mf_name`,`mf_email`,`mf_desc`,`mf_url`,`metadesc`,`metakey`,`customtitle`,`slug`) VALUES ('1','ACME','','','','','','','acme')

VM 3.0.17, J 3.5.1.
Title: Re: 3.0.17 - new manufacturer table columns missing on multilingual site
Post by: Studio 42 on June 03, 2016, 18:08:51 PM
Manually add missing field it in your table if you need it quickly. Check your #__virtuemart_manufacturers_en_gb table.
Title: Re: 3.0.17 - new manufacturer table columns missing on multilingual site
Post by: franzpeter on June 06, 2016, 12:34:29 PM
The more simple way would be to go to Tools & Migration and choose the button: Install or if necessary update tables!
Title: Re: 3.0.17 - new manufacturer table columns missing on multilingual site
Post by: Milbo on June 06, 2016, 12:55:39 PM
Usually yes, but there is a small error. http://forum.virtuemart.net/index.php?topic=133862.msg467143#msg467143
Text only | Text with Images