News:

Looking for documentation? Take a look on our wiki

Main Menu

DB error in product editing

Started by Ryoma, September 11, 2015, 09:50:42 AM

Previous topic - Next topic

Ryoma

Whenever I modify a product or create a new one I get the following error:

"vmError: getCustomEmbeddedProductCustomFields error in query Unknown column 'field.override' 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 `j25_virtuemart_customs` AS c LEFT JOIN `j25_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (294) ORDER BY field.`ordering`,`virtuemart_custom_id` ASC"

It works fine as well but I'd really appreciate getting rid of this alert.

PRO

have you tried the "update tables" function in the tools?

backup your site before doing it