What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

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

Tom McIntyre

New Member
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.
Code:
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) {
  }
}
 
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...
 
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.
 
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
 

From bespoke add-on development to complex integrations and specialized enhancements, we offer a range of XenForo development services designed to help your community thrive.

Start discussing your needs
Back
Top
Cart