I am running a fresh installation of DokuWiki from a bitnami LAMP stack launched on Google Cloud Platform (Release 2018-04-22b "Greebo"). The only plugin I have installed, aside from the bundled ones, is the Statistics plugin (
https://www.dokuwiki.org/plugin:statistics)
I've followed the documentation on connecting a mysql db to the DokuWiki plugin and it seems like it is working because some stats are generated and graphics too.
BUT
I get the following error message when saving a page and I have no idea on how to even start troubleshooting.
DB Error: Field 'dt' doesn't have a default value REPLACE INTO stats_lastseen SET `user` = 'admin'
I also get this message on my dashboard!
DB Error: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'stats.B.ref' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT COUNT(*) as cnt, ref as url FROM stats_access as B, stats_refseen as A WHERE A.dt >= '2019-08-07 00:00:00' AND A.dt <= '2019-08-07 23:59:59' AND ua_type = 'browser' AND ref_type = 'external' AND A.ref_md5 = B.ref_md5 GROUP BY A.ref_md5 ORDER BY cnt DESC, url LIMIT 0,16
Anybody have any clues?
I think an issue might be the following: I am using mysql and not mariadb
/opt/bitnami/mysql/bin/mysql.bin Ver 8.0.16 for linux-glibc2.12 on x86_64 (MySQL Community Server - GPL)