Table 'cache_views_data' already exists query

I'm not sure how you could already have that table if updating from 2.5 to 2.6, but if the table already existed then things are probably okay.

Just as a heads-up, I just had the exact same problem on my install. Everything seems to be working fine, but it does make me a little edgy... I guess as long the table schema is the same, no harm no foul....

FYI, i got the same thing on update.php going from 2.4 to 2.6 (drupal 6.13)

The following queries were executed
views module
Update #6005

* ALTER TABLE {views_view} CHANGE base_table `base_table` VARCHAR(64) NOT NULL DEFAULT ''

Update #6006

* 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 */

database.inc on line 517

Using views 2.7 on a 6.x site. Migrating from 5.x but I've completely dropped the 5.x views tables first.

In views_update_6006 there should be an "if cache_views_data does not exist" before creating the table. Here is the log from the full update of the views module...as you can see, cache_views_data is created in 6000.

The following queries were executed
views module
Update #6000

* CREATE TABLE {views_view} ( `vid` INT unsigned NOT NULL auto_increment, `name` VARCHAR(32) NOT NULL DEFAULT '', `description` VARCHAR(255) DEFAULT '', `tag` VARCHAR(255) DEFAULT '', `view_php` BLOB DEFAULT NULL, `base_table` VARCHAR(64) NOT NULL DEFAULT '', `is_cacheable` TINYINT DEFAULT 0, PRIMARY KEY (vid), UNIQUE KEY name (name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {views_display} ( `vid` INT unsigned NOT NULL DEFAULT 0, `id` VARCHAR(64) NOT NULL DEFAULT '', `display_title` VARCHAR(64) NOT NULL DEFAULT '', `display_plugin` VARCHAR(64) NOT NULL DEFAULT '', `position` INT DEFAULT 0, `display_options` BLOB DEFAULT NULL, INDEX vid (vid, position) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* CREATE TABLE {cache_views} ( `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 0, PRIMARY KEY (cid), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
* 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 */
* CREATE TABLE {views_object_cache} ( `sid` VARCHAR(64) DEFAULT NULL, `name` VARCHAR(32) DEFAULT NULL, `obj` VARCHAR(32) DEFAULT NULL, `updated` INT unsigned NOT NULL DEFAULT 0, `data` LONGTEXT DEFAULT NULL, INDEX sid_obj_name (sid, obj, name), INDEX updated (updated) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Update #6001

* UPDATE {blocks} SET delta = CONCAT(delta, '-block_1') WHERE module = 'views'

Update #6003

* Failed: ALTER TABLE {views_view} ADD UNIQUE KEY name (name)

Update #6004

* ALTER TABLE {views_object_cache} DROP data
* ALTER TABLE {views_object_cache} ADD `data` LONGTEXT DEFAULT NULL

Update #6005

* ALTER TABLE {views_view} CHANGE `base_table` `base_table` VARCHAR(64) NOT NULL DEFAULT ''

Update #6006

* 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 */

Update #6007

* No queries