Update to Xenforo 2

[Bobsilvio]

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 217

    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 78
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
    XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 222
    XF\Db\AbstractAdapter->insert() in src/XF/Install/Upgrade/2000010-200a.php at line 1376
    XF\Install\Upgrade\Version2000010->step28() in src/XF/Install/Controller/Upgrade.php at line 173
    XF\Install\Controller\Upgrade->actionRun() in src/XF/Mvc/Dispatcher.php at line 321
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 249
    XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
    XF\App->run() in src/XF.php at line 390
    XF::runApp() in install/index.php at line 14

Hi, update Error: Upgrading... 2.0.0 Alpha, Step 27
next:

 

[021]

.this error is not related to XenForo. The problem is one of the add-ons.

 

[TheLaw]

I had these as well. It may relate to having Waindigo (Now ThemeHouse I believe) Custom Fields installed. It didn't matter that all addons were turned off. I assume it could be removed if feasible or here was the fix I found for those who are caught with the same error.

X

Post in thread 'Custom User Fields Permissions'

Oct 11, 2017

Trying to upgrade to XF2 with Version 1.0.1 installed gives the following error:

MySQL query error [1364]: Field 'sedo_perms_input_val' doesn't have a default value

Patch to fix this: https://github.com/Xon/xen_CufPerms/archive/1.0.2.zip

Manual SQL to fix:

alter table xf_user_field
    CHANGE COLUMN `sedo_perms_input_val` sedo_perms_input_val BLOB DEFAULT NULL,
    CHANGE COLUMN `sedo_perms_output_pp_val` sedo_perms_output_pp_val BLOB DEFAULT NULL,
    CHANGE COLUMN `sedo_perms_output_ui_val` sedo_perms_output_ui_val BLOB DEFAULT NULL;

• Xon

•