• We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

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

Tom McIntyre

New Member
Joined
Jul 16, 2020
Messages
4
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) {
  }
}
 

Fredxd

Administrator
Staff member
Joined
Nov 14, 2015
Messages
1,892
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

New Member
Joined
Jul 16, 2020
Messages
4
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.
 

Fredxd

Administrator
Staff member
Joined
Nov 14, 2015
Messages
1,892
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