XF 2.2 Спам! Очистка всего что связано с конкретным пользователем. Ошибка очистки.

[bianchi]

Всем привет! Обновился до версии 2.2.15 и теперь ловлю ошибки... Подскажите, что нужно смотреть или как пофиксить ошибку? Ошибка возникает тогда, коогда на юзере нажимаешь спам и пытаешься очистить все. Похоже на то, что это связано именно с сообщениями "очистить сообщения спамера"

Код ошибки

XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'position' at row 1 in src/XF/Db/AbstractStatement.php at line 230

    XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
    XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 79
    XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 324
    XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1362
    XF\Mvc\Entity\Entity->fastUpdate() in src/XF/Entity/Post.php at line 765
    XF\Entity\Post->postHidden() in src/addons/XFMG/XF/Entity/Post.php at line 40
    XFMG\XF\Entity\Post->postHidden() in src/XF/Entity/Post.php at line 547
    XF\Entity\Post->_postSave() in src/XF/Mvc/Entity/Entity.php at line 1282
    XF\Mvc\Entity\Entity->save() in src/XF/Entity/Post.php at line 882
    XF\Entity\Post->softDelete() in src/XF/Spam/Cleaner/Post.php at line 44
    XF\Spam\Cleaner\Post->cleanUp() in src/XF/Spam/Cleaner.php at line 156
    XF\Spam\Cleaner->cleanUpContent() in src/XF/Spam/Cleaner.php at line 139
    XF\Spam\Cleaner->cleanUp() in src/XF/Pub/Controller/SpamCleaner.php at line 47
    XF\Pub\Controller\SpamCleaner->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
    XF\App->run() in src/XF.php at line 524
    XF::runApp() in index.php at line 20

XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'position' at row 1
src/XF/Db/AbstractStatement.php:230

Трассировка стека​

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}

Содержимое запроса​

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"
  }
}

 

[dimka1510]

до версии 2.2.25

Такая разве есть?

В этих двух строках не имело смысла скрывать цифры.

["referrer"] => string(127) "https://domain.com/threads/*******/"

["_xfRequestUri"] => string(101) "/threads/*****/"

 

[bianchi]

dimka1510, с версией ошибся... да. Версия 2.2.15