Thread subject: Diptera.info :: Seach error

Posted by Axel D on 25-04-2020 18:17
#1

Hello

Today, maybe because of the recent update, I realized that the "Forum Search" function is currently broken. I get SQL errors when I try to use it :

Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'diptera_diptera.f.forum_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byExpression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'diptera_diptera.f.forum_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'diptera_diptera.f.forum_name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by


Hope this will be repaired soon. :)

Posted by Ben Hamers on 25-04-2020 19:12
#2

When I search with only a keyword, it doesn't work.
But when I select a forum in addition it works.

Ben

Posted by Axel D on 25-04-2020 19:43
#3

You're right, it's only the "---Everywhere---" option with the "Body"/"Both, subject and body" option that doesn't work.

Posted by Paul Beuk on 26-04-2020 12:36
#4

I will check it out in the next few days. Cheers for letting me know.

Posted by Paul Beuk on 28-04-2020 10:52
#5

It should be okay now. The error was a result of the higher PHP version being less forgiving of some discrepancies in the database. The previous version recognised a sorting order of forums stated as 1 - 2 - 5 and yielded it 1 - 2 - 3. Earlier versions of the system may have incorrectly updated such numbers after a forum was moved or deleted, leaving gaps. The new version is less forgiving and just stops and coughs up the error when a gap is encountered. I found this out when trying to correct the same error on the profile update page.

If there are any other instances of what is apparently the same error, please, report them here and I will hack the database to sort it out.

Posted by Axel D on 29-04-2020 12:08
#6

Thank you Paul. It works now on my computer. :)