Gallery Links
Users Online
· Guests Online: 16

· Members Online: 0

· Total Members: 4,803
· Newest Member: Mikael S
Forum Threads
Theme Switcher
Switch to:
Last Seen Users
· Tony Irwin00:21:58
· RamiP00:32:12
· GAREL Jean-M...00:32:28
· Pat0200:40:48
· rafael_carbo...00:43:55
· Bert Oving00:54:41
· evdb01:14:41
· Nikita Vikhrev01:17:09
· libor01:21:40
· Zeegers01:25:28
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: 173
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: 717
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: 173
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: 19059
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: 19059
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: 173
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
26 November 2022 10:40
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.

09.10.22 17:07
Yes, dipterologists from far abroad, please buy your copy at veldshop. Stamps will be expensive, but he, the book is unreasonably cheap Smile

07.10.22 11:55
Can any1 help out with a pdf copy of 1941 Hammer. Vidensk. Meddel. Dansk Naturhist. Foren. 105; thank you

05.10.22 19:59
Found! https://www.veldsh
op.nl

05.10.22 19:53
@zeegers, your book seems difficult to get from Spain, is there another way?

08.09.22 09:29
Ladies and gentlemen https://jeugdbonds
uitgeverij.nl/prod
uct/families-of-fl
ies-with-three-pul
villi/

26.08.22 15:06
Lis - This is vol.11 (eleven) and is 346 pages. Sorry, don't have a copy.

15.08.22 14:22
Hello, can any1 help out with a copy of Catalogue of Palaearctic Diptera II: Scathophagidae-Hyp
odennatidae? or at least how many pages it is? thx

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 !!

Render time: 2.42 seconds | 172,205,661 unique visits