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: [email protected] [mailto:[email protected]] On Behalf Of Wright, Cory (CDC/OID/NCIRD) (CTR) Sent: Monday, October 28, 2013 12:17 PM To: 'Alex Vandiver' Cc: [email protected] 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: [email protected]<mailto:[email protected]> | Ticket: [email protected]<mailto:[email protected]> -----Original Message----- From: Alex Vandiver [mailto:[email protected]] Sent: Monday, October 28, 2013 12:10 PM To: Wright, Cory (CDC/OID/NCIRD) (CTR) Cc: [email protected]<mailto:[email protected]> 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
