[rt-users] Upgrade error

[Justin Zygmont]

I've noticed similar problems like this in the past, you have to keep 
trying with action acl, and insert in different order.  If you keep 
trying it, then finally it will go.



Yevgeniy Busel wrote:
> Hi there,
> I upgraded from RT 3.0.11 to 3.4.4, but when I try to upgrade my 
> database, I'm getting this error:
>  
>  /usr/local/rt3/sbin/rt-setup-database --action schema --datadir 
> /usr/local/rt3/etc/upgrade/3.1.0
> Creating database schema.
> Problem with statement:
> 
> CREATE TABLE Attributes (
>   id INTEGER NOT NULL  AUTO_INCREMENT,
>   Name varchar(255) NULL  ,
>   Description varchar(255) NULL  ,
>   Content text,
>   ContentType varchar(16),
>   ObjectType varchar(64),
>   ObjectId integer,
>   Creator integer NOT NULL DEFAULT 0  ,
>   Created DATETIME NULL  ,
>   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
>   LastUpdated DATETIME NULL  ,
>   PRIMARY KEY (id)
> ) TYPE=InnoDB
> Table 'Attributes' already exists at 
> /usr/local/rt3/sbin/rt-setup-database line 205.
>  
> Any ideas how to solve this?  Thank you in advance.
> Yevgeniy Busel
> Network/System Administrator
> yevgeniy.busel at akqa.com <mailto:yevgeniy.busel at akqa.com>
>  
> AKQA Inc.,
> 118 King Street, 6th Floor
> San Francisco, CA 94107
> Tel: 415.645.9483   Fax: 415.645.9420    www.akqa.com <http://www.akqa.com/>
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> 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
> 
> 
> We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html