I've just upgraded to Ubuntu 16.04 with MySQL 5.7 and I'm running into this error: ORDER BY clause is not in SELECT list

Does anybody know how this could be fixed? I have already tried to downgrade to MySQL 5.6 but Ubuntu 16.04 doesn't have installation packages for it. The only way to do it would be to build it from source but so far I haven't been successful. The documentation is sparse.

I would rather keep MySQL 5.7 installed if there was a workaround.

This might be related to this commit which is part of the Symphony 2.7 development. If you know Git, you might try and cherry-pick this and the second, related commit (which is mentioned in the discussion of the first commit). If you do so, please report if it fixed the issue for you!

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details