After having a problem with a FreeBSD 7.3 install of RT-3.8.6, I got the
boss to agree to do a complete fresh install of the new RT-3.8.8. I have
all my config files backed up and ready to go, however after checking
a clean make testdeps, and make dropdb of the old rt3 database I just
get so far in running “make initialize-database” before I get this
I cannot seem to find where to fix it:
****** snip *******
/usr/bin/perl -I/opt/rt3/local/lib -I/opt/rt3/lib sbin/rt-setup-database
–action init --dba root --prompt-for-dba-password
In order to create or update your RT database, this script needs to
connect to your mysql instance on localhost as root
Please specify that user’s database password below. If the user has no
password, just press return.
Now creating a mysql database rt3 for RT.
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
/usr/src/rt-3.8.8/sbin/…/lib/RT/Handle.pm line 506.
*** Error code 255
Stop in /usr/src/rt-3.8.8.
******** snip *******
I have checked that line indicated in the error and the script - It
appears this is a
"cascade" error from somewhere else. Any suggestions greatly appreciated.