VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: antonino78 on November 13, 2015, 19:15:05 PM

Title: Error 1054 vm 3.0.12
Post by: antonino78 on November 13, 2015, 19:15:05 PM
Hello,
vm I upgraded to version 3.0.12
Now when you complete the order I get the error:
1054  Unknown column 'cost_min_transaction' in 'field list' SQL=INSERT INTO `jm7fo_virtuemart_payment_plg_standard` (`id`,`virtuemart_order_id`,`order_number`,`virtuemart_paymentmethod_id`,`payment_name`,`payment_order_total`,`payment_currency`,`email_currency`,`cost_per_transaction`,`cost_min_transaction`,`cost_percent_total`,`tax_id`,`created_on`,`created_by`,`modified_on`,`modified_by`)

Help me please ????  :'( :'(
Mine is an online site
Title: Re: Error 1054 vm 3.0.12
Post by: GJC Web Design on November 13, 2015, 21:23:31 PM
did u also upgrade your AIO?

checked the table to see if cost_min_transaction is thereß
Title: Re: Error 1054 vm 3.0.12
Post by: antonino78 on November 14, 2015, 11:25:10 AM
Hello,
the problem was to the table: jm7fo_virtuemart_payment_plg_standard
Missing some new columns added in version 3.0.12
Title: Re: Error 1054 vm 3.0.12
Post by: d0ublezer0 on November 17, 2015, 14:41:38 PM
solution - go to your payment variant open it and save it.
vm will add necessary fields
Title: Re: Error 1054 vm 3.0.12
Post by: Milbo on November 18, 2015, 21:56:49 PM
Perfect :-) that is the repair mechanism,

"open the method using the plugin and store, if you get trouble, disable the debug plugin of joomla and other error reporting to be able to store the method with the plugin."