malspider
malspider copied to clipboard
incompatibility with "only_full_group_by"
The only_full_group_by mode is a default for recent version of mysql Reporting alerts fails with ""Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'malspider.alert.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by""
=> temporary solution: edit the my.cnf to force the sql mode check current mode with select @@sql_mode (can be edited manually for the session - maybe a fix to implement instead of fixing all sql queries)
Thank you for the suggestion. I'll add this to my list for this week.
On Sat, Feb 25, 2017 at 8:39 AM, vletoux [email protected] wrote:
The only_full_group_by mode is a default for recent version of mysql Reporting alerts fails with ""Expression #1 https://github.com/ciscocsirt/malspider/pull/1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'malspider.alert.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by""
=> temporary solution: edit the my.cnf to force the sql mode check current mode with select @@sql_mode (can be edited manually for the session - maybe a fix to implement instead of fixing all sql queries)
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ciscocsirt/malspider/issues/23, or mute the thread https://github.com/notifications/unsubscribe-auth/AR0QEFAeGp2_IX9heCTSYrAcGnlBIZ-cks5rgC8fgaJpZM4MMA66 .