XF 1.5 Getting an error regarding rebuild caches.

[andrewkm]

I recently tried to message all members on our forum.

After a couple thousand, I got an error. Now I have this stuck in my ACP:

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

When I click it it does the following:

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

Server Error

Mysqli statement execute error : Column 'user_id' cannot be null

[LIST=1]
[*]Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
[*]Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
[*]Zend_Db_Adapter_Abstract->query() in XenForo/Model/Conversation.php at line 860
[*]XenForo_Model_Conversation->insertConversationRecipient() in SV/ConvEss/XenForo/Model/Conversation.php at line 3654
[*]SV_ConvEss_XenForo_Model_Conversation->insertConversationRecipient() in XenForo/DataWriter/ConversationMaster.php at line 387
[*]XenForo_DataWriter_ConversationMaster->_postSave() in SV/ConvEss/XenForo/DataWriter/ConversationMaster.php at line 51
[*]SV_ConvEss_XenForo_DataWriter_ConversationMaster->_postSave() in SV/ConversationImprovements/XenForo/DataWriter/ConversationMaster.php at line 87
[*]SV_ConversationImprovements_XenForo_DataWriter_ConversationMaster->_postSave() in XenForo/DataWriter.php at line 1423
[*]XenForo_DataWriter->save() in XenForo/Deferred/UserMessage.php at line 127
[*]XenForo_Deferred_UserMessage->_sendMessage() in XenForo/Deferred/UserMessage.php at line 62
[*]XenForo_Deferred_UserMessage->execute() in XenForo/Model/Deferred.php at line 295
[*]XenForo_Model_Deferred->runDeferred() in XenForo/Model/Deferred.php at line 429
[*]XenForo_Model_Deferred->_runInternal() in XenForo/Model/Deferred.php at line 374
[*]XenForo_Model_Deferred->run() in XenForo/ControllerAdmin/Tools.php at line 159
[*]XenForo_ControllerAdmin_Tools->actionRunDeferred() in XenForo/FrontController.php at line 369
[*]XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
[*]XenForo_FrontController->run() in /var/www/html/forum/admin.php at line 13
[/LIST]

I can't even get into my rebuild caches ACP page:

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

To view this content we will need your consent to set third party cookies.
For more detailed information, see our cookies page.

Accept third party cookies

If you can help in any way I'd greatly appreciate it.

 

[andrewkm]

This thread can be closed. Problem has been fixed.

I ran the following queries for those who may have this problem in the future:

DELETE
FROM xf_data_registry
WHERE data_key = 'deferredRun';

DELETE
FROM xf_deferred;

PS: Thank you Xenforo customer ticket support, great service!