Thanks Drew - All I had to do was alter each RT3 table and convert them to the InnoDB engine - restart mysql and it worked fine after that.
Thanks again, -Adam -----Original Message----- From: Drew Barnes [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 1:54 PM To: Adam Savage Cc: [email protected] Subject: Re: [rt-users] Problem after upgrade I believe mysql usually compiles with innodb support. If this is the case on your install, you can just alter the tables. Adam Savage wrote: > Does that mean I'll have to recompile mysql with the INNODB? > > > Thanks! > > > -----Original Message----- > From: Drew Barnes [mailto:[EMAIL PROTECTED] > Sent: Monday, September 17, 2007 1:21 PM > To: Adam Savage > Cc: [email protected] > Subject: Re: [rt-users] Problem after upgrade > > I think this happens when your db tables are not type INNODB. > > Perhaps someone can correct me (as often seems to happen) if I am wrong. > > Adam Savage wrote: > >> Hello – I recently just upgraded from version 3.0.10 to 3.6.3.. I >> migrated to a new server – moved the database over – did all the >> schema/content/acl updates needed for each revision – and the problem >> is whenever I click on Comment or Reply it will create an entry in the >> ticket when I clicked on the links “comment” or “reply” – without >> typing anything in yet and submitting. Once I do submit it will create >> another entry in the ticket with the actual submission information but >> it will list an extra empty “comment added” or “correspondence added” >> entry directly above the new entry.. >> >> >> >> Any ideas? >> >> >> >> Thanks, >> >> >> >> Adam >> >> ------------------------------------------------------------------------ >> >> _______________________________________________ >> 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
_______________________________________________ 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
