Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PHP Fatal Error for Organizations on MySQL 5.7 #235

Closed
t4k opened this issue Jun 13, 2017 · 1 comment
Closed

PHP Fatal Error for Organizations on MySQL 5.7 #235

t4k opened this issue Jun 13, 2017 · 1 comment
Labels
bug This is a bug (not an enhancement)

Comments

@t4k
Copy link
Contributor

t4k commented Jun 13, 2017

PHP message: PHP Fatal error: Uncaught Exception: There was a problem with the database: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'coral_organizations.OHP.parentOrganizationID’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/coral/organizations/admin/classes/common/DBService.php:39
Stack trace:
#0 /var/www/coral/organizations/admin/classes/common/DBService.php(71): DBService->checkForError()
#1 /var/www/coral/organizations/admin/classes/domain/Organization.php(550): DBService->processQuery('SELECT O.organi…', 'assoc’)
#2 /var/www/coral/organizations/ajax_htmldata.php(895): Organization->search(Array, ‘TRIM(LEADING ‘T…’, ‘’)
#3 {main}
thrown in /var/www/coral/organizations/admin/classes/common/DBService.php on line 39

Diagnosed the problem and have an idea for a solution from: https://stackoverflow.com/a/34115425

Pull request coming shortly.

@t4k
Copy link
Contributor Author

t4k commented Feb 12, 2019

This issue is actually resolved.

@t4k t4k closed this as completed Feb 12, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug This is a bug (not an enhancement)
Projects
None yet
Development

No branches or pull requests

1 participant