On 2005-11-29, I suggested a patch to search to allow search to create a block listing recent searches.

Ensuing discussion on #drupal and on the patch page suggested that:

• the idea was interesting
• the implementation was too fragile to be used as such

I looked deeper into this and I think that making this feature more resilient would involve changing watchdog. The idea is therefore as documented below.

As this involves changes to core features, I hope developers with a deeper understanding of core than me will comment on this/edit this page to improve it before I write code involving these core changes. The wiki structure allows this more easily than comments on the patch page.

If you look at the patch, what it basically does is this, along with the definition of a new block in search_block:

function _search_recent()
  {
  $sq = "
  SELECT
    distinct message query
  FROM
    {watchdog}
  WHERE
    (type = 'search') AND (message like '%(content).')
  ORDER BY timestamp DESC
  " ;
  $q = db_query_range($sq, 0, 5);
  $ar = array();
  while ($o = db_fetch_object($q))
    {  
    $term = substr(substr($o->query, 12),0,-16);
    $ar[] = l($term, 'search/node/' . $term);
    }
  $output = theme_item_list($ar, NULL);
  unset ($ar);
  return $output ;
  }

You'll notice the “substr” line is dependent of the current format of the watchdog entries, which means it will most likely break on any translated site. And I know drupal style does not like multiline queries.

Also, processing is done in PHP whereas a better implementation would just ask the DBMS for the set of distinct entries in proper order to minimize the global workload.

• Implemented in v2 of the patch:
  • add a new column (say, “data”) to the watchdog table, to hold a php serialized content, or NULL
  • modify bootstrap.inc/watchdog to pass a new parameter:

function watchdog(
  $type, 
  $message, 
  $severity = WATCHDOG_NOTICE, 
  $link = NULL,
  $data = NULL) {

The new parameter could be used by modules aware of this new feature to store content of their choice in the watchdog along with the standard parameters, while retaining compatibility with existing call through the use of a default NULL.

• adding a new hook_watchdog_render to be invoked from watchdog.module/watchdog_overview to allow modules to display custom content along with or in lieu of the default log display. It would likely take the same parameters as the new watchdog() function:
• adding a setting to watchdog to toggle display of this additional information:
  • not displayed
  • displayed along the standard information
  • displayed as a link to details in the default watchdog display

In the current 4.6.x core, only watchdog module queries the watchdog table, and does so with queries like:

SELECT w.* [...] FROM {watchdog} w

which means no outside modules should be impacted. These queries could be improved to avoid querying this additional column if it is not needed.

• Implemented in v2 of the patch:
  • searches beyond “node” and “user” could be displayed too: this mechanism could be used by modules implementing hook_search, since the content, as a serialized object, could also store additional information for these modules.
  • with this information available, recent searches could be displayed by unserializing these data instead of processing the HTML-formatted contents of the current columns, allowing full i18n compatibility.
• having this new column available would allow search to store more usable information in the watchdog, typically by storing a serialized version of the query stats:
  • term searched
  • result count
  • something else ?
• as suggested by Boris Mann, having this more resilient content would allow for this feature to serve better, possibly by creating a RSS feed on recent searches
• the current display, limited to a fixed count of recent searches, could be improved by the addition of paging and optional display of the stats attached to the search

2005-11-29 8:33 chx says:

If you want to win the developers' hearts then you change the trigger_error in _db_query to a watchdog call (avoid infinite loops! keep a static var about 'tried watchdog it') which stores the debug_backtrace and lift the debug_backtrace renderer from devel. The latter is a contrib module but this would be just great, i think two lines o' code and would make drupal a hell lot easier to debug.

2005-1129 20:33 After further discussion, it looks like the idea is to log the debug_backtrace() information in the additional field.