Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
#4725
Installed 16.04 Ubuntu LTS LAMP 5.6 PHP everything went great and most everything seems to work. However Im getting the following error if I go to Administration> User management

MySQL Query Failed: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'opencats.user.access_level' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT
COUNT(user.site_id) AS totalUsers,
user.access_level,
site.user_licenses AS userLicenses
FROM
user
LEFT JOIN site
ON user.site_id = site.site_id
WHERE
user.site_id = 1
AND
user.access_level > 100
GROUP BY
user.site_id
#4726
Actually I fixed it myself.

Here is the solution I used

sudo nano /etc/mysql/my.cnf

go to bottem of file and add the following

[mysqld]
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Restart MYSQL
sudo service mysql restart

Fixes this issue
here is some additional info
https://stackoverflow.com/questions/341 ... y-in-mysql

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me