I'm getting the following error when attempting to upgrade:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'books.blocked_ips' doesn't exist: SELECT 1 FROM {blocked_ips} WHERE ip = :ip; Array ( [:ip] => 99.58.88.97 ) in drupal_is_denied() (line 1781 of /home/books/public_html/includes/bootstrap.inc).

Cannot upgrade

Comments

shelleyp’s picture

shelleyp commented
Title: Attempting upgrade from 6.19 to Drupal 7 rc2 fails -- missing table » Attempting upgrade from 6.20 to Drupal 7 rc2 fails -- missing table
damien tournoud’s picture

damien tournoud commented
Status: Active » Postponed (maintainer needs more info)

Have you followed the instructions and visited update.php?

shelleyp’s picture

shelleyp commented

Yes, I followed instructions in UPGRADE.txt. I'm assuming that's what you meant.

I dropped database, reloaded previous copy, and now I'm getting:

DatabaseSchemaObjectExistsException: Cannot add index system_list to table system: index already exists. in DatabaseSchema_mysql->addIndex() (line 433 of /home/books/public_html/includes/database/mysql/schema.inc).
The website encountered an unexpected error. Please try again later.
Uncaught exception thrown in session handler.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ssid' in 'where clause': SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ) FOR UPDATE; Array ( [:db_condition_placeholder_0] => VwR9THvLyASASWSqfitRnYz3_rWYTDjJYjwoyDQbGYM [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 204 of /home/books/public_html/includes/session.inc).

shelleyp’s picture

shelleyp commented
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

I just tried with another site, and I'm not having problems with it.

I have to assume that something happened to the database on the site I'm attempting to upgrade, and the upgrade process just can't repair the differences.

But since I can't duplicate the error on another site, I'm assuming it's my site, not the app. Will close this bug out.