sql error when searching for members posts

[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]"

[radios]

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

[watcher_of_the_skies]

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

[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.

[radios]

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]

possible fix for sql error. https://stackoverflow.com/questions/368 ... 7-with-sel

[salsaSkaarj]

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