Trenton,
Did you get an answer to this? I just finished the same upgrade. We use Oracle. Kenn LBNL On 4/17/2008 8:30 AM, Trenton Taylor wrote: > I’m trying to upgrade my RT system from 3.4.5 to 3.6.4 via: > > > > # command: > > /opt/rt3.6/sbin/rt-setup-database --action schema \ --datadir > etc/upgrade/3.5.1 --dba root --prompt-for-dba-password > > > > But I am getting this error: > > > > #: > > Creating database schema. > > Problem with statement: > > > > > > CREATE TABLE Attachments ( > > id INTEGER NOT NULL AUTO_INCREMENT, > > TransactionId integer NOT NULL , > > Parent integer NOT NULL DEFAULT 0 , > > MessageId varchar(160) NULL , > > Subject varchar(255) NULL , > > Filename varchar(255) NULL , > > ContentType varchar(80) NULL , > > ContentEncoding varchar(80) NULL , > > Content LONGTEXT NULL , > > Headers LONGTEXT NULL , > > Creator integer NOT NULL DEFAULT 0 , > > Created DATETIME NULL , > > PRIMARY KEY (id) > > ) TYPE=InnoDB > > Table 'Attachments' already exists at /opt/rt3.6/sbin/rt-setup-database > line 220, <SCHEMA> line 464. > > > > > > Thanks in advance – > > Trent > > > > > Important: The information contained in this e-mail message is > confidential and is intended only for the named addressee(s). If the > reader of this e-mail message is not an intended recipient (or the > individual responsible for the delivery of this e-mail message to an > intended recipient), please be advised that any re-use, dissemination, > distribution or copying of this e-mail message is prohibited. If you > have received this e-mail message in error, please reply to the sender > that you have received the message in error and then delete it. Thank you. > > > ------------------------------------------------------------------------ > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: [EMAIL PROTECTED] > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com