Gallery Links
Users Online
· Guests Online: 12

· Members Online: 0

· Total Members: 4,774
· Newest Member: rite
Forum Threads
Theme Switcher
Switch to:
Last Seen Users
· Nosferatumyia02:25:42
· Eugen03:19:12
· sbushes03:33:40
· weia03:38:44
· Gman03:45:50
· Michael Kracht04:06:11
· runetk04:21:08
· evdb05:12:47
· bernard1205:35:52
· Carnifex05:53:43
Latest Photo Additions
View Thread
Who is here? 1 guest(s)
 Print Thread
Seach error
Axel D
#1 Print Post
Posted on 25-04-2020 18:17
User Avatar

Member

Location: France
Posts: 153
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. Smile
 
Ben Hamers
#2 Print Post
Posted on 25-04-2020 19:12
Member

Location: Heerlen ( Holland )
Posts: 701
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
 
www.tephritidae.net
Axel D
#3 Print Post
Posted on 25-04-2020 19:43
User Avatar

Member

Location: France
Posts: 153
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
#4 Print Post
Posted on 26-04-2020 12:36
User Avatar

Super Administrator

Location: Netherlands
Posts: 19012
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
 
diptera.info
Paul Beuk
#5 Print Post
Posted on 28-04-2020 10:52
User Avatar

Super Administrator

Location: Netherlands
Posts: 19012
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
 
diptera.info
Axel D
#6 Print Post
Posted on 29-04-2020 12:08
User Avatar

Member

Location: France
Posts: 153
Joined: 16.10.15

Thank you Paul. It works now on my computer. Smile
 
Jump to Forum:
Similar Threads
Thread Forum Replies Last Post
Serious error in Catalogue Palaearct. Diptera (2) What should I use? 4 19-10-2011 19:46
Error report About the Website (requests, discussion, errors, etc.) 2 22-09-2008 21:40
Date and time
02 July 2022 03:36
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Temporary email?
Due to fact this site has functionality making use of your email address, any registration using a temporary email address will be rejected.

Paul
Donate
Please, help to make
Diptera.info
possible and enable
further improvements!
Latest Articles
Syrph the Net
Those who want to have access to the Syrph the Net database need to sign the
License Agreement -
Click to Download


Public files of Syrph the Net can be downloaded HERE

Last updated: 25.08.2011
Shoutbox
You must login to post a message.

19.06.22 07:42
I can not post an image - I do all right - dont know what to do! Gunther

24.05.22 11:28
Hi! would anyone be able to send on a scan of Delia sanctijacobi redescription from: GRIFFITHS, G.C.D. 1993. Anthomyiidae [part]. In: Flies of the Nearctic Region, 8(2), 10. Thank you!

18.05.22 16:26
Delay, alas, due to Covid related issues. But it will be published !!

18.05.22 16:26
Publication of the English translation of the Fieldguide to Homeodactyla of northwest Europe is due September

14.05.22 07:24
Hi, 3 threads in Eggs, etc should be in adults - possible to change please?

13.04.22 07:52

12.04.22 07:41
cant attach picture to post in forum, what do I do wrong? Sorry Novice question ...

09.01.22 16:56
Hello, I'm looking for literature on chironomid larvae that are able to survive after being entrapped in ice for at least several days . So far I've only found literature on Eretmoptera murphy

11.12.21 16:10
Dematoneura in the gallery should be DeSmatoneura

23.09.21 14:29
All sorted.

Render time: 1.97 seconds | 166,213,691 unique visits