XF 2.2 Field 'permission_entry_id' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 228

[Degrinch]

So i just took a perfect dump, all files and all db, swapped host, uploaded, and attempted to update from a previous version of XF to the latest... and this happens.

XF\Db\Exception: MySQL query error [1364]:

    XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
    XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    XF\Db\AbstractAdapter->query() in src/XF/Install/InstallHelperTrait.php at line 503
    XF\Install\Upgrade\AbstractUpgrade->applyGlobalPermission() in src/XF/Install/Upgrade/2020010-220a.php at line 999
    XF\Install\Upgrade\Version2020010->step29() in src/XF/Install/Controller/Upgrade.php at line 175
    XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 350
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
    XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
    XF\App->run() in src/XF.php at line 488
    XF::runApp() in install/index.php at line 14

What is wrong exactly? Better yet, how do I fix this without having to use my own brain at this time?

 

[Degrinch]

Ok... well I seem to have fixed this by deleting the DB and re installing both DIR and DB contents.