UnrealSP.org, now with 100% more Web 2.0!

sql error when searching for members posts

For discussion about UnrealSP.org itself.

Moderators: Semfry, ividyon

radios
Skaarj Lord Skaarj Lord
Posts: 186
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: 186
Joined: 25 May 2008, 18:58
Location: Long Island

Subject: Re: sql error when searching for members posts

Post Posted: 23 Mar 2019, 21:58

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

watcher_of_the_skies
Skaarj Lord Skaarj Lord
Posts: 224
Joined: 17 Aug 2015, 10:27

Subject: Re: sql error when searching for members posts

Post Posted: 24 Mar 2019, 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: 2354
Joined: 12 Nov 2007, 14:43
Location: Germany
Contact:

Subject: Re: sql error when searching for members posts

Post Posted: 24 Mar 2019, 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

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

Subject: Re: sql error when searching for members posts

Post Posted: 25 Mar 2019, 21:45

ividyon wrote: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.
thanks for the reply, I'm sure there's someone somewhere that has figured this out before..

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

Subject: Re: sql error when searching for members posts

Post Posted: 21 Jul 2019, 15:31


User avatar salsaSkaarj
Gilded Claw Gilded Claw
Posts: 1862
Joined: 21 Apr 2009, 21:54
Location: on the prowl

Subject: Re: sql error when searching for members posts

Post Posted: 27 Jul 2019, 16:58

Not sure which version of phpBB unrealsp is on (still3.1?) but phpBB 3.2.x works with MySQL 5.6 and 5.7 (even 8 with a couple of tweaks).
The mysql4 part is surprising though. Any reason why mysqli is not being used (host restrictions?)

edited: I wrote MySQL 5.8 instead of 8


Who is online

Users browsing this forum: No registered users and 30 guests

Copyright © 2001-2024 UnrealSP.org

Powered by phpBB® Forum Software © phpBB Limited