Tickets Fixed XF\Db\InvalidQueryException: xf_nf_tickets_category_field: MySQL query error [1067]: Invalid default value for 'field_id' in src\XF\Db\AbstractStateme

[SeToY]

Upgrading to 2.11.0 has resulted in an unrecoverable state:

XF\Db\InvalidQueryException: xf_nf_tickets_category_field: MySQL query error [1067]: Invalid default value for 'field_id' in src\XF\Db\AbstractStatement.php at line 225

1. XF\Db\AbstractStatement->getException() in src\XF\Db\Mysqli\Statement.php at line 207
2. XF\Db\Mysqli\Statement->getException() in src\XF\Db\Mysqli\Statement.php at line 83
3. XF\Db\Mysqli\Statement->execute() in src\XF\Db\AbstractAdapter.php at line 96
4. XF\Db\AbstractAdapter->query() in src\XF\Db\Schema\AbstractDdl.php at line 158
5. XF\Db\Schema\AbstractDdl->apply() in src\XF\Db\SchemaManager.php at line 157
6. XF\Db\SchemaManager->alterTable() in src\addons\NF\Tickets\Setup.php at line 150
7. NF\Tickets\Setup->applySchemaUpdates() in src\addons\NF\Tickets\Setup.php at line 1106
8. NF\Tickets\Setup->upgrade2110050Step1() in src\XF\AddOn\StepRunnerUpgradeTrait.php at line 124
9. NF\Tickets\Setup->upgradeStepRunner() in src\XF\AddOn\StepRunnerUpgradeTrait.php at line 73
10. NF\Tickets\Setup->upgrade() in src\XF\Admin\Controller\AddOnController.php at line 612
11. XF\Admin\Controller\AddOnController->actionUpgrade() in src\XF\Mvc\Dispatcher.php at line 364
12. XF\Mvc\Dispatcher->dispatchClass() in src\XF\Mvc\Dispatcher.php at line 266
13. XF\Mvc\Dispatcher->dispatchFromMatch() in src\XF\Mvc\Dispatcher.php at line 121
14. XF\Mvc\Dispatcher->dispatchLoop() in src\XF\Mvc\Dispatcher.php at line 63
15. XF\Mvc\Dispatcher->run() in src\XF\App.php at line 2830
16. XF\App->run() in src\XF.php at line 844
17. XF::runApp() in admin.php at line 15

 

[Naz]

What version are you upgrading from?

 

[SeToY]

2.10.8

 

[Naz]

Can you re-download the files for 2.11 and re-upload them, please? After that, try the upgrade again. I've included a hotfix for this.

 

[SeToY]

That fixed it. Thanks for the quick reaction.