I've created a monster

swampfox

Member
Have a thread on my forum with nearly 400K posts, I would like to delete it as the storage limit on my hosting account is nearly maxed out, this is partially due to the database size doubling when I switched to XF, but either way, it needs to go

problem is, I cant, memory limit error every time I try, can soft delete it, hard delete, merge parts into another thread, nothing, its just too big

any suggestions?
 
finally got the host to increase my memory allocation, and also edited the application.php file to increased the memory limit within XF

now Im getting this message

Server Error

Mysqli prepare error: Got a packet bigger than 'max_allowed_packet' bytes
  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 661
  5. Zend_Db_Adapter_Abstract->delete() in XenForo/Search/SourceHandler/MySqlFt.php at line 142
  6. XenForo_Search_SourceHandler_MySqlFt->deleteFromIndex() in XenForo/Search/Indexer.php at line 105
  7. XenForo_Search_Indexer->deleteFromIndex() in XenForo/Search/DataHandler/Post.php at line 73
  8. XenForo_Search_DataHandler_Post->_deleteFromIndex() in XenForo/Search/DataHandler/Abstract.php at line 267
  9. XenForo_Search_DataHandler_Abstract->deleteFromIndex() in XenForo/DataWriter/Discussion.php at line 625
  10. XenForo_DataWriter_Discussion->_deleteFromSearchIndex() in XenForo/DataWriter/Discussion.php at line 544
  11. XenForo_DataWriter_Discussion->_indexForSearch() in XenForo/DataWriter/Discussion.php at line 380
  12. XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1295
  13. XenForo_DataWriter->save() in XenForo/Model/Thread.php at line 1301
  14. XenForo_Model_Thread->deleteThread() in XenForo/ControllerPublic/Thread.php at line 791
  15. XenForo_ControllerPublic_Thread->actionDelete() in XenForo/FrontController.php at line 310
  16. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  17. XenForo_FrontController->run() in /home/public_html/index.php at line 13

any advice? I really need this thread gone
 
Top Bottom