MySQL Forums
Forum List  »  Newbie

MySql errors
Posted by: Tom Rue
Date: November 11, 2012 06:41PM

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.

Options: ReplyQuote


Subject
Written By
Posted
MySql errors
November 11, 2012 06:41PM
November 13, 2012 09:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.