OpenCATS 0.9.4-3

Free, Open-Source Applicant Tracking System including job-board. Entirely customisable!

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

I've written a custom PHP code which is actually a[…]

It would be nice for CATSone to also allow the aut[…]

Hi there! I would like to implement a search box […]

OpenCATS restore

Yes I think so. I assume you made a backup of al y[…]

Is this a fresh install of 0.9.4-3 and you importe[…]

How to enable and use ACL

I started to enable the ACL about 2 years ago (May[…]

If you use centos 7,everything should be the same.[…]

I have a feeling that MAMP is including php7. P[…]

I have it running on Ubuntu on GCP Email me if yo[…]