Paypal TLS 1.2 problem

Started by andika, June 26, 2018, 04:20:14 AM

andika

Quote from: d4f on July 02, 2018, 09:08:52 AM
To my knowledge you can't alter tables without committing the changes, so you never have synchronious conversion.
I would recommend setting your Hostbill to maintenance and doing it manually, but here are the SQL commands to alter tables:

ALTER TABLE t1 ENGINE = InnoDB;
ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;


Note that some tables must be in MyISAM and some in INNODB. Attached is a list of how it should look like.
You can ignore the tables that do not start with hb_, they are from custom modules.

None of the MyISAM table names are present on my server.

andika