Post check [Deleted]

AndyB

Well-known member
AndyB submitted a new resource:

Post check - Verifies each post has a valid thread.

Premium upgrade:

This XF2 add-on along with the entire collection can be purchased for $35.00 USD. Your Premium upgrade will allow you to download as many XF2 add-ons as you like for one year. Please see the entire collection located in the Resources area at this URL:

https://www.xf2addons.com/

Description:

Verifies each post has a valid thread.

This add-on will find posts which do not have valid thread numbers. It will allow deletion of these orphaned posts...

Read more about this resource...
 
@AndyB Getting Server error log.

Code:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'post_id' in 'where clause' src/XF/Db/AbstractStatement.php:217

Generated by: Nirjonmela Aug 16, 2019 at 10:24 PM

Stack trace

                DELETE FROM xf_deletion_log
                WHERE content_type = ?
                AND post_id = ?
            
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/addons/Andy/PostCheck/Pub/Controller/PostCheck.php(84): XF\Db\AbstractAdapter->query('
              ...', Array)
#5 src/XF/Mvc/Dispatcher.php(321): Andy\PostCheck\Pub\Controller\PostCheck->actionDelete(Object(XF\Mvc\ParameterBag))
#6 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('Andy\\PostCheck\\...', 'Delete', Object(XF\Mvc\RouteMatch), Object(Andy\PostCheck\Pub\Controller\PostCheck), NULL)
#7 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Andy\PostCheck\Pub\Controller\PostCheck), NULL)
#8 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#9 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#10 src/XF.php(390): XF\App->run()
#11 index.php(20): XF::runApp('XF\\Pub\\App')
#12 {main}

Request state

array(4) {
  ["url"] => string(17) "/postcheck/delete"
  ["referrer"] => string(32) "/postcheck"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
That 'deleteorphanedposts' gives me a 'page not found' error, the post check did find some non valid post's
 
Top Bottom