When upgrading the og_vocab module and running update 6000 there was an error occurring with the index name nid. Another module i am guessing has utilized this name for an index previously and hence is causing a conflict where mysql will not allow the duplicate index.
Would it be possible to call the index a unique name i.e. og_vocab_nid_idx

Will attach patch regarding this.

CommentFileSizeAuthor
#1 og_vocab-462866.patch880 bytesdarren.ferguson
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

darren.ferguson’s picture

darren.ferguson CreditAttribution: darren.ferguson commented
FileSize
og_vocab-462866.patch880 bytes

add the patch for this functionality

amitaibu’s picture

amitaibu
Primary language Hebrew
Location Israel
CreditAttribution: amitaibu commented
Status: Active » Postponed (maintainer needs more info)

That sounds strange. What do you mean another module has used this index? If you look in Drupal core, the field names in the tables are not unique.

darren.ferguson’s picture

darren.ferguson CreditAttribution: darren.ferguson commented

What i mean is another module is using the index nid for another table hence this is causing confusion since two indexes on different tables can't be named the same. This is why i was suggesting adding the unique name too the index so the system will be able to distinguish and og_vocab will not cause this problem for the upgrade if another module is utilizing the same index name.

So the name itself must be unique and this is where the problem when i did the upgrade occurred.