OG Vocab Index should have a unique name based off table name
darren.ferguson - May 14, 2009 - 19:36
| Project: | OG Vocabulary |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | darren.ferguson |
| Status: | postponed (maintainer needs more info) |
Description
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.
#1
add the patch for this functionality
#2
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.
#3
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.