[rt-users] RT 3.8.9 Installation

[Kevin Falcone]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130214/0970c20f/attachment.sig>