• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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

#1
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.
 

Brogan

XenForo moderator
Staff member
#3
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?

https://xenforo.com/community/threa...ro-from-shared-hosting-to-azure-cloud.104494/

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.