I had trouble with the upgrade.php found in the 7.02.07 package, specifically, the following errors occurred during upgrade:
BLOB, TEXT, GEOMETRY or JSON column 'userlog_value_new' can't have a default value
BLOB, TEXT, GEOMETRY or JSON column 'panel_url_list' can't have a default value
Database upgrade complete.
As the error states, the TEXT mySQL type cannot have a default - however, there is some confusion over this based on your OS (i'm running PHPFusion on IIS / windows).
May i suggest the the v7 upgrade.php be changed to use VARCHAR(4000) instead of TEXT on these 3 lines:
Lines 265 & 266:
userlog_value_new VARCHAR(4000) NOT NULL DEFAULT '',
userlog_value_old VARCHAR(4000) NOT NULL DEFAULT '',
And again on line 292:
$result = dbquery("ALTER TABLE ".DB_PANELS." ADD (panel_url_list VARCHAR(4000) NOT NULL DEFAULT '', panel_restriction TINYINT(1) UNSIGNED NOT NULL DEFAULT '0')");
By making this change I was able to upgrade normally and continue with the V9 upgrade, otherwise, the panel & log tables where broken when the above statements failed.