Optimized List Queries by Xon 1.4.3

[Xon]

Does this work in 1.3?

It should, but I can't offer support for it.

 

[Xon]

Xon updated Optimized List Queries by Xon with a new update entry:

Maintenance Update

• Tweak options (add min values where appropriate), change "Faster Members Online Query" default value.

Read the rest of this update entry...

 

[rdn]

OK, I use the default XenForo Online list template now to take advantage of your addon

So in order to utilize this addon hack and great optimization.
I still use "sidebar_online_users" on bd widget page.

But this widget settings doesn't work:




What value should I put into Controller for it to work fine?

 

[Xon]

@RoldanLT XenForo_ControllerPublic_Forum::actionIndex() may do it, but you'll need to test to try out.

 

[rdn]

@RoldanLT XenForo_ControllerPublic_Forum::actionIndex() may do it, but you'll need to test to try out.

Thanks for your advice, But it doesn't work.

 

[Xon]

Xon updated Optimized List Queries by Xon with a new update entry:

Feature & Maintenance Update

• When XenForo update last user activity, do not allow older activity time stamps to be recorded.
• Allow optional caching of the members online session list for guests.
  • Default 150 seconds.

Read the rest of this update entry...

 

[maxicep]

I upgraded the latest version also i have xenforo latest version ( 1.5.12)

When i enabled the "Cache members online list for guests" forum can't open and it says error that "unknown error occured" Now i set it to "0" zero and forum is online. Else, not.

Server Error Log;

Datas must be string or set automatic_serialization = true
1 minute ago - library/Zend/Cache.php:209

Zend_Cache_Exception: Datas must be string or set automatic_serialization = true - library/Zend/Cache.php:209
Generated By: Unknown Account, 2 minutes ago
Stack Trace
#0 /home/public/forum/library/Zend/Cache/Core.php(360): Zend_Cache::throwException('Datas must be s...')
#1 /home/public/forum/library/SV/OptimizedListQueries/XenForo/ControllerPublic/Forum.php(57): Zend_Cache_Core->save(false, 'sessionlist_0', Array, '150')
#2 /home/public/forum/library/XenForo/ControllerPublic/Forum.php(130): SV_OptimizedListQueries_XenForo_ControllerPublic_Forum->_getSessionActivityList()
#3 /home/public/forum/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Forum->actionIndex()
#4 /home/public/forum/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#5 /home/public/index.php(13): XenForo_FrontController->run()
#6 {main}
Request State
array(3) {
  ["url"] => string(30) "https://www.site.com/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

 

[Xon]

Xon updated Optimized List Queries by Xon with a new update entry:

1.3.1 - Bugfix update

• Fix "Datas must be string or set automatic_serialization" due to failed serialization.

Read the rest of this update entry...

 

[Alpha1]

Does this play well with XenForo LiteSpeed Cache?

 

[Xon]

Does this play well with XenForo LiteSpeed Cache?

No reason it shouldn't. This add-on affects SQL queries & datawriters and don't really interact with the hooks that add-on uses.

 

[nrep]

I appear to have version 1.4.1 of this addon, but only 1.3.1 is available on this site. Did 1.4.1 get pulled?

 

[Xon]

I haven't released a v1.4.1, it might be a messed up version id.

 

[TDUBS]

I'm getting the following error..

ErrorException: Invalid argument supplied for foreach() - library/SV/OptimizedListQueries/Globals.php:25
Generated By: Unknown Account, 12 minutes ago

#0 /home/nginx/domains/site.com/public/library/SV/OptimizedListQueries/Globals.php(25): XenForo_Application::handlePhpError(2, 'Invalid argumen...', '/home/nginx/dom...', 25, Array)
#1 /home/nginx/domains/site.com/public/library/SV/OptimizedListQueries/XenForo/Model/Search.php(10): SV_OptimizedListQueries_Globals::removeHardEnabledHooks()
#2 /home/nginx/domains/site.com/public/library/XenForo/Search/Searcher.php(82): SV_OptimizedListQueries_XenForo_Model_Search->getViewableSearchResults(Array, NULL)
#3 /home/nginx/domains/site.com/public/library/XenForo/ControllerPublic/Search.php(255): XenForo_Search_Searcher->searchGeneral('{search_keyword...', Array, 'date')
#4 /home/nginx/domains/site.com/public/library/SV/OptimizedListQueries/XenForo/ControllerPublic/Search.php(8): XenForo_ControllerPublic_Search->actionSearch()
#5 /home/nginx/domains/site.com/public/library/XenForo/FrontController.php(351): SV_OptimizedListQueries_XenForo_ControllerPublic_Search->actionSearch()
#6 /home/nginx/domains/site.com/public/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/nginx/domains/site.com/public/index.php(13): XenForo_FrontController->run()
#8 {main}

array(3) {
  ["url"] => string(73) "http://site.com/index.php?search/search&keywords={search_keywords}"
  ["_GET"] => array(2) {
   ["search/search"] => string(0) ""
   ["keywords"] => string(17) "{search_keywords}"
  }
  ["_POST"] => array(0) {
  }
}

 

[Xon]

Xon updated Optimized List Queries by Xon with a new update entry:

Bugfix update

• Fix error on search which can occur when limited to no add-on's are installed.

Read the rest of this update entry...

 

[Xon]

Xon updated Optimized List Queries by Xon with a new update entry:

1.3.4 - Maintenance release

• When an error occurs and the unoptimized conversation list query is run, call the right function.

Read the rest of this update entry...

 

[Eagle]

@Xon it's possible to use with Zend Redis Cache 1.5.4 together?

 

[Xon]

@Xon it's possible to use with Zend Redis Cache 1.5.4 together?

Yes, both my sites use that combo (and in-fact nearly all my add-ons at the same time)

 

[Xon]

Xon updated Optimized List Queries by Xon with a new update entry:

1.3.5 - Maintenance release

• Improve the global RSS feature when selecting threads from a forum with a large number of threads.
  • Avoiding "early joins" can offer significant savings.
  • Disabled by default

Read the rest of this update entry...

 

[rdn]

This addon is not needed on XF2 anymore?

 

[Xon]

This addon is not needed on XF2 anymore?

Mostly it shouldn't be needed, I may revisit it if required.