error after upgrade

[raunhar]

AFter upgrading the VM from 3.0.12 to 3.0.14, the site is showing:
1054 - Unknown column 'c.is_input' 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 `#__virtuemart_customs` AS c LEFT JOIN `#__virtuemart_product_customfields` AS field ON c.`virtuemart_custom_id` = field.`virtuemart_custom_id` WHERE `virtuemart_product_id` IN (143) AND c.`published` = "1" ORDER BY field.`ordering`,`virtuemart_custom_id` ASC

How to correct it.

[GJC Web Design]

in Tools tried the custom fields table updater things?

is is_input  in  #__virtuemart_customs?

back up first

[raunhar]

Did all that (two steps).
The upgrade was tried on the backup site only. The original is working properly

[raunhar]

At the back end, the same error is showing under SHOP.
Rest all functions are working.

[GJC Web Design]

is is_input  in  #__virtuemart_customs?

[raunhar]

No.

[GJC Web Design]

then just recreate it - have u tried the table updater etc

if doesn't work just make it manually

these are the fields you should have

[raunhar]

The table and all fields are there.

[Jörgen]

This sais otherwise:

1054 - Unknown column 'c.is_input'

`#__virtuemart_product_customfields`

Where are You looking ?

regards

Jörgen @ Kreativ Fotografi

[GJC Web Design]

if u want help with this we expect u to be more pro-active!

why at each step must we ask questions for u to give one word answers.. come on.. for who's benefit is this thread?

first you say "no" - then u say all there..  so which is it?

[jenkinhill]

And with over 200 posts in this forum we would assume that you are well educated in VirtueMart, how it works and how to use it. If you really do have all these difficulties then maybe you should emply a developer to help rather than rely on the goodwill of others to attempt to provide free support here.

[raunhar]

I was able to do it.
Did a clean install of joomla. Through phpmyadmin, added old database (VM2).
Installed VM 3.0.14 twice and it was done.

Sorry for the trouble.