Hi there,

upon updating I received the following user warnings. Overall the update seems to be successful though. Any thoughts?

user warning: Can't DROP 'nodequeue_roles_qid_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_roles DROP INDEX nodequeue_roles_qid_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.
user warning: Can't DROP 'nodequeue_roles_rid_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_roles DROP INDEX nodequeue_roles_rid_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.
user warning: Can't DROP 'nodequeue_types_qid_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_types DROP INDEX nodequeue_types_qid_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.
user warning: Can't DROP 'nodequeue_types_type_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_types DROP INDEX nodequeue_types_type_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.
user warning: Can't DROP 'nodequeue_subqueue_qid_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_subqueue DROP INDEX nodequeue_subqueue_qid_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.
user warning: Can't DROP 'nodequeue_subqueue_reference_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_subqueue DROP INDEX nodequeue_subqueue_reference_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.
user warning: Can't DROP 'nodequeue_subqueue_title_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_subqueue DROP INDEX nodequeue_subqueue_title_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.
user warning: Can't DROP 'nodequeue_nodes_sqid_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_nodes DROP INDEX nodequeue_nodes_sqid_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.
user warning: Can't DROP 'nodequeue_nodes_qid_nid_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_nodes DROP INDEX nodequeue_nodes_qid_nid_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.
user warning: Can't DROP 'nodequeue_subqueue_nid_idx'; check that column/key exists query: ALTER TABLE drupalnodequeue_nodes DROP INDEX nodequeue_subqueue_nid_idx in /is/htdocs/www/drupal6/includes/database.mysql-common.inc on line 457.

I attached a pic showing the update report too. Please note that all other updates went well.

CommentFileSizeAuthor
#5 1167026-fix_indices_update-5.patch3.29 KBamateescu
#1 1167026.patch3.12 KBamateescu
nodeque upgrade fail.PNG42.4 KBdddave
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

amateescu’s picture

amateescu CreditAttribution: amateescu commented
Status: Active » Fixed
FileSize
1167026.patch3.12 KB

Hmm, weird, it seems that you didn't have those indices in nodequeue's tables.

Commited the attached patch to check for their existence before trying to remove them. Note that there's no reason for you to try this patch, it's just for users of a future 6.x-2.11 release so they won't see these warning if they're also missing these indices.

http://drupalcode.org/project/nodequeue.git/commit/093f970

dddave’s picture

dddave CreditAttribution: dddave commented

Thanks for the feedback.

dddave’s picture

dddave CreditAttribution: dddave commented

Thanks for the feedback.

j0nathan’s picture

j0nathan CreditAttribution: j0nathan commented
Status: Fixed » Needs work

Hi,
Same issues like

WD php: User warning: Can't DROP 'nodequeue_subqueue_nid_idx'; check that column/key exists query: ALTER TABLE nodequeue_nodes DROP INDEX nodequeue_subqueue_nid_idx in _db_query() (line 147 of /srv/aegir/platforms/XXXXX/includes/database.mysqli.inc).

while trying to migrate a site into an Aegir platform with nodequeue updated.

I patched nodequeue in the destination platform with patch in #1, but now having these messages:

Drush command terminated abnormally due to an unrecoverable error. Error: Call to undefined function db_index_exists() in /srv/aegir/platforms/XXXXX/sites/all/modules/contrib/nodequeue/nodequeue.install, line 454

Output from failed command : Fatal error: Call to undefined function db_index_exists() in /srv/aegir/platforms/XXXXX/sites/all/modules/contrib/nodequeue/nodequeue.install on line 454

and the migration failed.

Line 454 is:

  if (db_index_exists('nodequeue_nodes', 'nodequeue_nodes_sqid_idx')) {

Any idea?

Thanks.

amateescu’s picture

amateescu CreditAttribution: amateescu commented
Status: Needs work » Needs review
FileSize
1167026-fix_indices_update-5.patch3.29 KB

That's what I get if I use D7 api functions in D6 :(

I reverted the commit from #1, so the attached patch should apply cleanly to both 6.x-2.10 and 6.x-2.x-dev.

Status: Needs review » Needs work

The last submitted patch, 1167026-fix_indices_update-5.patch, failed testing.

amateescu’s picture

amateescu CreditAttribution: amateescu commented
Status: Needs work » Fixed

Tested a manual update from schema version 6005 to 6007 with the patch from #5 and it works without errors.

Commited the patch from #5 to 6.x.

http://drupalcode.org/project/nodequeue.git/commit/a21ecab

Status: Fixed » Closed (fixed)

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