• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

I've created a monster

#1
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?
 
#6
trying to increase the limit myself failed, I figured as much, will have to contact the host, or move to a new host without disk space limitations
 
#7
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
 
#10
no luck, apparently trying to deleting a thread this size throws a massive query, Im not sure the server Im hosted on can handle it lol