Drupal 7 Upgrade Error with Blocks? PDOException: SQLSTATE[42S22]

Posted by J. Cohen on January 3, 2013 at 6:54am

I've just upgraded a Drupal site from Drupal 62 Drupal 7. I'm getting a lot of ambiguous error messages "The website encountered an unexpected error. Please try again later."

One of the URLs is the blocks page: /admin/structure/block

The dblog says:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.bid' in 'field list': SELECT b.bid AS bid, b.module AS module, b.cache AS cache FROM {blockcache_alter} b; Array ( ) in blockcache_alter_block_info_alter() (line 103 of /home/******/public_html/sites/all/modules/blockcache_alter/blockcache_alter.module).

I get the same error when I save the modules page. Does anyone know how to fix this?

Comments

I removed Block Cache Alter

Posted by J. Cohen on January 3, 2013 at 7:05am

I removed Block Cache Alter module and now it works.

--
Mnemotechnics.org