Update: (especially for @adwade )
Another security bug has been discovered today. Same as last security bug, (which tested as fixed under 4.4.x, but apparently is back in 1.5.x)
This release fix an issue with odd permission structure to make sure no notification is sent out for protected forums.
It's possible to do that but it may impact server performance depending on the number of users with keywords. Maybe an option?Request: When a user is downgraded privileges (ie out of a paid secondary user group) and no longer has access to set keyword alerts, their keyword alert emails should cease. Otherwise the user continues to get emails with no option to edit/delete.
For now, is it safe to go into the DB and delete the applicable rows out of xf_keywordalert_keyword ?
It's possible to do that but it may impact server performance depending on the number of users with keywords. Maybe an option?
Anyone can help? I really need to change the title of the email going out. The title has nothing to do with "Keyword Alert". lol I found how to change the actual body of the email, but nothing on the title.
Bump. Can anyone help? @xfrocks? Somebody?Anyone can help? I really need to change the title of the email going out. The title has nothing to do with "Keyword Alert". lol I found how to change the actual body of the email, but nothing on the title.
Exception: Slow query detected: 35.7675 seconds, /deferred.php - library/SV/SlowQueryLogger/Profiler.php:126
Generated By: Unknown Account, Yesterday at 12:22 PM
Stack Trace #0 /home/talkbass/html/library/Zend/Db/Statement.php(319): SV_SlowQueryLogger_Profiler->queryEnd(0)
#1 /home/talkbass/html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/talkbass/html/library/XenForo/Model/DataRegistry.php(164): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tINSERT INT...', Array)
#3 /home/talkbass/html/library/XenForo/Model/Deferred.php(188): XenForo_Model_DataRegistry->set('deferredRun', 1505668960)
#4 /home/talkbass/html/deferred.php(21): XenForo_Model_Deferred->setNextDeferredTime(1505668960)
#5 {main}Request State array(3) {
["url"] => string(37) "https://www.talkbass.com/deferred.php"
Have you tried disabling the add-on cron entry for a few hours and see if slowness is still happening?I'm trying to find the cause of very slow deferred.php queries that occur at 20 and 40 past the hour (not all the time, only occasionally). Does this add-on scale up well? It looks like I have 1,100 keywords active on user's lists. Is there any way that this add-on is the culprit I'm looking for? The cron run times line up, but that's the only correlation I have.
Code:Exception: Slow query detected: 35.7675 seconds, /deferred.php - library/SV/SlowQueryLogger/Profiler.php:126 Generated By: Unknown Account, Yesterday at 12:22 PM Stack Trace #0 /home/talkbass/html/library/Zend/Db/Statement.php(319): SV_SlowQueryLogger_Profiler->queryEnd(0) #1 /home/talkbass/html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /home/talkbass/html/library/XenForo/Model/DataRegistry.php(164): Zend_Db_Adapter_Abstract->query('\r\n\t\t\tINSERT INT...', Array) #3 /home/talkbass/html/library/XenForo/Model/Deferred.php(188): XenForo_Model_DataRegistry->set('deferredRun', 1505668960) #4 /home/talkbass/html/deferred.php(21): XenForo_Model_Deferred->setNextDeferredTime(1505668960) #5 {main}Request State array(3) { ["url"] => string(37) "https://www.talkbass.com/deferred.php"
View attachment 158204
I have just releases v1.1.2, you can get it here https://xfrocks.com/resources/bd-keyword-alert.14/. This version should work correctly with PHP 7.2.Hi,
I have just updated from php7.1 to php7.2 and I'm getting this if I want to enter the admin-panel:
Any help?
An exception occurred: Function create_function() is deprecated in /var/www/xxx/library/KeywordAlert/ShippableHelper/Updater.php on line 74
XenForo_Application::handlePhpError() in KeywordAlert/ShippableHelper/Updater.php at line 74
KeywordAlert_ShippableHelper_Updater..InitDependencies() in KeywordAlert/Listener.php at line 27
KeywordAlert_Listener::init_dependencies() in XenForo/CodeEvent.php at line 90
XenForo_CodeEvent::fire() in XenForo/Dependencies/Abstract.php at line 215
XenForo_Dependencies_Abstract->preLoadData() in XenForo/FrontController.php at line 127
XenForo_FrontController->run() in /var/www/xxx/admin.php at line 13
We use essential cookies to make this site work, and optional cookies to enhance your experience.