This error started appearing today, if a user try to reply to a thread he get this error. (error is random, them can post 10 times without any issues and then out of nowhere they get this)
[ATTACH=full]205500[/ATTACH]
I though this was a bug with one of my add-on so i disabled them all but i'm still getting this error.
Any idea what is causing this and how to fix it?
XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'alerts_unread' at row 1
src/XF/Db/AbstractStatement.php:217
[CODE]Stack trace
UPDATE xf_user
SET alerts_unread = alerts_unread + 1
WHERE user_id = ?
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1264, '22003')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1264, '22003')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Entity/UserAlert.php(98): XF\Db\AbstractAdapter->query('
UPDATE xf...', 295)
#4 src/XF/Mvc/Entity/Entity.php(1208): XF\Entity\UserAlert->_postSave()
#5 src/XF/Repository/UserAlert.php(141): XF\Mvc\Entity\Entity->save()
#6 src/XF/Repository/UserAlert.php(111): XF\Repository\UserAlert->insertAlert(295, 42343, 'Segmentation Fa...', 'post', 2078793, 'insert', Array)
#7 src/XF/Notifier/AbstractNotifier.php(55): XF\Repository\UserAlert->alert(Object(XF\Entity\User), 42343, 'Segmentation Fa...', 'post', 2078793, 'insert', Array)
#8 src/XF/Notifier/Post/AbstractWatch.php(104): XF\Notifier\AbstractNotifier->basicAlert(Object(XF\Entity\User), 42343, 'Segmentation Fa...', 'post', 2078793, 'insert')
#9 src/XF/Service/AbstractNotifier.php(86): XF\Notifier\Post\AbstractWatch->sendAlert(Object(XF\Entity\User))
#10 src/XF/Service/AbstractNotifier.php(44): XF\Service\AbstractNotifier->notifyType(Object(XF\Notifier\Post\ThreadWatch), Array, G)
#11 src/XF/Service/AbstractNotifier.php(56): XF\Service\AbstractNotifier->notify(3)
#12 src/XF/Service/Thread/Replier.php(205): XF\Service\AbstractNotifier->notifyAndEnqueue(3)
#13 src/XF/Pub/Controller/Thread.php(330): XF\Service\Thread\Replier->sendNotifications()
#14 src/XF/Pub/Controller/Thread.php(463): XF\Pub\Controller\Thread->finalizeThreadReply(Object(XF\Service\Thread\Replier))
#15 src/XF/Mvc/Dispatcher.php(321): XF\Pub\Controller\Thread->actionAddReply(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'AddReply', Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Thread), NULL)
#17 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Pub\Controller\Thread), NULL)
#18 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#19 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#20 src/XF.php(390): XF\App->run()
#21 index.php(20): XF::runApp('XF\\Pub\\App')
#22 {main}[/CODE]
[CODE]Request state
array(4) {
["url"] => string(57) "/threads/randomthread.18207/add-reply"
["referrer"] => bool(false)
["_GET"] => array(1) {
["/threads/randomthread_18207/add-reply"] => string(0) ""
}
["_POST"] => array(9) {
["message_html"] => string(376) "<p>[QUOTE="User99, post: 2078450, member: 1476438"]</p><p>how many days</p><p>[/QUOTE]</p><p><br></p><p>[spoiler="Help"]randomtexthere[/spoiler]</p>"
["attachment_hash"] => string(32) "a13c89e8ff453d16f7bf5880adab2a7e"
["attachment_hash_combined"] => string(87) "{"type":"post","context":{"thread_id":18207},"hash":"a13c89e8ff453d16f7bf5880adab2a7e"}"
["last_date"] => string(10) "1561728568"
["last_known_date"] => string(10) "1561728568"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(56) "/threads/randomthread.18207/page-280"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}[/CODE]
