I can see I have a "blocked_ips" table in my database, however I am receiving this error:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db317060876.blocked_ips' doesn't exist: SELECT 1 FROM {blocked_ips} WHERE ip = :ip; Array ( [:ip] => 107.9.206.3 ) in drupal_is_denied() (line 1910 of /homepages/4/d315922724/htdocs/lakeeriesound.org/includes/bootstrap.inc).

This started after I upgraded from 7.14 (I think) to 7.16.

Any suggestions? I haven't done much troubleshooting with Drupal, so feel free to advise basic troubleshooting techniques (i.e., disable all your modules, etc.)

Thanks in advance.

Comments

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented
Status: Active » Postponed (maintainer needs more info)

Empty the cache* tables and try again.

bbshopplf’s picture

bbshopplf CreditAttribution: bbshopplf commented
Status: Postponed (maintainer needs more info) » Active

Thank you for the reply.

I went into MyPHPadmin and manually "emptied" each of the cache tables.

Something changed - when I attempt to run update.php, I see a generic error message explaining that I don't have permission to access that page.

All attempts to access the site, /user and /admin fail, with the same error message noted in original post.

Another factor - I wasn't logged in as User1 when I first attempted to run upgrade.php.

I appreciate your help.

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented

Another factor - I wasn't logged in as User1 when I first attempted to run upgrade.php.

Yikes, never update.php with any other account.

Can you get logged in? The /user/login page should be able to be displayed even with you are in maintenance mode. If not continue the update by going to settings.php and set $update_free_access = TRUE (the variable is on line 201 in my settings.php file). You will be reminded when it is completed to set it to FALSE.

bbshopplf’s picture

bbshopplf CreditAttribution: bbshopplf commented

Yes; I'll likely never make that mistake again.

I updated settings.php. Now I get this error (when I run /update.php):

Fatal error: Call to undefined function ctools_include() in /homepages/4/d315922724/htdocs/lakeeriesound.org/modules/views/views.module on line 62

All modules except core modules are disabled. My cache* tables are empty. I confirmed that both ctools and views modules are disabled.

Any idea why I'd be seeing this error?

bbshopplf’s picture

bbshopplf CreditAttribution: bbshopplf commented

Actually, I just looked and ctools has two of its own caches outside the system table - css_cache and object_cache.

Should I empty these?

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented

You might check the system table for the views module to ensure that it is disabled. From what it looks to me is that views did not get disabled but ctools did.

I have no idea about the two tables for views, you should file a separate issue with them.

bbshopplf’s picture

bbshopplf CreditAttribution: bbshopplf commented

The Views module (and two other related modules) is definitely disabled.

I'll check with Ctools people about the two ctools caches.

bbshopplf’s picture

bbshopplf CreditAttribution: bbshopplf commented

I just checked the two Ctools caches, and neither of them are "empty-able".

I'll take this over to the Views and Ctools people, and see if they come up with anything.

Thanks for all your help.

Version: 7.16 » 7.x-dev

Core issues are now filed against the dev versions where changes will be made. Document the specific release you are using in your issue comment. More information about choosing a version.