Error on login

[jaapjolman]

Dear TCADMIN,

 

we got this error today when we logged in

 

Expression #2 of ORDER BY clause is not in SELECT list, references column 'tcadmin.tc_panelbar_categories.view_order' which is not in SELECT list; this is incompatible with DISTINCT

 

we run tcadmin on a linux box and we run mysql 5.7

[Raizio]

Hey Jaap,

 

This definitely seems more like a direct support question.

Did a backup work?

[jaapjolman]

it happend after upgrading to mysql 5.7 which is not reversable, the error is happening because of an incorrect query statement, so where can i edit the queries to make this work again

[ECF]

Contact support with your issue.

[Dennis]

Once you get an answer from support, it wouldn't be a bad idea posting the solution here in case someone else runs into the same problem