XF 2.2 XF\Db\InvalidQueryException: xf_post: MySQL query error [1178]:

[AndyB]

Upgrading from 2.1.12 to 2.2.4 and I get this error:





What steps should I do before completing the upgrade?

Thank you.

 

[AndyB]

Looks like the issue is the MySQL version is 8.0.23 and the xf_post is MyISAM.

 

[Mike]

Nothing we do will convert the table types. This is an older guide, but the concept is correct:

Unmaintained - Guide to convert from MyISAM to InnoDB

So, you've found that you have and imported your DB into a new host that had their default engine as MyISAM and they didn't have InnoDB configured for mySQL. First, let's preface this with the warning of BEFORE YOU RUN ANY OF THESE, MAKE SURE...

xenforo.com

The only real caveat is that the example won't include all tables, but outside of the exceptions mentioned, every other table should be InnoDB.

 

[AndyB]

Thank you, Mike. Your advice solved the issue perfectly.