table cache_views doesn’t exist

To sustain this free service, we receive affiliate commissions via some of our links. This doesn’t affect rankings. Our review process.

I keep getting cache_views doesn’t exist errors when trying to upgrade Drupal (from 4.7.x to 5.x). Any ideas how to prevent this error?

Know the answer? Comment below! Got your own question? Ask it here.

Disclaimer: This website contains reviews, opinions and information regarding products and services manufactured or provided by third parties. We are not responsible in any way for such products and services, and nothing contained here should be construed as a guarantee of the functionality, utility, safety or reliability of any product or services reviewed or discussed. Please follow the directions provided by the manufacturer or service provider when using any product or service reviewed or discussed on this website.

Subscribe
Notify of
4 Comments
Newest
Oldest Most voted
Inline Feedbacks
View all comments

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, create a backup, and then 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

Thanks – this worked fine for me …

Worked for me too!

+1 for next snippet. Worked like a charm.

Cache View Table

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.