Page 1 of 1

sql error when searching for members posts

Posted: 27 Feb 2019, 20:12
by radios
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]" :(

Re: sql error when searching for members posts

Posted: 23 Mar 2019, 21:58
by radios
posts here go unreplied?. I was trying to be helpful pointing out a bug..

Re: sql error when searching for members posts

Posted: 24 Mar 2019, 08:55
by watcher_of_the_skies
I'm getting the same error. :\
Would be nice if we could use the search option as intended.

Re: sql error when searching for members posts

Posted: 24 Mar 2019, 13:08
by ividyon
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.

Re: sql error when searching for members posts

Posted: 25 Mar 2019, 21:45
by radios
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..

Re: sql error when searching for members posts

Posted: 21 Jul 2019, 15:31
by radios