<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from rtf -->
<style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<font face="Calibri" size="2"><span style="font-size:11pt;">
<div>After some further troubleshooting I have determined that email from the upgraded 4.2.0 instance is in fact working (testing with dashboard subs), but that no scrips execute. The bulk of errors in my debug log are:</div>
<div><font face="Courier New" size="1"><span style="font-size:8pt;">[6973] [Tue Oct 29 21:24:15 2013] [warning]: DBD::mysql::st execute failed: 'rt_helpdesk_420.main.Name' isn't in GROUP BY at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 589. (/usr/local/share/perl5/</span></font></div>
<div><font face="Courier New" size="1"><span style="font-size:8pt;">DBIx/SearchBuilder/Handle.pm:589)</span></font></div>
<div><font face="Courier New" size="1"><span style="font-size:8pt;">[6973] [Tue Oct 29 21:24:15 2013] [warning]: RT::Handle=HASH(0x7fd5eea7f588) couldn't execute the query 'SELECT main.* FROM CustomFields main JOIN ObjectCustomFields ObjectCustomFields_1 ON
( ObjectCustomFields</span></font></div>
<div><font face="Courier New" size="1"><span style="font-size:8pt;">_1.CustomField = main.id ) WHERE (ObjectCustomFields_1.ObjectId = '1' OR ObjectCustomFields_1.ObjectId = '0') AND (main.Disabled = '0') AND (main.LookupType = 'RT::Queue-RT::Ticket') AND (main.id
= '0') GROUP </span></font></div>
<div><font face="Courier New" size="1"><span style="font-size:8pt;">BY main.id ORDER BY MIN(ObjectCustomFields_1.SortOrder) ASC ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 602.</span></font></div>
<div> </div>
<div>I am unable to determine the impact of these warnings or if they are the culprit. Full log can also be seen in previous communication. </div>
<div> </div>
<div>-----Original Message-----<br>
From: rt-users-bounces@lists.bestpractical.com [<a href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>] On Behalf Of Wright, Cory (CDC/OID/NCIRD) (CTR)<br>
Sent: Monday, October 28, 2013 12:17 PM<br>
To: 'Alex Vandiver'<br>
Cc: rt-users@lists.bestpractical.com<br>
Subject: Re: [rt-users] Upgrading 4.0.8 -> 4.2.0 breaking outgoing email</div>
<div> </div>
<div>DBIx::SearchBuilder 1.65 /usr/local/share/perl5/DBIx/SearchBuilder.pm</div>
<div> </div>
<div>make testdeps indicated no problems, nor did make upgrade-database. </div>
<div> </div>
<div>J. Cory Wright, RHCE | SRA Contractor | Mobile: 404-268-3402 | Email: <a href="mailto:nextgensupport@cdc.gov">nextgensupport@cdc.gov</a> | Ticket: <a href="mailto:scicompsupport@mail.biotech.cdc.gov">scicompsupport@mail.biotech.cdc.gov</a></div>
<div> </div>
<div> </div>
<div>-----Original Message-----</div>
<div>From: Alex Vandiver [<a href="mailto:alexmv@bestpractical.com">mailto:alexmv@bestpractical.com</a>]</div>
<div>Sent: Monday, October 28, 2013 12:10 PM</div>
<div>To: Wright, Cory (CDC/OID/NCIRD) (CTR)</div>
<div>Cc: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a></div>
<div>Subject: RE: [rt-users] Upgrading 4.0.8 -> 4.2.0 breaking outgoing email</div>
<div> </div>
<div>On Mon, 2013-10-28 at 12:58 +0000, Wright, Cory (CDC/OID/NCIRD) (CTR)</div>
<div>wrote:</div>
<div>> Thanks Alex -- what's attached is me logging in and performing one </div>
<div>> correspond in which I expect an email. Hostnames/IPs/db names have </div>
<div>> been anonymized.</div>
<div> </div>
<div>Your logs are chock full of SQL statement execution errors, which should have been difficult to miss.</div>
<div> Double-check that you have the sufficient version for all of RT's dependencies. Specifically, what version of DBIx::SearchBuilder are you running? You can determine this by going to Admin → Tools → System Configuration, and searching for "DBIx::SearchBuilder"
in the "Loaded perl modules" section.</div>
<div> - Alex</div>
<div> </div>
<div> </div>
</span></font>
</body>
</html>