Who is here? 1 guest(s)
 Seach error
|
|
| Axel D |
Posted on 25-04-2020 18:17
|
 Member Location: Posts: 201 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 19:12
|
|
Member Location: 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 19:43
|
|
Member Location: Posts: 201 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 12:36
|
 Super Administrator Location: Posts: 19208 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 10:52
|
|
Super Administrator Location: Posts: 19208 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 12:08
|
|
Member Location: Posts: 201 Joined: 16.10.15 |
Thank you Paul. It works now on my computer. |
|
|
|
| Jump to Forum: |
but don't see the image in the post.