Database upgrade impossible after upgrade to oneiris

[Graham Smith]

I recently upgraded my natty box to oneiris which caused an upgrade of Mantis from 1.1.8 to 1.2.8. After the upgrade I Mantis was unable to query the database complaining about missing columns and tables. I guessed that it must require a schema upgrade so I loaded the /admin/install.php page, entered the required username and password details and clicked the install upgrade button.

That took me to a page that does some preliminary checks one of which is checking that the MySQL database version Mantis is running against is correct. I'm running MySQL 5.1.58 but it still triggered the "BAD MySQL 4.1.0 or later is required for installation." message. This appears to be the same as this bug http://www.mantisbt.org/bugs/view.php?id=12927 only that was marked as fixed in Mantis 1.2.6.

Since I was sure I was working with a supported version of MySQL I hacked the install.php file by commenting out line 599

$t_error = 'MySQL 4.1.0 or later is required for installation. '.$error_go_back;

which performs the version check.