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
:( :(
search?
http://forum.virtuemart.net/index.php?topic=135516
I solved thanks !!
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.
and is there a column searchable in your #__virtuemart_customs table?
check with phpmyadmin etc
No, there isn't a column searchable in my #_virtuemart_customs table.
Hello
This could be related:
http://forum.virtuemart.net/index.php?topic=135777.msg473272#msg473272 (http://forum.virtuemart.net/index.php?topic=135777.msg473272#msg473272)
regards
Jörgen @ Kreativ Fotografi
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?
yes.. manually will work fine
Thank you for your quick reply.
So could you tell me which changes should I do in "#_virtuemart_customs" table?