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...
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
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
Hi @AndyB ,

It would be interesting to be able to know the IP also in the log of the person doing the search, it would help a lot to be able to identify guest that are using the forum search engine to find usernames.

Thank you for all of your work ;)
Top Bottom