Diptera.info :: Website issues :: About the Website (requests, discussion, errors, etc.)
Who is here? 1 guest(s)
Seach error
|
|
Axel D |
Posted on 25-04-2020 19:17
|
Member Location: France Posts: 209 Joined: 16.10.15 |
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. ![]() |
|
|
Ben Hamers |
Posted on 25-04-2020 20:12
|
Member Location: Heerlen ( Holland ) Posts: 735 Joined: 16.12.04 |
When I search with only a keyword, it doesn't work. But when I select a forum in addition it works. Ben |
Axel D |
Posted on 25-04-2020 20:43
|
Member Location: France Posts: 209 Joined: 16.10.15 |
You're right, it's only the "---Everywhere---" option with the "Body"/"Both, subject and body" option that doesn't work. |
|
|
Paul Beuk |
Posted on 26-04-2020 13:36
|
![]() Super Administrator Location: Netherlands Posts: 19303 Joined: 11.05.04 |
I will check it out in the next few days. Cheers for letting me know.
Paul - - - - Paul Beuk on https://diptera.info |
Paul Beuk |
Posted on 28-04-2020 11:52
|
![]() Super Administrator Location: Netherlands Posts: 19303 Joined: 11.05.04 |
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. Paul - - - - Paul Beuk on https://diptera.info |
Axel D |
Posted on 29-04-2020 13:08
|
Member Location: France Posts: 209 Joined: 16.10.15 |
Thank you Paul. It works now on my computer. ![]() |
|
Jump to Forum: |