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 (&#039;node_gallery&#039;)                                                                                                                                                         [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 &#039;&#039;                                                                                                                                             [success]
UPDATE {nodewords} set id = &#039;0&#039; WHERE id = &#039;&#039; 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 = &#039;pics-label&#039;                                                                                                                                                                     [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&amp;#039;t DROP &amp;#039;nodewords_type_id_name&amp;#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 &amp;#039;8-65535-description&amp;#039; for key &amp;#039;nodewords_type_id_name&amp;#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&amp;#039;t DROP &amp;#039;nodewords_type_id_name&amp;#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 &amp;#039;8-65535-description&amp;#039; for key &amp;#039;nodewords_type_id_name&amp;#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

damienmckenna’s picture

Issue tags: -v6.x-1.12 blocker

Unless 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.

damienmckenna’s picture

Version: 6.x-2.0-alpha1 » 6.x-2.x-dev
Status: Active » Postponed

Making these easier to index.

mariagwyn’s picture

During 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

damienmckenna’s picture

Status: Postponed » Closed (won't fix)

Unfortunately this module is no longer supported, so I'm closing this issue.