Not logged in. · Lost password · Register
Forum: General Help and Support Plugins RSS
Statistics Plugin Errors
Database seems to connect well, but weird error messages appear
Avatar
cgalo #1
Member since Nov 2018 · 4 posts
Group memberships: Members
Show profile · Link to this post
Subject: Statistics Plugin Errors
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)
Close Smaller – Larger + Reply to this post:
Verification code: VeriCode Please enter the word from the image into the text field below. (Type the letters only, lower case is okay.)
Smileys: :-) ;-) :-D :-p :blush: :cool: :rolleyes: :huh: :-/ <_< :-( :'( :#: :scared: 8-( :nuts: :-O
Special characters:
Go to forum
Imprint
This board is powered by the Unclassified NewsBoard software, 20150713-dev, © 2003-2015 by Yves Goergen
Current time: 2019-10-16, 19:24:08 (UTC +02:00)