mysql 4 upgrade issue Duplicate key name 'we_status_idx'

I'm upgrading from 1.1 to 2.1.1 on mysql 4.1.16

I ran the upgrade scripts as specified.

both with and without the
"alternate-130-to-200-mysql-only" script from
the
20 upgrade guide..


On the upgrade from 2.0 to 2.1.1

I get the following error.

ERROR 1061 (42000): Duplicate key name 'we_status_idx'
Query OK, 20 rows affected (0.02 sec)
Records: 20  Duplicates: 0  Warnings: 0

mysql> Aborted

Site loads, but blogs have no themes.

There was a posts by Matt/Anil about this a few months ago,
and it seemed to
be resolved.
Are the mysql scripts correct?


Also,

In the upgrade guide, you suggest an "alternate"
130-to-200 script.  Use of
the term alternate implies that it should be used INSTEAD of
the standard
script.  I suggest you call this an ADDITIONAL
130-200-mysql-migration
script, since it the std 130-200 script needs to be run
first.

Found the problem:

Both
130-to200-migration.sql
and
200-to-210-migration.sql

have the following line:

-- create index we_status_idx on weblogentry(status);

Dave

---------- Forwarded message ----------
From: Dave Lindsey <velodivergmail.com>
Date: Mar 20, 2006 9:58 AM
Subject: mysql 4 upgrade issue Duplicate key name
'we_status_idx'
To: roller-devincubator.apache.org

I'm upgrading from 1.1 to 2.1.1 on mysql 4.1.16

I ran the upgrade scripts as specified.

both with and without the
"alternate-130-to-200-mysql-only" script from
the
20 upgrade guide..


On the upgrade from 2.0 to 2.1.1

I get the following error.

ERROR 1061 (42000): Duplicate key name 'we_status_idx'
Query OK, 20 rows affected (0.02 sec)
Records: 20  Duplicates: 0  Warnings: 0

mysql> Aborted

Site loads, but blogs have no themes.

There was a posts by Matt/Anil about this a few months ago,
and it seemed to
be resolved.
Are the mysql scripts correct?


Also,

In the upgrade guide, you suggest an "alternate"
130-to-200 script.  Use of
the term alternate implies that it should be used INSTEAD of
the standard
script.  I suggest you call this an ADDITIONAL
130-200-mysql-migration
script, since it the std 130-200 script needs to be run
first.