On Tue, Oct 29, 2013 at 09:32:20PM +0000, Wright, Cory (CDC/OID/NCIRD) (CTR) wrote: > 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.
These warnings are almost certainly a culprit. What version of mysql and what non-standard options are you using? On a stock 5.5.27 your query runs fine. -kevin
pgpdeAW5D3V4X.pgp
Description: PGP signature
