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.