When I'm trying to clean all massages posted by user I have error. It happened after updating my forum to version 2.2.15
I mean I click on the user SPAM and Xenfore suggest me to clean posts, messages, etc.
If I don't mark user post it's work - but don't clean users posts.
and
I mean I click on the user SPAM and Xenfore suggest me to clean posts, messages, etc.
If I don't mark user post it's work - but don't clean users posts.
Code:
UPDATE `xf_post` SET `position` = ? WHERE `post_id` = 38507
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1264, '22003')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1264, '22003')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(324): XF\Db\AbstractAdapter->query('UPDATE `xf_pos...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1362): XF\Db\AbstractAdapter->update('xf_post', Array, '`post_id` = 385...')
#5 src/XF/Entity/Post.php(765): XF\Mvc\Entity\Entity->fastUpdate('position', -1)
#6 src/addons/XFMG/XF/Entity/Post.php(40): XF\Entity\Post->postHidden(false)
#7 src/XF/Entity/Post.php(547): XFMG\XF\Entity\Post->postHidden()
#8 src/XF/Mvc/Entity/Entity.php(1282): XF\Entity\Post->_postSave()
#9 src/XF/Entity/Post.php(882): XF\Mvc\Entity\Entity->save(true, false)
#10 src/XF/Spam/Cleaner/Post.php(44): XF\Entity\Post->softDelete()
#11 src/XF/Spam/Cleaner.php(156): XF\Spam\Cleaner\Post->cleanUp(Array, NULL)
#12 src/XF/Spam/Cleaner.php(139): XF\Spam\Cleaner->cleanUpContent(Array)
#13 src/XF/Pub/Controller/SpamCleaner.php(47): XF\Spam\Cleaner->cleanUp(Array)
#14 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\SpamCleaner->actionIndex(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:SpamCleaner', 'Index', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\SpamCleaner), NULL)
#16 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\SpamCleaner), NULL)
#17 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#19 src/XF.php(524): XF\App->run()
#20 index.php(20): XF::runApp('XF\\Pub\\App')
#21 {main}
Code:
array(4) {
["url"] => string(29) "/spam-cleaner/username/"
["referrer"] => string(127) "https://domain.com/threads/*******/"
["_GET"] => array(0) {
}
["_POST"] => array(10) {
["_xfToken"] => string(8) "********"
["action_threads"] => string(1) "1"
["delete_messages"] => string(1) "1"
["delete_conversations"] => string(1) "1"
["ban_user"] => string(1) "1"
["check_ips"] => string(1) "1"
["no_redirect"] => string(1) "1"
["_xfRequestUri"] => string(101) "/threads/*****/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}