News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Using InnoDB to support transactions

Started by yetopen, June 03, 2020, 10:37:56 AM

Previous topic - Next topic

yetopen

Hello,
we are importing orders through Amazon MWS in Virtuemart but we need to rollback the insertions/updates in case of an error. Since MyISAM does not support transactions we'd like to move the engine to InnoDB, are there known issues in VM reguarding this or should it be safe? I tried to search in the forum but didn't find much.

The tables we are touching are:

  • virtuemart_orders
  • virtuemart_payment_plg_standard
  • virtuemart_shipment_plg_rules_shipping_advanced
  • virtuemart_order_userinfos
  • virtuemart_order_items
  • virtuemart_order_calc_rules

We are on VirtueMart 3.0.12

Thank you,
Marco