By jbc on

I received the following update error, on two separate D6x installs... (non-production)

Failed: CREATE TABLE {cache_views_data} ( `cid` VARCHAR(255) NOT NULL DEFAULT '', `data` LONGBLOB DEFAULT NULL, `expire` INT NOT NULL DEFAULT 0, `created` INT NOT NULL DEFAULT 0, `headers` TEXT DEFAULT NULL, `serialized` SMALLINT NOT NULL DEFAULT 1, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Can anyone interpret this for me and suggest whether this is something I should be worried about or could afford to ignore?

Until I understand this, I won't include this update on my production site installs.

Thnx for assistance...

⋅ Categories: Drupal 6.x

Comments

jbc’s picture

jbc commented

Updating to Views-6.x-2.6

nonzero’s picture

nonzero commented

It looks like others #501776: Table 'cache_views_data' already exists query (including myself) get this warning upon upgrading but see no apparent problems. Whether there will be a problem depends on the difference between the cache tables between the versions you're upgrading from and to. I haven't looked into the code, so I don't know the changes between the versions. If views seem to work, I wouldn't worry.