On Thu, Feb 14, 2013 at 08:30:46AM +0000, Martin wrote: > 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
Why are you installing 3.8.10? The current release of RT is 4.0.10, the current release of the 3.8 series is 3.8.16 (and both include fixes for this). Your problem is likely because you are editing the file in /opt/rt3/etc/schema.mysql-4.1 rather than /tmp/rt-3.8.10/etc/schema.mysql-4.1 but that doesn't explain installing a version of RT which has multiple known security flaws. -kevin
pgp71roa4XfY1.pgp
Description: PGP signature
-- 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