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.
in Tools tried the custom fields table updater things?
is is_input in #__virtuemart_customs?
back up first
Did all that (two steps).
The upgrade was tried on the backup site only. The original is working properly
At the back end, the same error is showing under SHOP.
Rest all functions are working.
is is_input in #__virtuemart_customs?
No.
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
The table and all fields are there.
This sais otherwise:
Quote1054 - Unknown column 'c.is_input'
Quote`#__virtuemart_product_customfields`
Where are You looking ?
regards
Jörgen @ Kreativ Fotografi
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?
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.
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.