3 failures in the update log from 6.x-2.x-dev, i do not think they are critical
maybe dropping the column first automatically drops the index, hence it fails next?

Update #14
* ALTER TABLE {xmlsitemap} ADD `subtype` VARCHAR(32) DEFAULT NULL
* UPDATE {xmlsitemap} SET subtype = node_type WHERE type = 'node'
* ALTER TABLE {xmlsitemap} DROP node_type
* Failed: ALTER TABLE {xmlsitemap} DROP INDEX node_type
* UPDATE {xmlsitemap} SET subtype = menu_name WHERE type = 'menu'
* ALTER TABLE {xmlsitemap} DROP menu_name
* Failed: ALTER TABLE {xmlsitemap} DROP INDEX menu_name
* UPDATE {xmlsitemap} SET subtype = term_vid WHERE type = 'taxonomy'
* ALTER TABLE {xmlsitemap} DROP term_vid
* Failed: ALTER TABLE {xmlsitemap} DROP INDEX term_vid
* ALTER TABLE {xmlsitemap} ADD INDEX type_subtype (type, subtype)

Comments

abaddon’s picture

abaddon commented

p.s. i dont see those indexes in my xmlsitemap table, i guess my assumption above was correct, anyway theyre not there so its ok and those failures should be ignored..

  PRIMARY KEY  (`id`,`type`),
  KEY `loc` (`loc`),
  KEY `access_status_loc` (`access`,`status`,`loc`),
  KEY `type_subtype` (`type`,`subtype`)
dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Fixed

Yeah, it's nothing critical and doesn't break the module, but I've moved the update code around to drop the index first. Thanks for reporting this! http://drupal.org/cvs?commit=253590

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.