[drupal-support] Upgrading database from 4.5.4 to 4.6.2 (was Psychophobia)

[sunblockster at gmail.com]

First, a *huge* thank you to everyone on the list who has helped us  
resurrect our site after the hack, especially to Gerhard. It's always  
amazing to experience the support of the OSS community.

I think we are almost there. I upgraded from 4.3.x to 4.4 to 4.5.4  
without a hitch--an exhilirating feeling.

I just ran the 4.6.2 upgrade.php on the database, choosing the first  
update after the 4.5 release.

Everything went well until here:


> 2005-03-21
>
> user error: Duplicate entry '0-11' for key 1
> query: ALTER TABLE term_node ADD PRIMARY KEY (tid,nid) in /path/to/ 
> file/www/drupal462/includes/database.mysql.inc on line 66.
>
> ALTER TABLE {term_node} ADD PRIMARY KEY (tid,nid)
> FAILED
>
> 2005-04-14
>
> 2005-05-06
>
> 2005-05-07
>
> ALTER TABLE {locales_source} CHANGE location location varchar(255)  
> NOT NULL default ''
> OK
>


Any ideas why this failed, and how to fix it?

Many thanks.




On Jul 20, 2005, at 5:04 PM, Gerhard Killesreiter wrote:


>
>
> On Wed, 20 Jul 2005 sunblockster at gmail.com wrote:
>
>
>
>> A 4.4 tarball would be great if you think that would do the trick.
>> How do we work that?
>>
>>
>
> http://tfp1.physik.uni-freiburg.de/~killes/drupal-4.4.tar.gz
>
> You need to pay attention for the start of the update from 4.5 to  
> 4.6. You
> need to select the first after the 4.5 release.
>
> Cheers,
>     Gerhard
>
>