<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;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 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;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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">I’m getting an error when doing upgrade-database on a 4.2 installation.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am coming from 4.0.7 and I am able to successfully upgrade to 4.0.18 without error.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This is the message I’m getting after doing ‘make upgrade-database’<span style="color:#1F497D"> (highlighted below):
</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">/usr/bin/perl -I/opt/rt4/local/lib -I/opt/rt4/lib sbin/rt-setup-database --action upgrade --prompt-for-dba-password<o:p></o:p></p>
<p class="MsoNormal">In order to create or update your RT database, this script needs to connect to your mysql instance on localhost (port '') as root<o:p></o:p></p>
<p class="MsoNormal">Please specify that user's database password below. If the user has no database<o:p></o:p></p>
<p class="MsoNormal">password, just press return.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Password:<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">Port:<o:p></o:p></p>
<p class="MsoNormal">Name: rt4<o:p></o:p></p>
<p class="MsoNormal">User: rt_user<o:p></o:p></p>
<p class="MsoNormal">DBA: root<o:p></o:p></p>
<p class="MsoNormal">Enter RT version you're upgrading from: 4.0.18<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Going to apply following upgrades:<o:p></o:p></p>
<p class="MsoNormal">* 4.1.0<o:p></o:p></p>
<p class="MsoNormal">* 4.1.1<o:p></o:p></p>
<p class="MsoNormal">* 4.1.4<o:p></o:p></p>
<p class="MsoNormal">* 4.1.5<o:p></o:p></p>
<p class="MsoNormal">* 4.1.6<o:p></o:p></p>
<p class="MsoNormal">* 4.1.7<o:p></o:p></p>
<p class="MsoNormal">* 4.1.8<o:p></o:p></p>
<p class="MsoNormal">* 4.1.9<o:p></o:p></p>
<p class="MsoNormal">* 4.1.10<o:p></o:p></p>
<p class="MsoNormal">* 4.1.11<o:p></o:p></p>
<p class="MsoNormal">* 4.1.12<o:p></o:p></p>
<p class="MsoNormal">* 4.1.13<o:p></o:p></p>
<p class="MsoNormal">* 4.1.14<o:p></o:p></p>
<p class="MsoNormal">* 4.1.15<o:p></o:p></p>
<p class="MsoNormal">* 4.1.16<o:p></o:p></p>
<p class="MsoNormal">* 4.1.17<o:p></o:p></p>
<p class="MsoNormal">* 4.1.18<o:p></o:p></p>
<p class="MsoNormal">* 4.1.19<o:p></o:p></p>
<p class="MsoNormal">* 4.1.20<o:p></o:p></p>
<p class="MsoNormal">* 4.1.21<o:p></o:p></p>
<p class="MsoNormal">* 4.1.22<o:p></o:p></p>
<p class="MsoNormal">* 4.1.23<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Enter RT version if you want to stop upgrade at some point,<o:p></o:p></p>
<p class="MsoNormal"> or leave it blank if you want apply above upgrades:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Proceed [y/N]:y<o:p></o:p></p>
<p class="MsoNormal">Processing 4.1.0<o:p></o:p></p>
<p class="MsoNormal">Now inserting data.<o:p></o:p></p>
<p class="MsoNormal">Processing 4.1.1<o:p></o:p></p>
<p class="MsoNormal">Now populating database schema.<o:p></o:p></p>
<p class="MsoNormal"><span style="background:yellow;mso-highlight:yellow">[18504] [Wed Nov 20 17:27:58 2013] [critical]: DBD::mysql::st execute failed: Table 'ObjectScrips' already exists at /tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm line 526. (/tmp/rt-4.2.0/sbin/../lib/RT.pm:391)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="background:yellow;mso-highlight:yellow">DBD::mysql::st execute failed: Table 'ObjectScrips' already exists at /tmp/rt-4.2.0/sbin/../lib/RT/Handle.pm line 526.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="background:yellow;mso-highlight:yellow">make: *** [upgrade-database] Error 255</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Any help/input would be greatly appreciated. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><i><span style="font-size:14.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Adam Hutchins</span></i></b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">, Systems Administrator<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Town of Kernersville, NC, USA<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">o-336.992.5456 m-336.529.7164<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1">This email message, and any attachment(s) hereto, as well as any email message(s) that may be sent in response to it, may be considered Public Record, and as such are subject to requests for review. If you are not the
intended recipient, please destroy this message and inform the sender immediately. The information contained in this email may be confidential and, in any event, is intended only for the use of the entity or individual to whom it is addressed. Thank you.<br>
</font>
</body>
</html>