Paul Fincher <pfincher <at> ghs.com> writes:
> > Kevin, > > Thanks you are right. I had written down that I changed the schema > (from when installing 3.8.8 when I went digging through the list and found > the solution) but didn't make note of when or where I changed them. > > Thanks again! > Paul > -----Original Message----- > From: rt-users-bounces <at> lists.bestpractical.com > [mailto:rt-users-bounces <at> lists.bestpractical.com] On Behalf Of Kevin Falcone > Sent: Thursday, March 24, 2011 6:06 PM > To: rt-users <at> lists.bestpractical.com > Subject: Re: [rt-users] RT 3.8.9 Installation > > On Thu, Mar 24, 2011 at 05:31:44PM -0400, Paul Fincher wrote: > > I knew from my 3.8.8 install that I needed to change the schema from > "TYPE=InnoDB" to > > "ENGINE=InnoDB" and I did that both in ./etc/schema.mysql-4.0 and > ./etc/schema.mysql-4.1. I > > am using mysql version 5.5.10 (I used 5.5.8 on my test machine). Any > insight would be > > appreciated > > I suspect you changed them after typing make install and that you actually > need to fix /opt/rt3/etc/schema.mysql-4.1 > > -kevin > > Hey Guys I have searched all over for the fix for Now creating a mysql database rt3 for RT. Done. Now populating database schema. DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB CHARACTER SET utf8' at line 15 at /tmp/rt- 3.8.10/sbin/../lib/RT/Handle.pm line 516. make: *** [initialize-database] Error 255 i have already changed all instances of TYPE=InnoDB to ENGINE=InnoDB in my /opt/rt3/etc/schema.mysql-4.1 but the error persists. i am trying to install rt 3.8.10 on ubuntu 12.04 mysql version is 5.5.29 Perhaps if someone has an idea how i can fix this i would really appreciate the help -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services/training.html Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T
