Author Topic: Using InnoDB to support transactions  (Read 745 times)

yetopen

  • Beginner
  • *
  • Posts: 1
  • A beginner
Using InnoDB to support transactions
« on: June 03, 2020, 10:37:56 am »
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