I have tried to upgrade from both to the 2.0 alpha1 and the dev version of the version 1 of node words and got the following errors from version 6.x-1.11. I got some errors. Is it safe to continue to use the upgrade? I think it is working with minimal testing. The reason I am trying to upgrade is because I was hoping there would be something that would fix the performance problem I am experiencing about 30 milliseconds of database query time per node that is loaded on a page do to this module and it seems to add up.
The following updates are pending:
nodewords module
6168 - Implements hook_update_N().
6169 - Implements hook_update_N().
6170 - Implements hook_update_N().
6173 - Implements hook_update_N().
Do you wish to run all pending updates? (y/n): y
Executing nodewords_update_6168 [success]
Executing nodewords_update_6169 [success]
WD php: User warning: Can't DROP 'nodewords_type_id_name'; check that column/key exists [error]
query: ALTER TABLE nodewords DROP KEY nodewords_type_id_name in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
WD php: User warning: Duplicate entry '8-65535-description' for key 'nodewords_type_id_name' [error]
query: ALTER TABLE nodewords ADD UNIQUE KEY nodewords_type_id_name (type, id, name) in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
ALTER TABLE {nodewords_custom} CHANGE `weight` `weight` SMALLINT NOT NULL DEFAULT 0 [success]
ALTER TABLE {nodewords_custom} CHANGE `enabled` `enabled` SMALLINT unsigned NOT NULL DEFAULT 1 [success]
ALTER TABLE {nodewords} DROP INDEX nodewords_type_id [success]
ALTER TABLE {nodewords} DROP KEY nodewords_type_id_name [error]
ALTER TABLE {nodewords} CHANGE `type` `type` SMALLINT unsigned NOT NULL DEFAULT 0 [success]
ALTER TABLE {nodewords} ADD INDEX nodewords_type_id (type, id) [success]
ALTER TABLE {nodewords} ADD UNIQUE KEY nodewords_type_id_name (type, id, name) [error]
Executing nodewords_update_6170 [success]
WD php: User warning: Can't DROP 'nodewords_type_id_name'; check that column/key exists [error]
query: ALTER TABLE nodewords DROP KEY nodewords_type_id_name in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
WD php: User warning: Duplicate entry '8-65535-description' for key 'nodewords_type_id_name' [error]
query: ALTER TABLE nodewords ADD UNIQUE KEY nodewords_type_id_name (type, id, name) in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
ALTER TABLE {nodewords} DROP INDEX nodewords_type_id [success]
ALTER TABLE {nodewords} DROP KEY nodewords_type_id_name [error]
ALTER TABLE {nodewords} CHANGE `type` `type` SMALLINT unsigned NOT NULL DEFAULT 0 [success]
ALTER TABLE {nodewords} CHANGE `id` `id` INT unsigned NOT NULL DEFAULT 0 [success]
ALTER TABLE {nodewords} ADD INDEX nodewords_type_id (type, id) [success]
ALTER TABLE {nodewords} ADD UNIQUE KEY nodewords_type_id_name (type, id, name) [error]
Executing nodewords_update_6173 [success]
Updated the menu callback definitions [success]
Can't DROP 'nodewords_type_id_name'; check that column/key exists [error]
query: ALTER TABLE nodewords DROP KEY nodewords_type_id_name in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
Duplicate entry '8-65535-description' for key 'nodewords_type_id_name' [error]
query: ALTER TABLE nodewords ADD UNIQUE KEY nodewords_type_id_name (type, id, name) in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
Can't DROP 'nodewords_type_id_name'; check that column/key exists [error]
query: ALTER TABLE nodewords DROP KEY nodewords_type_id_name in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
Duplicate entry '8-65535-description' for key 'nodewords_type_id_name' [error]
query: ALTER TABLE nodewords ADD UNIQUE KEY nodewords_type_id_name (type, id, name) in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
'all' cache was cleared [success]
Finished performing updates. [ok]
szparty@www:/var/www/development/sites/all/modules/contrib$ drush updb
<em>module</em> <em>node_gallery</em> is incompatible with this release of Drupal, and will be disabled. [warning]
UPDATE {system} SET status = 0 WHERE name IN ('node_gallery') [success]
yThe following updates are pending:
nodewords module
6169 - Implements hook_update_N().
6176 - Implements hook_update_N().
6178 - Implements hook_update_N().
6179 - Implements hook_update_N().
nodewords_basic module
6107 - Implements hook_update_N().
6111 - Implements hook_update_N().
6112 - Implements hook_update_N().
nodewords_extra module
6106 - Removed support for IRCA PICS labels.
Do you wish to run all pending updates? (y/n):
Executing nodewords_update_6169 [success]
WD php: User warning: Can't DROP 'nodewords_type_id_name'; check that column/key exists [error]
query: ALTER TABLE nodewords DROP KEY nodewords_type_id_name in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
WD php: User warning: Duplicate entry '8-65535-description' for key 'nodewords_type_id_name' [error]
query: ALTER TABLE nodewords ADD UNIQUE KEY nodewords_type_id_name (type, id, name) in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
ALTER TABLE {nodewords} DROP INDEX nodewords_type_id [success]
ALTER TABLE {nodewords} DROP KEY nodewords_type_id_name [error]
ALTER TABLE {nodewords} CHANGE `type` `type` SMALLINT unsigned NOT NULL DEFAULT 0 [success]
ALTER TABLE {nodewords} ADD INDEX nodewords_type_id (type, id) [success]
ALTER TABLE {nodewords} ADD UNIQUE KEY nodewords_type_id_name (type, id, name) [error]
Executing nodewords_update_6176 [success]
The code has been re-organized in new modules that have been enabled [success]
Removed obsolete persistent variables [success]
The settings page for the front page meta tags has been removed [success]
Executing nodewords_update_6178 [success]
WD php: User warning: Can't DROP 'nodewords_type_id_name'; check that column/key exists [error]
query: ALTER TABLE nodewords DROP KEY nodewords_type_id_name in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
WD php: User warning: Duplicate entry '8-65535-description' for key 'nodewords_type_id_name' [error]
query: ALTER TABLE nodewords ADD UNIQUE KEY nodewords_type_id_name (type, id, name) in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
ALTER TABLE {nodewords} DROP INDEX nodewords_type_id [success]
ALTER TABLE {nodewords} DROP KEY nodewords_type_id_name [error]
ALTER TABLE {nodewords} CHANGE `type` `type` SMALLINT unsigned NOT NULL DEFAULT 0 [success]
ALTER TABLE {nodewords} CHANGE `id` `id` VARCHAR(255) NOT NULL DEFAULT '' [success]
UPDATE {nodewords} set id = '0' WHERE id = '' OR id IS NULL [success]
ALTER TABLE {nodewords} CHANGE `id` `id` INT unsigned NOT NULL DEFAULT 0 [success]
ALTER TABLE {nodewords} ADD INDEX nodewords_type_id (type, id) [success]
ALTER TABLE {nodewords} ADD UNIQUE KEY nodewords_type_id_name (type, id, name) [error]
Executing nodewords_update_6179 [success]
Removed obsolete persistent variables [success]
Executing nodewords_basic_update_6107 [success]
Updated module settings [success]
Executing nodewords_basic_update_6111 [success]
Updated module settings [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Executing nodewords_basic_update_6112 [success]
Corrected the values saved in the database that were causing a PHP error [success]
Executing nodewords_extra_update_6106 [success]
DELETE FROM {nodewords} WHERE name = 'pics-label' [success]
Removed support for the IRCA PICS label meta tags. See <a href="http://www.icra.org/">http://www.icra.org/</a> for more information. [success]
Can&#039;t DROP &#039;nodewords_type_id_name&#039;; check that column/key exists [error]
query: ALTER TABLE nodewords DROP KEY nodewords_type_id_name in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
Duplicate entry &#039;8-65535-description&#039; for key &#039;nodewords_type_id_name&#039; [error]
query: ALTER TABLE nodewords ADD UNIQUE KEY nodewords_type_id_name (type, id, name) in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
Can&#039;t DROP &#039;nodewords_type_id_name&#039;; check that column/key exists [error]
query: ALTER TABLE nodewords DROP KEY nodewords_type_id_name in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
Duplicate entry &#039;8-65535-description&#039; for key &#039;nodewords_type_id_name&#039; [error]
query: ALTER TABLE nodewords ADD UNIQUE KEY nodewords_type_id_name (type, id, name) in _db_query() (line 149 of /var/www/development/includes/database.mysql.inc).
'all' cache was cleared [success]
Finished performing updates. [ok]
Comments
Comment #1
damienmckennaUnless someone can say that the current 6.x-1.x-dev update scripts break a 6.x-1.11 site, I'm taking this off the 6.x-1.12-blockers list.
Comment #2
damienmckennaMaking these easier to index.
Comment #3
mariagwyn commentedDuring a routine patching of the module from 1.11 to 1.13, I encountered this issue during the database updates.
Specifically:
Update #6169
• Failed: ALTER TABLE {nodewords} DROP KEY nodewords_type_id_name
• Failed: ALTER TABLE {nodewords} ADD UNIQUE KEY nodewords_type_id_name (type, id, name)
Update #6170
• Failed: ALTER TABLE {nodewords} DROP KEY nodewords_type_id_name
• Failed: ALTER TABLE {nodewords} ADD UNIQUE KEY nodewords_type_id_name (type, id, name)
Can you clarify if this error is problematic and if so, do you recommend any manual steps to address it?
Thank you,
Maria
Comment #4
damienmckennaUnfortunately this module is no longer supported, so I'm closing this issue.