Nirjonadda
Well-known member
Yugensoft updated Time Spent Online with a new update entry:
v2.0.5
Read the rest of this update entry...
What is this functionality? Do you have any preview?
Yugensoft updated Time Spent Online with a new update entry:
v2.0.5
Read the rest of this update entry...
Aggregate time in forum statistics widgetWhat is this functionality? Do you have any preview?
Oops, download & try again@Yugensoft Uploaded this v2.0.5 files but no upgrade button.
Wait for cache
Xd Xh Xm
to XD XH XM
capital letters?Fix regarding possible 3rd party addon interaction
It can be used for promotions, but only on total time online (it doesn't track which days they spent the time).Can I use this on User Group Promotion?
Like: User has been online at least X hours for the last X Days
(it doesn't track which days they spent the time).
XF\Db\DeadlockException: MySQL query error [1213]: Deadlock found when trying to get lock; try restarting transaction src/XF/Db/AbstractStatement.php:212
Generated by: Starling Dec 23, 2018 at 7:11 PM
Stack trace
UPDATE xf_user AS u
SET u.time_spent=u.time_spent +
if(u.true_last_activity,
if((1545570701 - u.true_last_activity) < 900,
(1545570701 - u.true_last_activity),
0
),
0
),
u.true_last_activity=1545570701
WHERE u.user_id=332
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1213, '40001')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1213, '40001')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/addons/Yugensoft/TimeSpentOnline/XF/Repository/SessionActivity.php(23): XF\Db\AbstractAdapter->query('
...')
#4 src/addons/xenMade/LAU/XF/Repository/SessionActivity.php(29): Yugensoft\TimeSpentOnline\XF\Repository\SessionActivity->updateSessionActivity(332, '87.10.129.2', 'XF\\Pub\\Controll...', 'AddReply', Array, 'valid', '')
#5 src/XF/Pub/Controller/AbstractController.php(66): xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity(332, '87.10.129.2', 'XF\\Pub\\Controll...', 'AddReply', Array, 'valid', '')
#6 src/XF/Pub/Controller/AbstractController.php(41): XF\Pub\Controller\AbstractController->updateSessionActivity('AddReply', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#7 src/XF/Mvc/Controller.php(278): XF\Pub\Controller\AbstractController->postDispatchType('AddReply', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#8 src/XF/Mvc/Dispatcher.php(271): XF\Mvc\Controller->postDispatch('AddReply', Object(XF\Mvc\ParameterBag), Object(XF\Mvc\Reply\View))
#9 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'AddReply', 'json', Object(XF\Mvc\ParameterBag), 'forums', Object(TickTackk\ContentCopyProtection\XF\Pub\Controller\Thread), NULL)
#10 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(1934): XF\Mvc\Dispatcher->run()
#12 src/XF.php(333): XF\App->run()
#13 index.php(13): XF::runApp('XF\\Pub\\App')
#14 {main}
Request state
array(4) {
["url"] => string(45) "/threads/part-3.49305/add-reply"
["referrer"] => string(58) "/threads/part-3.49305/"
["_GET"] => array(0) {
}
["_POST"] => array(8) {
["message_html"] => string(92) "<p>[img][/img]</p><p><br></p>"
["last_date"] => string(10) "1545570694"
["last_known_date"] => string(10) "1545570343"
["klPage"] => string(0) ""
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(36) "/threads/part-3.49305/"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}
Stupid question time.. Is setting this to InnoDB enough to resolve the issue, or is it more complicated than that?@Yugensoft The xf_tso_record table is being created as MyIASM which causes locking issues when mixed with InnoDB tables (ie xf_user).
Should be enough.Stupid question time.. Is setting this to InnoDB enough to resolve the issue, or is it more complicated than that?
This resource has been deleted by XenForo Ltd. in line with our resource housekeeping criteria.
Initial Release from WMTech
New Add-On ID, Updated for XF 2.1.x
We use essential cookies to make this site work, and optional cookies to enhance your experience.