Search log

Search log [Paid] 1.8

No permission to buy ($35.00)


Well-known member
AndyB submitted a new resource:

Search log - Provides information about the searches being made by guests and members.

Premium upgrade:

This XF2 add-on along with the entire collection can be purchased for $25.00 USD. Your Premium upgrade will allow you to download as many XF2 add-ons as you like for one year. Please see the entire collection located in the Resources area at this URL:

Note: all my XF1 add-ons are still 100% free and are supported by donations.


Provides information about the searches being made by guests and members.


Read more about this resource...

Joe Link

Well-known member
Morning Andy,

Getting this error when clicking usernames and then clicking the number of messages (which performs a search for said messages).

XF\Db\Exception: MySQL query error [1364]: Field 'search_type' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
XF\Db\AbstractAdapter->query() in src/addons/Andy/SearchLog/XF/Pub/Controller/Search.php at line 41
Andy\SearchLog\XF\Pub\Controller\Search->actionResults() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1931
XF\App->run() in src/XF.php at line 328
XF::runApp() in index.php at line 13


Active member
View search log and get:

ErrorException: [E_NOTICE] Undefined variable: resultsNew in src\addons\Andy\SearchLog\Pub\Controller\SearchLog.php at line 73
  1. XF::handlePhpError() in src\addons\Andy\SearchLog\Pub\Controller\SearchLog.php at line 73
  2. Andy\SearchLog\Pub\Controller\SearchLog->actionIndex() in src\XF\Mvc\Dispatcher.php at line 321
  3. XF\Mvc\Dispatcher->dispatchClass() in src\XF\Mvc\Dispatcher.php at line 248
  4. XF\Mvc\Dispatcher->dispatchFromMatch() in src\XF\Mvc\Dispatcher.php at line 100
  5. XF\Mvc\Dispatcher->dispatchLoop() in src\XF\Mvc\Dispatcher.php at line 50
  6. XF\Mvc\Dispatcher->run() in src\XF\App.php at line 2178
  7. XF\App->run() in src\XF.php at line 390
  8. XF::runApp() in index.php at line 20