[rt-users] Upgrading 4.0.8 -> 4.2.0 breaking outgoing email

[Wright, Cory (CDC/OID/NCIRD) (CTR)]

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:
[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/
DBIx/SearchBuilder/Handle.pm:589)
[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
_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
BY main.id  ORDER BY MIN(ObjectCustomFields_1.SortOrder) ASC ' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 602.

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.

-----Original Message-----
From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Wright, Cory (CDC/OID/NCIRD) (CTR)
Sent: Monday, October 28, 2013 12:17 PM
To: 'Alex Vandiver'
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] Upgrading 4.0.8 -> 4.2.0 breaking outgoing email

DBIx::SearchBuilder     1.65    /usr/local/share/perl5/DBIx/SearchBuilder.pm

make testdeps indicated no problems, nor did make upgrade-database.

J. Cory Wright, RHCE | SRA Contractor | Mobile: 404-268-3402 | Email: nextgensupport at cdc.gov<mailto:nextgensupport at cdc.gov> | Ticket: scicompsupport at mail.biotech.cdc.gov<mailto:scicompsupport at mail.biotech.cdc.gov>


-----Original Message-----
From: Alex Vandiver [mailto:alexmv at bestpractical.com]
Sent: Monday, October 28, 2013 12:10 PM
To: Wright, Cory (CDC/OID/NCIRD) (CTR)
Cc: rt-users at lists.bestpractical.com<mailto:rt-users at lists.bestpractical.com>
Subject: RE: [rt-users] Upgrading 4.0.8 -> 4.2.0 breaking outgoing email

On Mon, 2013-10-28 at 12:58 +0000, Wright, Cory (CDC/OID/NCIRD) (CTR)
wrote:
> Thanks Alex -- what's attached is me logging in and performing one
> correspond in which I expect an email.  Hostnames/IPs/db names have
> been anonymized.

Your logs are chock full of SQL statement execution errors, which should have been difficult to miss.
  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.
 - Alex


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131029/1b37f43b/attachment.htm>