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]"
sql error when searching for members posts
7 posts •
Page 1 of 1
- radios
- 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
- radios
- 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
- 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.
Would be nice if we could use the search option as intended.
- ividyon
- 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.
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
- 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
thanks for the reply, I'm sure there's someone somewhere that has figured this out before..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.
- radios
- 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
possible fix for sql error. https://stackoverflow.com/questions/368 ... 7-with-sel
- salsaSkaarj
- 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
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
7 posts •
Page 1 of 1
Who is online
Users browsing this forum: No registered users and 25 guests