I started with 4.7.0.
I ugpgraded to 4.7.1
I got the error.
I compared the 4.7.0 database ddl to the 4.7.1 ddl and made the change that failed using a sql client.
Geoff
Gerhard Killesreiter wrote:
Geoff Staples wrote:
In upgrading from drupal 4.7.0 to 4.7.1, I got the database error below.
It looks like the column vid was already added and the data from uid copied as per the update code. I had to manually modify the table to make vid unique.
Geoff
php Date Saturday, May 27, 2006 - 21:10 User admin http://www.greatresultsmarketing.com/?q=user/1 Location http://www.xxxxx.com/update.php?op=do_update http://www.greatresultsmarketing.com/update.php?op=do_update Referrer http://www.xxxxx.com/update.php?op=selection http://www.greatresultsmarketing.com/update.php?op=selection Message Duplicate key name 'vid' query: ALTER TABLE node ADD UNIQUE (vid) in /services/webpages/x/x/xxxx.com/public/includes/database.mysql.inc on line 120.
Geoff, Drupal had contained a line to drop the index before the release. My tests revealed that this index was not present when I created a fresh 4.6.7 site and then upgraded to 4.7.1, thus I removed this line. Can you tell me about the development of your site? At which version did you start? Did you apply database changes outside from Drupal's update.php?
Cheers, Gerhard