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

Listing of entries with a specific tag failes with MySQL 5.7 (in my configuration?) #326

Closed
auge8472 opened this Issue Jan 5, 2018 · 1 comment

Comments

Projects
None yet
2 participants
@auge8472
Copy link
Collaborator

auge8472 commented Jan 5, 2018

The MySQL installation of my webhosting service seems to be very strict. If I klick on a tagin the tag cloud to list all entries with this tag, the database query fails with the followin error message.

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

The name ftis the alias of mlf2_forum_table. The named field ft.time itself is really in the SELECT list, but has the alias time (without the leading table alias). In the ORDER clause it is named ft.time. Will test it with changed names.

@auge8472 auge8472 added the bug label Jan 5, 2018

@auge8472 auge8472 added this to the 2.4.8 milestone Jan 5, 2018

@auge8472 auge8472 self-assigned this Jan 5, 2018

@loesler

This comment has been minimized.

Copy link
Collaborator

loesler commented Jan 8, 2018

in my configuration?

Unfortunately, no

@auge8472 auge8472 closed this in 27cda18 Jan 9, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.