MySQL query error [1054]

[jim]

I don't what the hell my sysadmin did, but he said edited the xf_ip_match table idk why but this is the error log any idea? It happens when im trying to upgrade to xenforo v2.2.12

XF\Db\Exception: MySQL query error [1054]: Unknown column 'banned_ip' in 'xf_ip_match' in src\XF\Db\AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src\XF\Db\Mysqli\Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src\XF\Db\Mysqli\Statement.php at line 79
XF\Db\Mysqli\Statement->execute() in src\XF\Db\AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src\XF\Install\InstallHelperTrait.php at line 231
XF\Install\Upgrade\AbstractUpgrade->executeUpgradeQuery() in src\XF\Install\Upgrade\1000051-100rc1.php at line 20
XF\Install\Upgrade\Version1000051->step1() in src\XF\Install\Controller\Upgrade.php at line 179
XF\Install\Controller\Upgrade->actionRun() in src\XF\Mvc\Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src\XF\Mvc\Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src\XF\Mvc\Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src\XF\Mvc\Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src\XF\App.php at line 2483
XF\App->run() in src\XF.php at line 524
XF::runApp() in install\index.php at line 14

 

[jim]

Ahh nevermind I got it fixed by running this

ALTER TABLE xf_ip_match ADD COLUMN banned_ip VARCHAR(50) DEFAULT NULL;