Upgrade Error: 3.8.4 pl2 to 4.0.1 Suite - mysql error

[kontrabass]

Same problem here. The easy fix (for me) was to use MyIsam instead of Innodb. The change is easy.

In the file: install/functions_installupgrade.php

find the function get_high_concurrency_table_engine($db)

Just add this line at the top of the function:


return 'MyISAM';

This way, InnoDB is never chosen.

Once I did this, all of the problems described in this thread went away.

Thanks for the tip, but what if we want InnoDB for high concurrency tables? I can change table engines with no problem in phpMyAdmin, so perhaps someone could post a list of all tables that should be InnoDB?

[StevenTN]

Trevor: The problem is traced to an improperly deleted InnoDB table (usually due to a botched upgrade in the past). InnoDB is a pain in the rear, and would result in errors that you so describe. I know this from being involved with MySQL for so long.