Joomla 2.5->3.4 migration: VM custom fields problem

[bolando]

Hello,

I have successfully migrated my Joomla and Virtuemart to 3.0.8. All products and categories are migrated in the backend panel.

But my VM shop doesn't work as the SQL problem appears:
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 `new_virtuemart_customs` AS c LEFT JOIN `new_virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (4) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC

I tried to use the migration tools in VM3 panel, but it didn't help.

Can anybody help me?

[thomasharris]

Not sure if you still need it but I just had the same situation updating a clients site, it seems when you update the customer notes column doesn't exist for the _virtuemart_order_userinfos table and needs to be manually added to the table, you can confirm this by installing Virtuemart3 to a new site and it will show you the column that doesn't exists.