<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" 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 12 (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:Tahoma;
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:12.0pt;
font-family:"Times New Roman","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-reply;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</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=Section1>
<p class=MsoNormal>When we recently upgraded from 3.8.4 to 4.0.2 we also
received:<o:p></o:p></p>
<p class=MsoNormal>[warning]: Couldn't set SortOrder: That is already the
current value (./etc/upgrade/3.8.8/content:32)<br>
<span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>and<o:p></o:p></span></p>
<p class=MsoNormal>[warning]: Use of uninitialized value in string eq at
/home/jared/rt-4.0.4/sbin/../lib/RT/Template.pm<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>With these, our RT instance runs fine.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I do not have any errors when trying to restart Apache
though. Just my $0.02 worth.<span style='font-size:11.0pt;font-family:
"Calibri","sans-serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Jared
Griffith<br>
<b>Sent:</b> Friday, November 18, 2011 12:46 PM<br>
<b>To:</b> rt-users@lists.bestpractical.com<br>
<b>Subject:</b> [rt-users] Upgrade from 3.6.11 to 4.0.4 More Errors<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Here's the entire situation.<br>
I have been tasked with migrating and upgrading our rt system to a new system,
complete with MySQL 5, CentOS 6, and all the latest and greatest. At this
point I have followed the README and the UPGRADING.mysql documentation and
followed everything there. When running make upgrade-database the first
time, and only upgrading to 3.7.87 after of course changing the MySQL default
character set, I did not receive any errors. Once I completed that, then
ran the <a href="http://upgrade-mysql-schema.pl">upgrade-mysql-schema.pl</a>
part, I came back to run the make upgrade-database again, and upon doing so got
the following errors:<br>
DB Upgrade Errors:<br>
make upgrade-database<br>
/usr/bin/perl -I/storage/www/rt3/local/lib -I/storage/www/rt3/lib
sbin/rt-setup-database --action upgrade --prompt-for-dba-password<br>
Odd number of elements in anonymous hash at
/home/jared/rt-4.0.4/sbin/../lib/RT/Config.pm line 1071.<br>
Use of uninitialized value $_[8] in anonymous hash ({}) at
/home/jared/rt-4.0.4/sbin/../lib/RT/Config.pm line 1071.<br>
Odd number of elements in hash assignment at
/home/jared/rt-4.0.4/sbin/../lib/RT/Config.pm line 1072.<br>
Use of uninitialized value within @_ in list assignment at
/home/jared/rt-4.0.4/sbin/../lib/RT/Config.pm line 1072.<br>
Subroutine _InitSQL redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm
line 63.<br>
Subroutine _SQLLimit redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 87.<br>
Subroutine _SQLJoin redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm
line 106.<br>
Subroutine _OpenParen redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 116.<br>
Subroutine _CloseParen redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 119.<br>
Subroutine _close_bundle redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 170.<br>
Subroutine _parser redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm
line 201.<br>
Subroutine ClausesToSQL redefined at
/storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm line 377.<br>
Subroutine FromSQL redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm
line 477.<br>
Subroutine Query redefined at /storage/www/rt3/lib/RT/Tickets_Overlay_SQL.pm
line 543.<br>
In order to create or update your RT database, this script needs to connect to
your mysql instance on localhost as root<br>
Please specify that user's database password below. If the user has no database<br>
password, just press return.<br>
<br>
Password:<br>
Working with:<br>
Type: mysql<br>
Host: localhost<br>
Name: rt3<br>
User: rt_user<br>
DBA: root<br>
Enter RT version you're upgrading from: 3.7.87<br>
<br>
Going to apply following upgrades:<br>
* 3.8.0<br>
* 3.8.1<br>
* 3.8.2<br>
* 3.8.3<br>
* 3.8.4<br>
* 3.8.6<br>
* 3.8.8<br>
* 3.8.9<br>
* 3.9.1<br>
* 3.9.2<br>
* 3.9.3<br>
* 3.9.5<br>
* 3.9.6<br>
* 3.9.7<br>
* 3.9.8<br>
* 4.0.0rc2<br>
* 4.0.0rc4<br>
* 4.0.0rc7<br>
* 4.0.1<br>
* 4.0.3<br>
* 4.0.4<br>
<br>
Enter RT version if you want to stop upgrade at some point,<br>
or leave it blank if you want apply above upgrades:<br>
<br>
IT'S VERY IMPORTANT TO BACK UP BEFORE THIS STEP<br>
<br>
Proceed [y/N]:y<br>
Processing 3.8.0<br>
Now inserting data.<br>
Processing 3.8.1<br>
Now inserting data.<br>
Processing 3.8.2<br>
Now inserting data.<br>
[Fri Nov 18 18:26:20 2011] [warning]: Going to add [OLD] prefix to all
templates in approvals queue. If you have never used approvals, you can safely
delete all the templates with the [OLD] prefix. Leave the new Approval
templates because you may eventually want to start using approvals.
(./etc/upgrade/3.8.2/content:3)<br>
[Fri Nov 18 18:26:21 2011] [warning]: IMPORTANT: We're going to delete all
scrips in Approvals queue and save them in 'rt-approvals-scrips-KyRb' file.
(./etc/upgrade/3.8.2/content:165)<br>
Processing 3.8.3<br>
Now inserting data.<br>
[Fri Nov 18 18:26:27 2011] [error]: Template not found
(/home/jared/rt-4.0.4/sbin/../lib/RT/Handle.pm:1037)<br>
Processing 3.8.4<br>
Now inserting data.<br>
Processing 3.8.6<br>
Now inserting data.<br>
Processing 3.8.8<br>
Now inserting data.<br>
[Fri Nov 18 18:26:44 2011] [warning]: Couldn't set SortOrder: That is already
the current value (./etc/upgrade/3.8.8/content:32)<br>
Processing 3.8.9<br>
Now inserting data.<br>
[Fri Nov 18 18:26:50 2011] [warning]: Resolver RT::URI::fsck_com_rt could not
parse fsck.com-rt://<a href="http://gdmxchange.com/ticket/">gdmxchange.com/ticket/</a>,
maybe Organization config was changed?
(/home/jared/rt-4.0.4/sbin/../lib/RT/URI.pm:146)<br>
[Fri Nov 18 18:26:50 2011] [warning]: Use of uninitialized value in string eq
at /home/jared/rt-4.0.4/sbin/../lib/RT/Template.pm line 627, <> line 1.
(/home/jared/rt-4.0.4/sbin/../lib/RT/Template.pm:627)<br>
[Fri Nov 18 18:26:50 2011] [warning]: Use of uninitialized value in string eq
at /home/jared/rt-4.0.4/sbin/../lib/RT/Template.pm line 627, <> line 1.
(/home/jared/rt-4.0.4/sbin/../lib/RT/Template.pm:627)<br>
[Fri Nov 18 18:26:50 2011] [warning]: Use of uninitialized value in string eq
at /home/jared/rt-4.0.4/sbin/../lib/RT/Template.pm line 627, <> line 1.
(/home/jared/rt-4.0.4/sbin/../lib/RT/Template.pm:627)<br>
Processing 3.9.1<br>
Now inserting data.<br>
Processing 3.9.2<br>
Now inserting data.<br>
Processing 3.9.3<br>
Now populating database schema.<br>
Processing 3.9.5<br>
Now populating database schema.<br>
Processing 3.9.6<br>
Now populating database schema.<br>
Processing 3.9.7<br>
Now populating database schema.<br>
Now inserting data.<br>
Processing 3.9.8<br>
Now populating database schema.<br>
Now inserting data.<br>
Processing 4.0.0rc2<br>
Now populating database schema.<br>
Processing 4.0.0rc4<br>
Now populating database schema.<br>
Processing 4.0.0rc7<br>
Now inserting data.<br>
Processing 4.0.1<br>
Now inserting data.<br>
Processing 4.0.3<br>
Now inserting data.<br>
Processing 4.0.4<br>
Now inserting data.<br>
Done.<br>
<br>
<br>
Is that normal to see those errors?<br>
<br>
Also, when restarting the Apache server, I am getting the following errors from
that:<br>
HTTPD Restart<br>
Starting httpd: Odd number of elements in anonymous hash at
/storage/www/rt3/sbin/../lib/RT/Config.pm line 1071.<br>
Use of uninitialized value $_[8] in anonymous hash ({}) at
/storage/www/rt3/sbin/../lib/RT/Config.pm line 1071.<br>
Odd number of elements in hash assignment at
/storage/www/rt3/sbin/../lib/RT/Config.pm line 1072.<br>
Use of uninitialized value within @_ in list assignment at
/storage/www/rt3/sbin/../lib/RT/Config.pm line 1072.<br>
<br>
Is that normal as well?<br>
<br>
Another fun fact is that I also moved the install from the default /opt to the
/storage location in the error messages. Would this be causing the issues
even though when I ran the configure I made sure to specify the new location?<br>
<br>
<br>
<br clear=all>
<br>
-- <br>
- Thanks for your time<br>
- Jared B. Griffith<br>
- Email - <a href="mailto:jared.b.griffith@gmail.com" target="_blank">jared.b.griffith@gmail.com</a><br>
- Cell Phone - 909-653-7814<o:p></o:p></p>
</div>
</body>
</html>