[Solved] Orders module upgrade fails 1.5.3 to 1.10

[replytomk3]

Hello

I was upgrading a site. 1.6.5 to 1.8.1.

At the same time, I was upgrading all modules by grabbing latest versions from Forge.

Out of a dozen modules, Orders came with an error when pressing the "Upgrade" link after .xml site upload to module manager.

INSERT INTO cms_module_orders_payments (order_id,amount,payment_date,method,status,gateway,txn_id,cc_expiry,cc_number,cc_verifycode) VALUES ('75','199.77','2009-09-23 15:24:32','online','payment_approved','PaypalGateway','4X334144LX190294B',NULL,NULL,NULL)
Table 'emarfin_cms2.cms_module_orders_payments' doesn't exist

[replytomk3]

CMSMS was connected to the database with a read+write only access. This operation requires full access to the database. Hope to help those who come across this.