EDIT
Resolved after I modified “/etc/mysql/mysql.conf.d/mysqld.cnf"
Added last line: sql_mode = ""
/EDIT
Describe the bug
I installed Libki via "wget -O- install.libki.org | bash" on a fresh Ubuntu 20.04 server. Upon accessing the web interface, the Statistics tab results in the "(en) Please come back later" screen.
Expected behavior
Expected to view statistics.
Deployment architecture:
OS: Ubuntu Live server 20.04
Deployment style: One-step automatic install
Desktop (please complete the following information):
OS: Manjaro
Browser: Brave, Firefox
Libki log file:
[2023/01/26 15:48:01] [libki] [ERROR] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'libki.me.client_location' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [for Statement "SELECT me.client_name, COUNT( * ), me.client_location FROM statisticsme WHERE ( ( action = ? AND ( created_on <= ? AND created_on >= ? ) AND instance = ? ) ) GROUP BY client_name" with ParamValues: 0='LOGIN', 1='2023-01-26 23:59:59', 2='2022-12-26 00:00:00', 3=''] at /home/libki/libki-server/lib/Libki/Controller/Administration/History.pm line 107
EDIT Resolved after I modified “/etc/mysql/mysql.conf.d/mysqld.cnf" Added last line: sql_mode = "" /EDIT
Describe the bug I installed Libki via "wget -O- install.libki.org | bash" on a fresh Ubuntu 20.04 server. Upon accessing the web interface, the Statistics tab results in the "(en) Please come back later" screen.
Expected behavior Expected to view statistics.
Deployment architecture:
Desktop (please complete the following information):
Libki log file: [2023/01/26 15:48:01] [libki] [ERROR] DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'libki.me.client_location' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [for Statement "SELECT
me
.client_name
, COUNT( * ),me
.client_location
FROMstatistics
me
WHERE ( (action
= ? AND (created_on
<= ? ANDcreated_on
>= ? ) ANDinstance
= ? ) ) GROUP BYclient_name
" with ParamValues: 0='LOGIN', 1='2023-01-26 23:59:59', 2='2022-12-26 00:00:00', 3=''] at /home/libki/libki-server/lib/Libki/Controller/Administration/History.pm line 107