I enable core search and after a short while of testing the search function using the normal search bar in a block I see the following
PDOException: SQLSTATE  User database_jim already has more than 'max_user_connections' active connections in lock_may_be_available() (line 167 of /home/kitchena/public_html/includes/lock.inc).
This 'max_user_connections' is on the MySql database since the user mentioned is for that database. I went into system table and disabled search but system is still down. Any ideas how to clear it without resorting to calling host provider. I need this function. I am running under php 5.2.17 and using sub domain if that makes any difference to anybody.