There are only a few global options, which come with semi-decent defaults. No permissions need configuringHi @Xon, are there any permissions to set for user groups or is it ready to use right after installation? Thank you
XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:230
Generated by: <Member's Username> Aug 5, 2022 at 4:10 PM
Stack trace
UPDATE `xf_user_alert` SET `view_date` = ?, `read_date` = ? WHERE alert_id IN(14582736)
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(324): XF\Db\AbstractAdapter->query('UPDATE `xf_use...', Array)
#4 src/XF/Repository/UserAlert.php(486): XF\Db\AbstractAdapter->update('xf_user_alert', Array, 'alert_id IN(145...')
#5 src/XF/Db/AbstractAdapter.php(457): XF\Repository\UserAlert->XF\Repository\{closure}(Object(XF\Db\Mysqli\Adapter))
#6 src/XF/Repository/UserAlert.php(492): XF\Db\AbstractAdapter->executeTransaction(Object(Closure), 1)
#7 src/XF/Pub/Controller/Thread.php(126): XF\Repository\UserAlert->markUserAlertsReadForContent('post', Array)
#8 src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php(16): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#9 src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php(12): Andy\Calendar\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#10 src/addons/XFMG/XF/Pub/Controller/Thread.php(11): Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(352): XFMG\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(XFMG\XF\Pub\Controller\Thread), NULL)
#13 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XFMG\XF\Pub\Controller\Thread), NULL)
#14 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2353): XF\Mvc\Dispatcher->run()
#16 src/XF.php(524): XF\App->run()
#17 index.php(20): XF::runApp('XF\\Pub\\App')
#18 {main}
Request state
array(4) {
["url"] => string(66) "/community/threads/thread-title.494506/page-193"
["referrer"] => string(93) "https://www.domain.com/community/threads/thread-title.494506/page-194"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
That is unrelated to this add-on, and is the result of a design flaw with how alerts are touched.Hi @Xon,
We received three server errors yesterday from two different members at the same time:
Code:XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:230 Generated by: <Member's Username> Aug 5, 2022 at 4:10 PM Stack trace UPDATE `xf_user_alert` SET `view_date` = ?, `read_date` = ? WHERE alert_id IN(14582736) ------------ #0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000') #1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000') #2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute() #3 src/XF/Db/AbstractAdapter.php(324): XF\Db\AbstractAdapter->query('UPDATE `xf_use...', Array) #4 src/XF/Repository/UserAlert.php(486): XF\Db\AbstractAdapter->update('xf_user_alert', Array, 'alert_id IN(145...') #5 src/XF/Db/AbstractAdapter.php(457): XF\Repository\UserAlert->XF\Repository\{closure}(Object(XF\Db\Mysqli\Adapter)) #6 src/XF/Repository/UserAlert.php(492): XF\Db\AbstractAdapter->executeTransaction(Object(Closure), 1) #7 src/XF/Pub/Controller/Thread.php(126): XF\Repository\UserAlert->markUserAlertsReadForContent('post', Array) #8 src/addons/Andy/Calendar/XF/Pub/Controller/Thread.php(16): XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag)) #9 src/addons/Andy/StaffActivity/XF/Pub/Controller/Thread.php(12): Andy\Calendar\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag)) #10 src/addons/XFMG/XF/Pub/Controller/Thread.php(11): Andy\StaffActivity\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag)) #11 src/XF/Mvc/Dispatcher.php(352): XFMG\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag)) #12 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', Object(XF\Mvc\RouteMatch), Object(XFMG\XF\Pub\Controller\Thread), NULL) #13 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XFMG\XF\Pub\Controller\Thread), NULL) #14 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch)) #15 src/XF/App.php(2353): XF\Mvc\Dispatcher->run() #16 src/XF.php(524): XF\App->run() #17 index.php(20): XF::runApp('XF\\Pub\\App') #18 {main} Request state array(4) { ["url"] => string(66) "/community/threads/thread-title.494506/page-193" ["referrer"] => string(93) "https://www.domain.com/community/threads/thread-title.494506/page-194" ["_GET"] => array(0) { } ["_POST"] => array(0) { } }
What would cause this and how do we resolve it for the future?
Thanks
There is already a per-user opt-out option with the ability to set a default for new users. This just requires the global option to enable this feature.I'm not sure everyone would welcome getting alerts with every single post rather than what they are used to, as this multiplies the number of email notifications from the forum. But if people opt in, then that would be fine.
There is already a per-user opt-out option with the ability to set a default for new users. This just requires the global option to enable this feature.
Ah! OK, so "Global option" : in the addon or in Xenforo?
Could you be more precise? Where would I set this up?
Thanks!
Andre
XF's options are per add-on (there is a hidden XF add-on row to hold all XenForo options). You can list all options an add-on adds via the add-on page => options dropdown on each add-on.Ah! OK, so "Global option" : in the addon or in Xenforo?
Use a test site, especially when you are exploring configuration an add-on for the first time. This will save you so much grief.I'd like to know what you are referring to by GLOBAL OPTION. It's the only missing piece of informaiton I need before implementing this addon. Especially because we have loads of posts promoting loads of BF sales right now. So I don't want to risk my job by implementing something without first understanding how to set it up and end up with a huge mess at the worst of times.
Please just post your question, and don't ask if you can ask.I have 1 question before purchase . if you give permission can I ask ? Please
- For reply/thread emails, make "view this thread" link actually link to the new post not jumping to the next unread post.
- Change "Persistent Alert - Only alert on no unread alerts" option to include checking new forum watch alerts for a thread. Not just thread watches.
- Adjust default value for "Persistent Alert - Suppress Persistent Emailing" to true
As I've mentioned before, XenForo's notification framework is what keeps track of if a post has generated an alert during a notification job is generated by a post being added to a thread..Hi @Xon, I sent you a lot more data over PM about the double/triple alert bug. Can you check it out please?
- Fix "view this thread" link not actually linking the thread/post as expected.
- Require php 7.2+
- Convert from global+per-forum enable option to per-forum-per-usergroup permissions.
- Add "[Persistent Alerts] - Enable" per-forum-per-usergroup permission (default global enabled)
- Remove "Persistent Alerts - Ignore Last Read Date (For Thread Replies)" global option, and per-forum "[Persistent Alerts] - Enable" option.
- If "Persistent Alerts - Ignore Last Read Date" global option was not yet, and per-forum "Enable Persistent Alerts" option was...
- Require Standard Library by Xon v1.18.0+
- Recommend Alert Improvements
- Update alert preference phrases for add-on to be hopefully less confusing and more informative
We use essential cookies to make this site work, and optional cookies to enhance your experience.