Comment 42 for bug 1578144

Revision history for this message
Paul Gevers (paul-climbing) wrote : Re: [Bug 1578144] Re: cacti and cacti-spine are not compatible with MySQL 5.7 default sql_mode

Hi Lygie,

On 28-05-16 10:23, lygie wrote:
> I found another issue.

Thanks for reporting this.

> Some selects fail because of MYSQLs "ONLY_FULL_GROUP_BY" mode.

I decided to run my new cacti autopkgtest on the xenial version (why
didn't I do that before, I wonder), and found some more... The annoying
thing is, the test passes, but there are errors in the cacti.log.

The following error numbers show up:
Error:'1054'
Error:'1055' <- the one found by you
Error:'1062'
Error:'1064'

I'll dive into it, but I don't mind advice from readers here. I read
some of the documentation with respect to what ONLY_FULL_GROUP_BY is
protecting us from and I will try to figure out if it isn't pointing at
a bugs in cacti. Probably the same goes for the other errors.

Paul

Note to self: let the autopkgtest also check the log for errors, just
filed as Debian bug 825644¹.

¹ https://bugs.debian.org/825644