jaapjolman Posted January 27, 2016 Share Posted January 27, 2016 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 Link to comment Share on other sites More sharing options...
Raizio Posted January 27, 2016 Share Posted January 27, 2016 Hey Jaap, This definitely seems more like a direct support question. Did a backup work? Link to comment Share on other sites More sharing options...
jaapjolman Posted January 27, 2016 Author Share Posted January 27, 2016 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 Link to comment Share on other sites More sharing options...
ECF Posted January 27, 2016 Share Posted January 27, 2016 Contact support with your issue. Link to comment Share on other sites More sharing options...
Dennis Posted January 28, 2016 Share Posted January 28, 2016 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now