Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column
#enter the command below
find / -name my.cnf
#your should find something like
#/etc/mysql/my.cnf
#edit the file
sudo nano /etc/mysql/my.cnf
#add the 2 lines of command below and save
[mysqld]
sql_mode = ""
#restart mysql
systemctl restart myqsl