Transactional Errors during the upgrade process - MariaDB.

[Darkness7148]

Just did a dummy run upgrading from SMF 2.019 to 2.1.1 on a test db. Got a few Transactional errors during the upgrade process.

Table storage engine 'InnoDB' does not support the create option 'TRANSACTIONAL=0'



Came back out and ran upgrade again. Seemed to skip that part and then another appeared.



I think this was because they did used to be MyISAM a very long time ago and I converted most of them to INNODB.

Currently on MariaDB 10.3.

It appears to be related to this: https://jira.mariadb.org/browse/MDEV-8733

It does say the issue is ignored in MariaDB 10.4 so I might upgrade to 10.5.

[shawnb61]

That is not being set by the SMF upgrader.

I suspect it's another MariaDB quirk... 

A quick search & it looks like there are some suggestions here:
https://dba.stackexchange.com/questions/213411/how-to-remove-options-from-mariadb-tables

FYI, the upgrader does not alter the storage engine.  You should be fine upgrading a forum with InnoDB tables.