[rt-users] Upgrading - 3.6.5 - 3.8.2

[Jesse Vincent]

On Mon, Mar 16, 2009 at 11:30:22PM +1200, Aaron Guise wrote:
> Hi,
> In following the upgrade docs we apply updates to schema with
>  /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
> --action upgrade
> 
> But this gives me error below.  Any ideas how I could progress past this
> issue?
> 

That suggests you've tried to run the update before or manually added an
index. You might try a "DROP INDEX CachedGroupMembers3;" and starting
over from where the upgrade bailed out.

> Output from console;
> 
> Processing 3.7.1
> Now inserting data
> Processing 3.7.3
> Now populating database schema.
> Processing 3.7.10
> Now inserting data
> Processing 3.7.15
> Now inserting data
> Processing 3.7.19
> Now inserting data
> Processing 3.7.81
> Now populating database schema.
> [Mon Mar 16 11:26:16 2009] [crit]: DBD::mysql::st execute failed: Duplicate
> key name 'CachedGroupMembers3' at /opt/rt3/sbin/../lib/RT/Handle.pm line
> 506. (/opt/rt3/sbin/../lib/RT.pm:377)
> DBD::mysql::st execute failed: Duplicate key name 'CachedGroupMembers3' at
> /opt/rt3/sbin/../lib/RT/Handle.pm line 506.

> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com

--