News:

Looking for documentation? Take a look on our wiki

Main Menu

Getting error after upgrade?

Started by peaceandlove, February 08, 2015, 05:44:08 AM

Previous topic - Next topic

peaceandlove

I am getting this after  i upgrade vm2 to vm3


Install or if necessary update tables

QuoteError: 1054
Unknown column 'c.custom_desc' in 'field list' SQL=SELECT c.`virtuemart_custom_id`, c.`custom_parent_id`, c.`virtuemart_vendor_id`, c.`custom_jplugin_id`, c.`custom_element`, c.`admin_only`, c.`custom_title`, c.`show_title` , c.`custom_tip`, c.`custom_value`, c.`custom_desc`, c.`field_type`, c.`is_list`, c.`is_hidden`, c.`is_cart_attribute`, c.`is_input`, c.`layout_pos`, c.`custom_params`, c.`shared`, c.`published`, c.`ordering`, field.`virtuemart_customfield_id`, field.`virtuemart_product_id`, field.`customfield_value`, field.`customfield_price`, field.`customfield_params`, field.`published` as fpublished, field.`override`, field.`disabler`, field.`ordering` FROM `b50d4_virtuemart_customs` AS c LEFT JOIN `b50d4_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (165) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC


http://www.beddinghotline.com/beddinghotline/features/accessories/hardware.html

what the issue

GJC Web Design

QuoteInstall or if necessary update tables

do u mean you clicked this?

try renaming b50d4_virtuemart_customs table field from custom_desc  to custom_field_desc
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