Gallery Links
Users Online
· Guests Online: 25

· Members Online: 0

· Total Members: 4,960
· Newest Member: Urs-Peter
Forum Threads
Theme Switcher
Switch to:
Last Seen Users
· ukursawe00:45:55
· serenense700:56:06
· weia00:57:24
· daveb2101:33:54
· ESant02:16:51
· John Schneider02:17:22
· Tetrao02:35:50
· blaauw702:38:41
· libor03:07:52
· Nosferatumyia03:35:23
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: 204
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: 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
 
www.tephritidae.net
Axel D
#3 Print Post
Posted on 25-04-2020 19:43
User Avatar

Member

Location: France
Posts: 204
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: 19254
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: 19254
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: 204
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 May 2024 10:39
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.

07.03.24 00:01
Some flies preserved in ethanol and then pinned often get the eyes sunken, how can this be avoided? Best answer: I usually keep alcohol-collected material in alcohol

17.08.23 15:23
Aneomochtherus

17.08.23 13:54
Tony, I HAD a blank in the file name. Sorry!

17.08.23 13:44
Tony, thanks! I tried it (see "Cylindromyia" Wink but don't see the image in the post.

17.08.23 11:37
pjt - just send the post and attached image. Do not preview thread, as this will lose the link to the image,

16.08.23 08:37
Tried to attach an image to a forum post. jpg, 32kB, 72dpi, no blanks, ... File name is correctly displayed, but when I click "Preview Thread" it just vanishes. Help!

23.02.23 21:29
Has anyone used the Leica DM500, any comments.

27.12.22 21:10
Thanks, Jan Willem! Much appreciated. Grin

19.12.22 11:33
Thanks Paul for your work on keeping this forum available! Just made a donation via PayPal.

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

Render time: 0.98 seconds | 193,619,926 unique visits