XF 2.0 Error when upgrading to Xenforo 2

[Pixel Squad Ltd]

Can anyone help with the following error. I am trying to upgrade from Xenforo 1 to Xenforo 2.

XF\Db\Exception: MySQL query error [1364]: Field 'sedo_perms_input_val' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 212
1.XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
2.XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 69
3.XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 69
4.XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
5.XF\Db\AbstractAdapter->insert() in src/XF/Install/Upgrade/2000010-200a.php at line 1375
6.XF\Install\Upgrade\Version2000010->step28() in src/XF/Install/Controller/Upgrade.php at line 168
7.XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 249
8.XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
9.XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
10.XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1879
11.XF\App->run() in src/XF.php at line 328
12.XF::runApp() in install/index.php at line 14

Thanks in advance,
Carl

 

[Chris D]

It seems as though your xf_user_field table has an additional column added to it, and it doesn't have a default value. This value will have been added by an add-on. We strongly recommend that no developer ever adds a column to any core table unless it has a default value or it is nullable.

With that in mind, the only real way to continue through the upgrade now is to fix that column.

It looks like this actually cropped up already and a solution was posted here:

https://xenforo.com/community/threads/custom-user-fields-permissions.94617/post-1181974