News:

Support the VirtueMart project and become a member

Main Menu

error after updating V VM 3.0.16 3.0.18

Started by giriga, October 01, 2016, 00:37:05 AM

Previous topic - Next topic

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

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

giriga


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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

tb1408

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

Jörgen

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

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

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

tb1408

Thank you for your quick reply.

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