Hello!

I am using a customized shipping plugin, which is generating AWB's on request for a selected order.
After I change something in an order(add or delete products) in VM Invoice and I hit the save button, I get the following error:

Cannot store order shipment. TableVm2OrderShipment: :store failed
Unknown column 'virtuemart_shipmentmethod_id' in 'field list' SQL=UPDATE `mr2_virtuemart_shipment_plg_cargus` SET `virtuemart_order_id`='93',`virtuemart_shipmentmethod_id`='6',`shipment_name`='Livrare cu Cargus',`modified_on`='2014-01-22 15:12:08',`modified_by`='168' WHERE `id`='98'

The changes are saved, the order itself and the order total in VM is displayed correctly(with all the modifications) but the COD(Cash On Delivery) amount(which should be the same with the order total amount) is displaying the original value(without the modifications).

Is there something I can do in order to fix this issue?

Hello,

Before proceeding with the following steps, make sure to backup your database.

Try adding the column named "virtuemart_shipmentmethod_id" to "mr2_virtuemart_shipment_plg_cargus" table in your database with the following SQL query:

Thank you for the answer. I've found the problem in the meantime. The guys who made the plugin named the column shipmentmethod_id instead of virtuemart_shipmentmethod_id. The problem is solved.

So...it is not solved. I am not getting any error regarding the database, but the order total amount it is still not changed. I am using VM2 standard payment module. Inside the table "mr2_virtuemart_payment_plg_standard" the "payment_order_total" column it is not updated after I change something in VMinvoice. :(

Hi,

This seems to be a bug in VM Invoice. We'll fix it in next version.
I'm sorry for the inconvenience.

Hello! Thanks for the answer. I am desperately waiting for the next update. Any temp fix for it? My shipping plugin is generating the AWB's (and the COD value) based on the price form that field and everytime I edit an order I need to edit the order total manually in the database. This wouldn't be a big problem but the store has between 100 and 200 orders a day.