Edge on Ubuntu 18.04: UserManagement: Manage Projects: ORDER BY clause is not in SELECT list

[gmoore777]

On Ubuntu 18.04, Edge 2018-10-30:

After logging into Edge's UserManagement and clicking either "All Projects" or "Manage Products", which are these URLs

http://<IP Address>/userManagement/userProjects.jsp

http://<IP Address>/userManagement/adminProjects.jsp

I get on the web page, this error:

Fatal Exception: Expression #1 of ORDER BY clause is not in SELECT list, references column 'userManagement.p.updated'

which is not in SELECT list; this is incompatible with DISTINCT

(I cannot find this particular SQL in any of the Edge installation files. Is it in the userManagementWS.war file?)

[Lo, Chien-Chi]

Hi,

 

For MySQL 5.7 (Ubuntu 18.04), please append following content to /etc/mysql/my.cnf

[mysqld]

show_compatibility_56 = on

sql-mode=""

 

Thanks,

Chienchi

--
You received this message because you are subscribed to the Google Groups "edge-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to edge-users+...@googlegroups.com.
To post to this group, send email to edge-...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/edge-users/5e2f7550-9ab4-43ef-9905-232aa6920363%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Greenleaf]

Chienchi

Thank you, that solved the problem.

Guy

Note to self:

I actually added those 2 lines, under the [mysqld] section of the file:

 /etc/mysql/mysql.conf.d/mysqld.cnf

the file /etc/mysql/my.cnf links back to /etc/mysql/mysql.cnf

lrwxrwxrwx 1 root root 24 Oct  8 22:52 /etc/mysql/my.cnf -> /etc/alternatives/my.cnf

lrwxrwxrwx 1 root root 20 Oct  8 22:55 /etc/alternatives/my.cnf -> /etc/mysql/mysql.cnf

Then restarted mysql via:

sudo service mysql restart