MLF-AddOns project forum

Hi,

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

Is that a bug in the new version?

Its not a feature and we have a ticket on github. Maybe, you can fix it as Auge has suggested: In search.inc.php line 209 and 220, there are the following statements:

ORDER BY tid DESC, ft.time ASC

can you modify these lines to:

ORDER BY tid DESC, time ASC

(just remove the alias-name ft)

Good to see this forum by the way. What happened with mylittleforum.net?

I'm sorry, we don't know. We are still waiting for feedback from Alex.

/Micha

Hello

On this forum, when I click one of the tags this message appears:

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

As Micha pointed out are we aware of the issue.

Is that a bug in the new version?

No, it isn't a bug in the new version. It's a bug that is present since longer time. The bug pops up with a special MySQL configuration. Maybe it is a not so special configuration in newest MySQL versions because my webspace is driven by MySQL 5.7 (the most up-to-date free MySQL version).

I'm working on tests to solve the issue first here and subsequent in the repo.

Tschö, Auge

On this forum, when I click one of the tags this message appears:

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 issue is solved for this installation. The fix will appear in the repository until tomorrow.

Tschö, Auge