Bug Fixed Problem that appears to trigger an XFES cascade error (timeouts)

[Tom McIntyre]

I am getting system error when this addon is enabled. It triggers a large number of errors in XFES due to timeouts. We are running xF2.1.12.

Server error log
[LIST]
[*]XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '12386-182348' for key 'user_id_thread_id'
[*]src/XF/Db/AbstractStatement.php:228
[*]Generated by: ONE OF OUR USERS
[*]Sep 13, 2021 at 9:24 PM
[/LIST]
[HEADING=2]Stack trace[/HEADING]
INSERT  INTO [ICODE]xfa_wrtt_thread_read[/ICODE] ([ICODE]thread_id[/ICODE], [ICODE]user_id[/ICODE], [ICODE]thread_read_date[/ICODE]) VALUES (?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/addons/XFA/WhoReadThisThread/XF/Repository/Thread.php(41): XF\Db\AbstractAdapter->insert('xfa_wrtt_thread...', Array)
#5 src/XF/Pub/Controller/Thread.php(89): XFA\WhoReadThisThread\XF\Repository\Thread->markThreadReadByVisitor(Object(SV\ElasticSearchEssentials\XF\Entity\Thread), 1631575455)
#6 src/addons/Andy/History/XF/Pub/Controller/Thread.php(12): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#7 src/addons/XenConcept/NextPreviousThread/XF/Pub/Controller/Thread.php(20): Andy\History\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#8 src/addons/XFMG/XF/Pub/Controller/Thread.php(11): XenConcept\NextPreviousThread\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#9 src/addons/XDinc/FThread/Pub/Controller/Thread.php(12): XFMG\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#10 src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php(29): XDinc\FThread\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#11 src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php(36): SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#12 src/addons/SV/ElasticSearchEssentials/XF/Pub/Controller/Thread.php(23): SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(350): SV\ElasticSearchEssentials\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#14 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Thread), NULL)
#15 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\ElasticSearchEssentials\XF\Pub\Controller\Thread), NULL)
#16 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#17 src/XF/App.php(2191): XF\Mvc\Dispatcher->run()
#18 src/XF.php(391): XF\App->run()
#19 index.php(20): XF::runApp('XF\\Pub\\App')
#20 {main}
[HEADING=2]Request state[/HEADING]
array(4) {
  ["url"] => string(49) "/threads/kieninger-chime-and-strike-setup.182348/"
  ["referrer"] => string(44) "https://mb.nawcc.org/forums/clock-repair.22/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[Fred]

Which mode do you use? Last read ?

 

[Tom McIntyre]

Yes, Last Read Date is checked.

 

[Fred]

You have last version of this addon? because i have retry this mode this morning and i don't have this issue anymore. This issue was present in older release but i have fix it...

 

[Tom McIntyre]

Your latest release does not support xF2.1.12 and we are not able to upgrade for about two more months because of system coordination with our other facilities.

 

[Fred]

Which version do you use exactly ?

 

[Tom McIntyre]

[XFA] Who Read This Thread 1.4.0
Allow to view who have read threads based on permissions

• Developer: XFA
• FAQ
• Support

 

[Fred]

Hum, should be fixed on this version.
Can you provide me an admin access and ftp access to your forum by PM please ? i will look this