Widget Threads Enhancement

Widget Threads Enhancement [Paid] 2.1.5

No permission to buy ($30.00)
Overview Updates (28) Reviews (7) History Discussion
Don't know if it's just me, but I feel like I notice a performance hit after using this. Page loads hang a little.
 
truonglv said:
Can you show me your widget settings? A much options can be slow for first page load.
Click to expand...
hmm not sure how to show you, but I am using 2 widgets, one Threads do not have reply and the other threads most replies that does have several usergroups picked. I have cache set at 30min for both. How sure are we that the cache is working?
 
dethfire said:
hmm not sure how to show you, but I am using 2 widgets, one Threads do not have reply and the other threads most replies that does have several usergroups picked. I have cache set at 30min for both. How sure are we that the cache is working?
Click to expand...
Option user groups are slow. It's filter from another table. In this case i should give an option allow load through ajax so do not make page slow.
 
truonglv said:
Option user groups are slow. It's filter from another table. In this case i should give an option allow load through ajax so do not make page slow.
Click to expand...
But once it's cached, it should not be slow right? What is downside of AJAX method?
 
I don't think cache is working. I have a TTL of 8min and a thread I deleted 38min prior still shows up.
 
Does this add-on respect usergroup permissions and hide threads from members who are not allowed to view them?
 
@truonglv

It seems there's an issue with this addon filling up the Simple Cache.

xenforo.com

XF 2.1 - MySQL error when running Generate random album cache cron

We're getting this MySQL error in the AdminCP when the random album cache cron runs. XF\Db\Exception: MySQL query error [1406]: Data too long for column 'data_value' at row 1 in src/XF/Db/AbstractStatement.php at line 217 XF\Db\AbstractStatement->getException() in...
xenforo.com xenforo.com
 
I just updated to version 1.1.3, just 2 hours ago
Then I started receiving this errors.
PHP: 
Server error log
XF\Db\DuplicateKeyException: Error rendering widget: MySQL query error [1062]: Duplicate entry '65fde380ee26e7e2b2bcdab22e87f4f3' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Aug 2, 2019 at 12:36 PM
Stack trace
INSERT  INTO `xf_wte_widget_cache` (`cache_id`, `data`, `widget_id`, `cached_date`) 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/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_wte_widget_c...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php(351): XF\Mvc\Entity\Entity->save()
#7 src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php(312): Truonglv\WidgetThreadEnhance\Widget\Threads->saveCache('65fde380ee26e7e...', Object(XF\Mvc\Entity\ArrayCollection))
#8 src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php(57): Truonglv\WidgetThreadEnhance\Widget\Threads->getThreadIds()
#9 internal_data/code_cache/widgets/_37_trending_threads_30days_404_page.php(5): Truonglv\WidgetThreadEnhance\Widget\Threads->render()
#10 src/XF/Template/Templater.php(6670): XF\SubContainer\Widget->{closure}(Object(TickTackk\DisplayBannedClassForEveryone\XF\Template\Templater), Array, Array)
#11 src/XF/SubContainer/Widget.php(168): XF\Template\Templater->renderWidgetClosure(Object(Closure), Array)
#12 src/XF/Template/Templater.php(1663): XF\SubContainer\Widget->getCompiledWidget(Array, Array)
#13 internal_data/code_cache/templates/l1/s13/public/siropu_custom_404_page_content.php(48): XF\Template\Templater->renderWidget('trending_thread...', Array, Array)
#14 src/XF/Template/Templater.php(1315): XF\Template\Templater->{closure}(Object(TickTackk\DisplayBannedClassForEveryone\XF\Template\Templater), Array)
#15 src/XF/Template/Templater.php(1388): XF\Template\Templater->renderTemplate('siropu_custom_4...', Array)
#16 internal_data/code_cache/templates/l1/s13/public/error.php(17): XF\Template\Templater->includeTemplate('public:siropu_c...', Array)
#17 src/XF/Template/Templater.php(1315): XF\Template\Templater->{closure}(Object(TickTackk\DisplayBannedClassForEveryone\XF\Template\Templater), Array)
#18 src/XF/Template/Template.php(24): XF\Template\Templater->renderTemplate('error', Array)
#19 src/XF/Mvc/Renderer/Html.php(48): XF\Template\Template->render()
#20 src/XF/Mvc/Renderer/Html.php(38): XF\Mvc\Renderer\Html->renderView('XF:Error', 'public:error', Array)
#21 src/XF/Mvc/Dispatcher.php(387): XF\Mvc\Renderer\Html->renderErrors(Array)
#22 src/XF/Mvc/Dispatcher.php(360): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\Error))
#23 src/XF/Mvc/Dispatcher.php(53): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\Error), 'html')
#24 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#25 src/XF.php(390): XF\App->run()
#26 index.php(20): XF::runApp('XF\\Pub\\App')
#27 {main}
Request state
array(4) {
  ["url"] => string(20) "/attachments/634854/"
  ["referrer"] => string(40) "https://www.domain.com/threads/733833/"
  ["_GET"] => array(1) {
    ["/attachments/634854/"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
}


Server error log
XF\Db\DuplicateKeyException: Error rendering widget: MySQL query error [1062]: Duplicate entry '554401f78ede976cada25b5d89f17727' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Aug 2, 2019 at 12:47 PM
Stack trace
INSERT  INTO `xf_wte_widget_cache` (`cache_id`, `data`, `widget_id`, `cached_date`) 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/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_wte_widget_c...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php(351): XF\Mvc\Entity\Entity->save()
#7 src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php(312): Truonglv\WidgetThreadEnhance\Widget\Threads->saveCache('554401f78ede976...', Object(XF\Mvc\Entity\ArrayCollection))
#8 src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php(57): Truonglv\WidgetThreadEnhance\Widget\Threads->getThreadIds()
#9 internal_data/code_cache/widgets/_40_home_popular_threads_mobile_phone.php(5): Truonglv\WidgetThreadEnhance\Widget\Threads->render()
#10 src/XF/Template/Templater.php(6670): XF\SubContainer\Widget->{closure}(Object(TickTackk\DisplayBannedClassForEveryone\XF\Template\Templater), Array, Array)
#11 src/XF/SubContainer/Widget.php(168): XF\Template\Templater->renderWidgetClosure(Object(Closure), Array)
#12 src/XF/Template/Templater.php(1663): XF\SubContainer\Widget->getCompiledWidget(Array, Array)
#13 internal_data/code_cache/templates/l1/s17/public/_page_node.508.php(46): XF\Template\Templater->renderWidget('home_popular_th...', Array, Array)
#14 src/XF/Template/Templater.php(1315): XF\Template\Templater->{closure}(Object(TickTackk\DisplayBannedClassForEveryone\XF\Template\Templater), Array)
#15 src/XF/Template/Templater.php(1388): XF\Template\Templater->renderTemplate('_page_node.508', Array)
#16 internal_data/code_cache/templates/l1/s17/public/page_view.php(82): XF\Template\Templater->includeTemplate('public:_page_no...', Array)
#17 src/XF/Template/Templater.php(1315): XF\Template\Templater->{closure}(Object(TickTackk\DisplayBannedClassForEveryone\XF\Template\Templater), Array)
#18 src/XF/Template/Template.php(24): XF\Template\Templater->renderTemplate('page_view', Array)
#19 src/XF/Mvc/Renderer/Html.php(48): XF\Template\Template->render()
#20 src/XF/Mvc/Dispatcher.php(418): XF\Mvc\Renderer\Html->renderView('XF:Page\\View', 'public:page_vie...', Array)
#21 src/XF/Mvc/Dispatcher.php(400): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#22 src/XF/Mvc/Dispatcher.php(360): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#23 src/XF/Mvc/Dispatcher.php(53): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#24 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#25 src/XF.php(390): XF\App->run()
#26 index.php(20): XF::runApp('XF\\Pub\\App')
#27 {main}
Request state
array(4) {
  ["url"] => string(1) "/"
  ["referrer"] => string(40) "https://www.domain.com/threads/740640/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}



Server error log
XF\Db\DuplicateKeyException: Error rendering widget: MySQL query error [1062]: Duplicate entry 'fd3c3cd52f40d6332beb597bdf4cdb2b' for key 'PRIMARY' src/XF/Db/AbstractStatement.php:217
Generated by: user Aug 2, 2019 at 12:53 PM
Stack trace
INSERT  INTO `xf_wte_widget_cache` (`cache_id`, `data`, `widget_id`, `cached_date`) 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/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_wte_widget_c...', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php(351): XF\Mvc\Entity\Entity->save()
#7 src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php(312): Truonglv\WidgetThreadEnhance\Widget\Threads->saveCache('fd3c3cd52f40d63...', Object(XF\Mvc\Entity\ArrayCollection))
#8 src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php(57): Truonglv\WidgetThreadEnhance\Widget\Threads->getThreadIds()
#9 internal_data/code_cache/widgets/_47_home_popular_threads_android_tricks.php(5): Truonglv\WidgetThreadEnhance\Widget\Threads->render()
#10 src/XF/Template/Templater.php(6670): XF\SubContainer\Widget->{closure}(Object(TickTackk\DisplayBannedClassForEveryone\XF\Template\Templater), Array, Array)
#11 src/XF/SubContainer/Widget.php(168): XF\Template\Templater->renderWidgetClosure(Object(Closure), Array)
#12 src/XF/Template/Templater.php(1663): XF\SubContainer\Widget->getCompiledWidget(Array, Array)
#13 internal_data/code_cache/templates/l1/s13/public/_page_node.508.php(39): XF\Template\Templater->renderWidget('home_popular_th...', Array, Array)
#14 src/XF/Template/Templater.php(1315): XF\Template\Templater->{closure}(Object(TickTackk\DisplayBannedClassForEveryone\XF\Template\Templater), Array)
#15 src/XF/Template/Templater.php(1388): XF\Template\Templater->renderTemplate('_page_node.508', Array)
#16 internal_data/code_cache/templates/l1/s13/public/page_view.php(82): XF\Template\Templater->includeTemplate('public:_page_no...', Array)
#17 src/XF/Template/Templater.php(1315): XF\Template\Templater->{closure}(Object(TickTackk\DisplayBannedClassForEveryone\XF\Template\Templater), Array)
#18 src/XF/Template/Template.php(24): XF\Template\Templater->renderTemplate('page_view', Array)
#19 src/XF/Mvc/Renderer/Html.php(48): XF\Template\Template->render()
#20 src/XF/Mvc/Dispatcher.php(418): XF\Mvc\Renderer\Html->renderView('XF:Page\\View', 'public:page_vie...', Array)
#21 src/XF/Mvc/Dispatcher.php(400): XF\Mvc\Dispatcher->renderView(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#22 src/XF/Mvc/Dispatcher.php(360): XF\Mvc\Dispatcher->renderReply(Object(XF\Mvc\Renderer\Html), Object(XF\Mvc\Reply\View))
#23 src/XF/Mvc/Dispatcher.php(53): XF\Mvc\Dispatcher->render(Object(XF\Mvc\Reply\View), 'html')
#24 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#25 src/XF.php(390): XF\App->run()
#26 index.php(20): XF::runApp('XF\\Pub\\App')
#27 {main}
Request state
array(4) {
  ["url"] => string(1) "/"
  ["referrer"] => string(48) "https://www.domain.com/forums/61/?prefix_id=20"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
You must log in or register to reply here.

Similar threads

Ozzy47
[OzzModz] Widget Position: Below First Post
Replies
1
Views
120
Ozzy47
Ozzy47
Ozzy47
[OzzModz] XFRM: Widget Positions
Replies
0
Views
71
Ozzy47
Ozzy47
Ozzy47
[OzzModz] XFMG: Widget Positions
Replies
0
Views
88
Ozzy47
Ozzy47
Ozzy47
[OzzModz] Widget: Thread Info [Paid]
2
Replies
38
Views
967
TCGMook
TCGMook
BassMan
[cXF] New Threads Widget Plus [Paid]
Replies
0
Views
445
BassMan
BassMan
Top Bottom