XF 1.2 Workaround for orphaned posts?

[Thierry Martin]

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?

 

[Paul B]

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?

 

[Thierry Martin]

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

 

[Mike]

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.)

 

[Mike]

You posted about that error here: http://xenforo.com/community/threads/an-exception-occurred-mysqli-statement-execute-error.70097/ The short answer is that it appears to be a server issue/MySQL bug.

 

[Thierry Martin]

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.

 

[Thierry Martin]

The entire deletion is reflected in the forum stats count the only place the 20K orphaned posts appear is for that user's stats.

 

[Mike]

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).

 

[Thierry Martin]

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.