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 <[EMAIL PROTECTED]> Date: Mar 20, 2006 9:58 AM Subject: mysql 4 upgrade issue Duplicate key name 'we_status_idx' To: [email protected] 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.
