MySQL query error [1264]: Out of range value for column 'forum_read_date'

rdn

Well-known member
Affected version
2.2.13
Full log:
PHP:
Server error log
XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'forum_read_date' at row 1 src/XF/Db/AbstractStatement.php:230
Generated by: User Sep 26, 2023 at 2:04 AM
    
Stack trace
INSERT  INTO `xf_forum_read` (`node_id`, `user_id`, `forum_read_date`) VALUES (6,728535,1.6956768079826E+16),
(8,728535,1.6956768079826E+16),
(11,728535,1.6956768079826E+16),
(20,728535,1.6956768079826E+16),
(28,728535,1.6956768079826E+16),
(42,728535,1.6956768079826E+16),
(51,728535,1.6956768079826E+16),
(53,728535,1.6956768079826E+16),
(61,728535,1.6956768079826E+16),
(62,728535,1.6956768079826E+16),
(65,728535,1.6956768079826E+16),
(81,728535,1.6956768079826E+16),
(84,728535,1.6956768079826E+16),
(87,728535,1.6956768079826E+16),
(88,728535,1.6956768079826E+16),
(92,728535,1.6956768079826E+16),
(100,728535,1.6956768079826E+16),
(103,728535,1.6956768079826E+16),
(104,728535,1.6956768079826E+16),
(105,728535,1.6956768079826E+16),
(106,728535,1.6956768079826E+16),
(107,728535,1.6956768079826E+16),
(110,728535,1.6956768079826E+16),
(114,728535,1.6956768079826E+16),
(115,728535,1.6956768079826E+16),
(120,728535,1.6956768079826E+16),
(122,728535,1.6956768079826E+16),
(123,728535,1.6956768079826E+16),
(125,728535,1.6956768079826E+16),
(126,728535,1.6956768079826E+16),
(128,728535,1.6956768079826E+16),
(129,728535,1.6956768079826E+16),
(130,728535,1.6956768079826E+16),
(131,728535,1.6956768079826E+16),
(135,728535,1.6956768079826E+16),
(136,728535,1.6956768079826E+16),
(139,728535,1.6956768079826E+16),
(140,728535,1.6956768079826E+16),
(146,728535,1.6956768079826E+16) ON DUPLICATE KEY UPDATE forum_read_date = VALUES(forum_read_date)
------------

#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(276): XF\Db\AbstractAdapter->query('INSERT  INTO `x...')
#4 src/XF/Repository/Forum.php(175): XF\Db\AbstractAdapter->insertBulk('xf_forum_read', Array, false, 'forum_read_date...')
#5 src/XF/Db/AbstractAdapter.php(457): XF\Repository\Forum->XF\Repository\{closure}(Object(XF\Db\Mysqli\Adapter))
#6 src/XF/Repository/Forum.php(177): XF\Db\AbstractAdapter->executeTransaction(Object(Closure), 1)
#7 src/XF/Pub/Controller/Forum.php(1093): XF\Repository\Forum->markForumTreeReadByVisitor(NULL, 16956768079826359)
#8 src/XF/Mvc/Dispatcher.php(352): XF\Pub\Controller\Forum->actionMarkRead(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Forum', 'MarkRead', Object(XF\Mvc\RouteMatch), Object(SV\RedisCache\XF\Pub\Controller\Forum), NULL)
#10 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\RedisCache\XF\Pub\Controller\Forum), NULL)
#11 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#13 src/XF.php(524): XF\App->run()
#14 index.php(20): XF::runApp('XF\\Pub\\App')
#15 {main}
    
Request state
array(4) {
  ["url"] => string(43) "/forums/-/mark-read?date=16956768079826359<"
  ["referrer"] => string(28) "https://www.xf2.com/"
  ["_GET"] => array(2) {
    ["/forums/-/mark-read"] => string(0) ""
    ["date"] => string(18) "16956768079826359<"
  }
  ["_POST"] => array(1) {
    ["_xfToken"] => string(8) "********"
  }
}
 
How did you end up with a url with not only an invalid Unix timestamp, but also with < at the end? Perhaps a template issue?
 
Top Bottom