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

XF 1.2 Workaround for orphaned posts?

Discussion in 'Troubleshooting and Problems' started by Thierry Martin, Mar 11, 2014.

  1. Deleted a node with 100K posts by a user (RSS feed, nobody would post that much) but only 80K posts were deleted. Now that user shows 20K posts, but I cannot access the posts since they are in a disappeared node. The user shows 20K posts but no posts are listed in show all content or show all threads. I have rebuilt all caches.

    Would creating a new node, changing the ID to the deleted node, and then re-deleting the node take care of the remaining 20K posts? Would this work, and is it safe?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    That should resolve it but I am more interested to determine why the posts were not deleted when you deleted the node.
    Did you encounter any errors or timeouts when you deleted the node?
  3. When I came back to the computer in the morning the "Processing... Deleting... Threads (50,123/110,789)" screen was gone and there was the run-deferred page showing this:

    An exception occurred: Mysqli statement execute error : Prepared statement needs to be re-prepared in /var/www/vhosts/onlinetradersforum.com/httpdocs/library/Zend/Db/Statement/Mysqli.php on line 214

    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.php at line 219
    XenForo_Model->fetchAllKeyed() in XenForo/Model/RoutePrefix.php at line 41
    XenForo_Model_RoutePrefix->getPrefixesByRouteType() in XenForo/Model/RoutePrefix.php at line 54
    XenForo_Model_RoutePrefix->getPrefixesForRouteCache() in XenForo/Link.php at line 479
    XenForo_Link::_loadHandlerInfoForGroup() in XenForo/Link.php at line 396
    XenForo_Link::_getPrefixHandler() in XenForo/Link.php at line 362
    XenForo_Link::_buildLink() in XenForo/Link.php at line 93
    XenForo_Link::buildPublicLink() in XenForo/Dependencies/Admin.php at line 195
    XenForo_Dependencies_Admin->getEffectiveContainerParams() in XenForo/FrontController.php at line 612
    XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
    XenForo_FrontController->run() in /var/www/vhosts/onlinetradersforum.com/httpdocs/admin.php at line 13
    Last edited: Mar 11, 2014
  4. Mike

    Mike XenForo Developer Staff Member

    Is it possible that the post count is simply wrong? (Not sure why - could be an issue in XF, could be related to changes regarding whether posts count in forum, could be manually edited, could be an issue pre import if applicable.)
  5. Mike

    Mike XenForo Developer Staff Member

  6. yes it was the same error I received after successfully importing from vBulletin.

    I spent hours watching the progress of the deletion and the process should still have been going on when I came back to the computer, it should have taken another 5 or 6 hours. I believe the post count is correct.
  7. The entire deletion is reflected in the forum stats count the only place the 20K orphaned posts appear is for that user's stats.
  8. Mike

    Mike XenForo Developer Staff Member

    The admin CP should show that there's a manual deferred process still running and that you can restart it (or if you still have the window with that error open, you can probably refresh).
  9. That did happen during the initial import, there was that error page and I refreshed it and it continued. This time there was just that error page and no way to restart it.

Share This Page