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

[Zesix]

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.

 

[Chris D]

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

 

[Paul B]

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.