Scout-kun is a lie... right?

sql error when searching for members posts

For discussion about UnrealSP.org itself.

Moderators: zYnthetic, ividyon, Semfry

radios
Skaarj Lord Skaarj Lord
Posts: 160
Joined: 25 May 2008, 18:58
Location: Long Island

Subject: sql error when searching for members posts

Post Posted: 27 Feb 2019, 20:12

I get "SQL ERROR [ mysql4 ]

Expression #1 of ORDER BY clause is not in SELECT list, references column 'usp_legacy_forum.p.post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065]" :(

radios
Skaarj Lord Skaarj Lord
Posts: 160
Joined: 25 May 2008, 18:58
Location: Long Island

Subject: Re: sql error when searching for members posts

Post Posted: Yesterday, 21:58

posts here go unreplied?. I was trying to be helpful pointing out a bug..

User avatar watcher_of_the_skies
Skaarj Lord Skaarj Lord
Posts: 174
Joined: 17 Aug 2015, 10:27

Subject: Re: sql error when searching for members posts

Post Posted: Today, 08:55

I'm getting the same error. :\
Would be nice if we could use the search option as intended.

User avatar ividyon
Administrator Administrator
Posts: 2294
Joined: 12 Nov 2007, 14:43
Location: Germany
Contact:

Subject: Re: sql error when searching for members posts

Post Posted: Today, 13:08

Hi,

sorry for the lack of response! This has to do with the MySQL version on the new host being newer than this old version of phpBB can work with. Solutions are being looked at.
UnrealSP.org webmaster & administrator


Who is online

Users browsing this forum: No registered users and 2 guests