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

[Kevin Falcone]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 235 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131030/57be3227/attachment.sig>