Fixed MariaDB 10.1.x - Incorrect integer value: '' for column 'content_id' at row 1

[Chris D]

The updated files will be available in the next version.

 

[PrinceReborn]

Sorry to bump this thread but this is the only one I could see relating to this issue. We are currently getting this issue about 90% of the time when trying to delete posts. Both soft delete and permanent deleting often fails and shows the error pasted below. We are using Xenforo 1.5.10, ElasticSearch 2.4.1, MariaDB 5.5.50


Server Error
Mysqli statement execute error : Incorrect integer value: '' for column 'content_id' at row 1

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 XenES/Model/Elasticsearch.php at line 301
4. XenES_Model_Elasticsearch->logFailedIndex() in XenES/Search/SourceHandler/ElasticSearch.php at line 1012
5. XenES_Search_SourceHandler_ElasticSearch->_logFailedIndex() in XenES/Search/SourceHandler/ElasticSearch.php at line 113
6. XenES_Search_SourceHandler_ElasticSearch->deleteFromIndex() in XenForo/Search/Indexer.php at line 105
7. XenForo_Search_Indexer->deleteFromIndex() in XenForo/Search/DataHandler/Post.php at line 99
8. XenForo_Search_DataHandler_Post->_deleteFromIndex() in XenForo/Search/DataHandler/Abstract.php at line 315
9. XenForo_Search_DataHandler_Abstract->deleteFromIndex() in XenForo/DataWriter/DiscussionMessage.php at line 985
10. XenForo_DataWriter_DiscussionMessage->_deleteFromSearchIndex() in XenForo/DataWriter/DiscussionMessage.php at line 743
11. XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 584
12. XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1423
13. XenForo_DataWriter->save() in XenForo/Model/Post.php at line 1216
14. XenForo_Model_Post->deletePost() in XenForo/ControllerPublic/Post.php at line 351
15. XenForo_ControllerPublic_Post->actionDelete() in XenForo/FrontController.php at line 351
16. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
17. XenForo_FrontController->run() in /var/www/html/forum/index.php at line 13

 

[PrinceReborn]

Sorry to bump this thread but this is the only one I could see relating to this issue. We are currently getting this issue about 90% of the time when trying to delete posts. Both soft delete and permanent deleting often fails and shows the error pasted below. We are using Xenforo 1.5.10, ElasticSearch 2.4.1, MariaDB 5.5.50


Server Error
Mysqli statement execute error : Incorrect integer value: '' for column 'content_id' at row 1

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 XenES/Model/Elasticsearch.php at line 301
4. XenES_Model_Elasticsearch->logFailedIndex() in XenES/Search/SourceHandler/ElasticSearch.php at line 1012
5. XenES_Search_SourceHandler_ElasticSearch->_logFailedIndex() in XenES/Search/SourceHandler/ElasticSearch.php at line 113
6. XenES_Search_SourceHandler_ElasticSearch->deleteFromIndex() in XenForo/Search/Indexer.php at line 105
7. XenForo_Search_Indexer->deleteFromIndex() in XenForo/Search/DataHandler/Post.php at line 99
8. XenForo_Search_DataHandler_Post->_deleteFromIndex() in XenForo/Search/DataHandler/Abstract.php at line 315
9. XenForo_Search_DataHandler_Abstract->deleteFromIndex() in XenForo/DataWriter/DiscussionMessage.php at line 985
10. XenForo_DataWriter_DiscussionMessage->_deleteFromSearchIndex() in XenForo/DataWriter/DiscussionMessage.php at line 743
11. XenForo_DataWriter_DiscussionMessage->_indexForSearch() in XenForo/DataWriter/DiscussionMessage.php at line 584
12. XenForo_DataWriter_DiscussionMessage->_postSave() in XenForo/DataWriter.php at line 1423
13. XenForo_DataWriter->save() in XenForo/Model/Post.php at line 1216
14. XenForo_Model_Post->deletePost() in XenForo/ControllerPublic/Post.php at line 351
15. XenForo_ControllerPublic_Post->actionDelete() in XenForo/FrontController.php at line 351
16. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
17. XenForo_FrontController->run() in /var/www/html/forum/index.php at line 13

Issue has been resolved. The problem was regarding disk space on the partition being higher than 90% and ElasticSearch doing some funky stuff with shards. Freeing up space fixed the issue.