<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
In upgrading from drupal 4.7.0 to 4.7.1, I got the database error below.<br>
<br>
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.<br>
<br>
Geoff<br>
<br>
<table class="watchdog-event">
<tbody>
<tr class="even">
<td>php</td>
</tr>
<tr class="odd">
<th>Date</th>
<td>Saturday, May 27, 2006 - 21:10</td>
</tr>
<tr class="even">
<th>User</th>
<td><a href="http://www.greatresultsmarketing.com/?q=user/1"
title="View user profile.">admin</a></td>
</tr>
<tr class="odd">
<th>Location</th>
<td><a
href="http://www.greatresultsmarketing.com/update.php?op=do_update">http://www.xxxxx.com/update.php?op=do_update</a></td>
</tr>
<tr class="even">
<th>Referrer</th>
<td><a
href="http://www.greatresultsmarketing.com/update.php?op=selection">http://www.xxxxx.com/update.php?op=selection</a></td>
</tr>
<tr class="odd">
<th>Message</th>
<td>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.</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<pre class="moz-signature" cols="72">--
Geoff Staples
Warning. Use this email system for confidential communications at your own risk. The President of the United States has issued an executive order allowing the National Security Agency to surveil domestic email, telephonic communication, U. S. Mail and all other forms of communicaton. Although no communication can be guaranteed to be secure, confidential communications made in person at an unknown location arranged via pigeon carrier, smoke signal, or commercial courier are suggested.
</pre>
</body>
</html>