Fixed v1.1.8 -> 2.2.0 Beta 2 Upgrade - Field 'advanced' doesn't have a default value

[Mouth]

Affected version

2.2.0 B2

Upgrading ES v1.1.8 to v2.2.0 B2 ( upload/ dir contents copied to root of test installation ) and get the following error when attempting the manual upgrade via /admin.php?add-ons/XFES/upgrade ...

XF\Db\Exception: MySQL query error [1364]: Field 'advanced' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 228

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
4. XF\Db\AbstractAdapter->query() in src/XF/Install/InstallHelperTrait.php at line 229
5. XF\AddOn\AbstractSetup->executeUpgradeQuery() in src/XF/AddOn/AbstractSetup.php at line 90
6. XF\AddOn\AbstractSetup->query() in src/addons/XFES/Setup.php at line 58
7. XFES\Setup->upgrade2000010Step1() in src/XF/AddOn/StepRunnerUpgradeTrait.php at line 122
8. XFES\Setup->upgradeStepRunner() in src/XF/AddOn/StepRunnerUpgradeTrait.php at line 71
9. XFES\Setup->upgrade() in src/XF/Admin/Controller/AddOn.php at line 581
10. XF\Admin\Controller\AddOn->actionUpgrade() in src/XF/Mvc/Dispatcher.php at line 350
11. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
12. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
13. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2298
15. XF\App->run() in src/XF.php at line 459
16. XF::runApp() in admin.php at line 13

Unable to proceed with upgrade, have disabled the add-on for now.

 

[XF Bug Bot]

Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XF release (2.2.0 Beta 3).

Change log:

Properly set advanced flag for XFES options

There may be a delay before changes are rolled out to the XenForo Community.