<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hello,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> We have been testing out RT 3.8.8 for the last couple of months on a test machine and find that it is going to help us. Now that we are ready to put RT in production we are installing 3.8.9 on the production machine as we want to have the latest bug fixes and improvements. I am running into a problem while initializing the database:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Working with:<o:p></o:p></p><p class=MsoNormal>Type: mysql<o:p></o:p></p><p class=MsoNormal>Host: localhost<o:p></o:p></p><p class=MsoNormal>Name: rt3<o:p></o:p></p><p class=MsoNormal>User: rt_user<o:p></o:p></p><p class=MsoNormal>DBA: sqladmin<o:p></o:p></p><p class=MsoNormal>Now creating a mysql database rt3 for RT.<o:p></o:p></p><p class=MsoNormal>Done.<o:p></o:p></p><p class=MsoNormal>Now populating database schema.<o:p></o:p></p><p class=MsoNormal>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/local/src/rt-3.8.9/sbin/../lib/RT/Handle.pm line 515.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> 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<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regards,<o:p></o:p></p><p class=MsoNormal>Paul <o:p></o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>-------------------------------------------------------------<br>Paul Fincher<br>Senior Engineering Support Engineer<br>Green Hills Software - <a href="blocked::http://www.ghs.com/"><span style='color:blue'>http://www.ghs.com</span></a><br>34125 US Hwy 19 North Suite 100<br>Palm Harbor, FL 34684<br>(727) 781-4909<br>-------------------------------------------------------------<br><br></span><o:p></o:p></p></div></body></html>