Tag bug (Technical Issues)

by Bogey, Monday, January 08, 2018, 17:26 311 days ago 697 views

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

Is that a bug in the new version?

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

  • locked
Avatar

Tag bug

by Micha ⌂, Bad Vilbel, Monday, January 08, 2018, 17:46 311 days ago @ Bogey 650 views

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

--
derletztekick.com - OpenSource Least-Squares Adjustment Software for Geodetic Sciences

  • locked
Avatar

Tag bug

by Auge @, Monday, January 08, 2018, 18:48 311 days ago @ Bogey 625 views

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

  • locked
Avatar

Tag bug

by Auge @, Monday, January 08, 2018, 19:03 311 days ago @ Bogey 614 views

Tags:

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 until tomorrow in the repository.

Tschö, Auge

  • locked
RSS Feed of thread