Author Topic: error after updating V VM 3.0.16 3.0.18  (Read 5444 times)

giriga

  • Jr. Member
  • **
  • Posts: 154
  • A beginner
error after updating V VM 3.0.16 3.0.18
« on: October 01, 2016, 00:37:05 am »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10631
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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

  • Jr. Member
  • **
  • Posts: 154
  • A beginner
Re: error after updating V VM 3.0.16 3.0.18
« Reply #2 on: October 01, 2016, 09:28:11 am »
I solved thanks !!

tb1408

  • Beginner
  • *
  • Posts: 4
  • A beginner
Re: error after updating V VM 3.0.16 3.0.18
« Reply #3 on: October 21, 2016, 00:24:00 am »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10631
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: error after updating V VM 3.0.16 3.0.18
« Reply #4 on: October 21, 2016, 01:01:49 am »
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
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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

  • Beginner
  • *
  • Posts: 4
  • A beginner
Re: error after updating V VM 3.0.16 3.0.18
« Reply #5 on: October 21, 2016, 09:48:39 am »
No, there isn't a column searchable in my #_virtuemart_customs table.

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3911
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: error after updating V VM 3.0.16 3.0.18
« Reply #6 on: October 21, 2016, 11:16:10 am »
Hello

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

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

tb1408

  • Beginner
  • *
  • Posts: 4
  • A beginner
Re: error after updating V VM 3.0.16 3.0.18
« Reply #7 on: October 21, 2016, 14:14:03 pm »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10631
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.8.8
Re: error after updating V VM 3.0.16 3.0.18
« Reply #8 on: October 21, 2016, 14:54:22 pm »
yes.. manually will work fine
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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

  • Beginner
  • *
  • Posts: 4
  • A beginner
Re: error after updating V VM 3.0.16 3.0.18
« Reply #9 on: October 21, 2016, 15:12:54 pm »
Thank you for your quick reply.

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