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

Discussion in 'Troubleshooting and Problems' started by Zesix, Nov 24, 2015.

  1. Zesix

    Zesix Member

    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.
  2. Chris D

    Chris D XenForo Developer Staff Member

    It should be an auto increment, again. It's the xf_mail_queue table.
  3. Brogan

    Brogan 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:
    Using phpMyAdmin to dump and restore isn't recommended as it frequently results in database corruption.

Share This Page