XF 1.5 Field 'mail_queue_id' doesn't have a default value

Mysqli statement execute error : Field 'mail_queue_id' doesn't have a default value
  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/Model/MailQueue.php at line 12
  5. XenForo_Model_MailQueue->insertMailQueue() in XenForo/Mail.php at line 223
  6. XenForo_Mail->queue() in XenForo/Model/Conversation.php at line 955
  7. XenForo_Model_Conversation->insertConversationAlert() in XenForo/DataWriter/ConversationMaster.php at line 391
  8. XenForo_DataWriter_ConversationMaster->_postSave() in XenForo/DataWriter.php at line 1409
  9. XenForo_DataWriter->save() in XenForo/ControllerPublic/Conversation.php at line 625
  10. XenForo_ControllerPublic_Conversation->actionInsert() in XenForo/FrontController.php at line 351
  11. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  12. XenForo_FrontController->run() in D:/home/site/wwwroot/index.php at line 13
Any idea what might cause this? Also, if mail_queue_id is supposed to be auto-increment, please let me know what database table to look up because I've had a weird thing where auto-increment values aren't auto-increment in my database for some reason.


XenForo moderator
Staff member
Did all of the problems you are encountering with errors of this nature start after you moved your installation from shared hosting to Azure cloud?


Something has clearly changed if it was all working fine before.

I suspect this could be related:
I've exported my database from phpmyadmin
Using phpMyAdmin to dump and restore isn't recommended as it frequently results in database corruption.