Aug 03 2007

cache_views Doesn't Exist Error When Upgrading Drupal

Filed under: Content Management Systems » Drupal,

Tools:

Getting table cache_views doesn't exist error messages?

When upgrading from Drupal 4.7.x to 5.x, this is quite a common error. System upgrade #12 creates the "cache_views" table, but if this table was already created in a 4.x-dev release, the update will not be run again and you will see these errors pour all over your screen after attempting an update.

The quick fix

The quick fix is to run the code segment below to manually create the cache_views table. Access your database and execute the following mySQL query:

  CREATE TABLE cache_views ( cid varchar(255) NOT NULL default '', data longblob, expire int NOT NULL default '0', created int NOT NULL default '0', headers text, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */;
  

Worked a treat

Submitted by a visitor from afar on Wed, 2008-02-27 08:44.

Thanks - this worked fine for me ...