error after updating V VM 3.0.16 3.0.18

[giriga]

An error has occurred.
1054 Unknown column 'metadesc' in 'field list' SQL=INSERT INTO `#__virtuemart_manufacturers_en_gb` (`virtuemart_manufacturer_id`,`mf_name`,`mf_email`,`mf_desc`,`mf_url`,`metadesc`,`metakey`,`customtitle`,`slug`) VALUES ('38','Pezzana','','','','','','','pezzana')
Return to Control Panel

[GJC Web Design]

search?

http://forum.virtuemart.net/index.php?topic=135516

[giriga]

I solved thanks !!

[tb1408]

Hello everyone!

After updating from VM 3.0.16 to 3.0.18 I'm getting an 1054 error when trying to visit a new category layout page (created after updating) and to use VM product search module.
The full error reports are the following:
Unknown column 'searchable' in 'where clause' SQL=SELECT c.* FROM #__virtuemart_customs as c INNER JOIN #__virtuemart_product_customfields as pc on (c.virtuemart_custom_id=pc.virtuemart_custom_id) INNER JOIN #__virtuemart_product_categories as cat ON (pc.virtuemart_product_id=cat.virtuemart_product_id) WHERE virtuemart_category_id="334" and searchable="1" and (field_type="S" or field_type="P") GROUP BY c.virtuemart_custom_id

Unknown column 'searchable' in 'where clause' SQL=SELECT c.* FROM #__virtuemart_customs as c WHERE searchable="1" and (field_type="S" or field_type="P") GROUP BY c.virtuemart_custom_id

I've tried to use the table updater (with "Enable database Update tools" turned on), as you suggest here: http://forum.virtuemart.net/index.php?topic=135516
but nothing has changed.

I've also read this relevant topic http://forum.virtuemart.net/index.php?topic=135329.0 about PDO driver without finding a clear solution.

I use Joomla 3.6.2.

I would appreciate your help.

[GJC Web Design]

and is there a column searchable in your #__virtuemart_customs table?
check with phpmyadmin etc

[tb1408]

No, there isn't a column searchable in my #_virtuemart_customs table.

[Jörgen]

Hello

This could be related:
http://forum.virtuemart.net/index.php?topic=135777.msg473272#msg473272

regards

Jörgen @ Kreativ Fotografi

[tb1408]

I've used the tableupdater and this error occured:
1060 Duplicate column name 'custom_desc' SQL=ALTER TABLE `#__virtuemart_customs` CHANGE COLUMN `custom_field_desc` `custom_desc` char(255) COMMENT 'description or unit'

Could I manually do the appropriate changes in "#__virtuemart_customs" table?
Or is it possible to fix the problem by re-installing VM 3.0.18? In this case would my products be deleted?

[GJC Web Design]

yes.. manually will work fine

[tb1408]

Thank you for your quick reply.

So could you tell me which changes should I do in "#_virtuemart_customs" table?