Everything seemed to be running fine on a fresh install of FreeBSD 9.0, Apache 2.2.22, MySql 5.5.27, PHP 5.3.17.
That was when I moved hardware around, which included powering down the server and to move the power cable to a batter-backup unit. It seemed like a good idea at the time.
When I came back online, some of my sites were fine, while others seemed to have suddenly developed database problems that I haven't been able to sort out. Two of the errors are similar; one is different from the others.
I tried repairing tables in PhpMyAdmin, without success. MySql data files at /var/db/mysql are owned by mysql (user and group).
The max_allowed_packet value in my.cnf file is set to: max_allowed_packet = 100M.
All sites except for the one indicated (*) are Drupal 7.16, with up-to-date modules.
These are the problem sites (see error messages below):
http://carmenrue.com
http://ellarue.com
http://choicesmhc.com
These sites appear to be working fine:
http://tomrue.net
http://njforestry.org
http://renusethjerathmd.com
http://archive.carmenrue.com * [Drupal 5.23]
If anyone can offer any advice, it would be sincerely appreciated.
============== ERROR MESSAGE ================
Error
The website encountered an unexpected error. Please try again later.
Error messagePDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'carmenrue.blocked_ips' doesn't exist: SELECT 1 FROM {blocked_ips} WHERE ip = :ip; Array ( [:ip] => 24.161.18.74 ) in drupal_is_denied() (line 1910 of /usr/local/www/carmenrue.com/includes/bootstrap.inc).
============== ERROR MESSAGE ================
Error
The website encountered an unexpected error. Please try again later.
Error messagePDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ellarue.blocked_ips' doesn't exist: SELECT 1 FROM {blocked_ips} WHERE ip = :ip; Array ( [:ip] => 24.161.18.74 ) in drupal_is_denied() (line 1910 of /usr/local/www/ellarue.com/includes/bootstrap.inc).
============== ERROR MESSAGE ================
Additional uncaught exception thrown while handling exception.
Original
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lmhc.blocked_ips' doesn't exist: SELECT 1 FROM {blocked_ips} WHERE ip = :ip; Array ( [:ip] => 24.161.18.74 ) in drupal_is_denied() (line 1910 of /usr/local/www/choicesmhc.com/includes/bootstrap.inc).
Additional
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'lmhc.cache_bootstrap' doesn't exist: DELETE FROM {cache_bootstrap} WHERE (cid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => variables ) in cache_clear_all() (line 176 of /usr/local/www/choicesmhc.com/includes/cache.inc).
============================================
Edited 2 time(s). Last edit at 11/11/2012 06:55PM by Tom Rue.