XF 2.1 [SOLVED] Errors after host migrated database to a different server.

[PeterG]

I'm getting the following error after my host migrated the database server.

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

 

[PeterG]

Issue was a bad restore from a database backup.