Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.
Please keep in mind:
Support response
Support checklist
This seems to be a bug related to newer MySQL versions. The conflicting code (stats stuff) is present in the code way before v3.9.0 so the bug is older than this new release.
Can you indicate which mysql version are you running?
sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
I'm also finding that MySQL 5.7.14 throws an error related to sql-mode "ONLY_FULL_GROUP_BY". My advice is to remove that mode for now because I've to review all the queries to make them fully compatible with SQL92.
Having said that, the safe MySQL mode is this one:
Code:sql-mode="STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_DATE,NO_ZERO_IN_DATE,NO_AUTO_CREATE_USER"
You should use that mode in your MySQL ini file. If you can change that file, then try to use an older MySQL version.
("1", "0000-00-00", "total")
("1", NULL, "total")
This is not a bug, is just you using outdated stuff.
Chevereto v3.8.0 added this statement:
Code:("1", "0000-00-00", "total")
But in v3.8.1 (very next to v3.8.0) it was changed to:
Code:("1", NULL, "total")
So if you get this MySQL error is because you did something that broke this stuff. Bottom line is that this is not a bug.
If you are still able to get that error then please go to install/?debug and paste that output here, that helps me to check which queries are being populated by the installer.
Cheers,
Rodolfo.