What version of phpBB are you using? phpBB 3.1.6 and 3.2.0-dev.
What is your board's URL? http://demo.at.home
Who do you host your board with? me
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What styles do you currently have installed? prosilver
What language(s) is your board currently using? english
Which database type/version are you using? MySQL 5.7.9
What is your level of experience? Experienced with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Fresh install.
Please describe your problem.
When the post number is pressed.
This error is shown.
Code: Select all
General Error SQL ERROR [ mysqli ] Expression #1 of ORDER BY clause is not in SELECT list, references column 'psy.p.post_time' which is not in SELECT list; this is incompatible with DISTINCT  SQL SELECT DISTINCT SQL_CALC_FOUND_ROWS p.post_id FROM phpbb_posts p WHERE p.poster_id = 2 AND (p.post_visibility = 1 OR p.forum_id IN (1, 2)) ORDER BY p.post_time DESC BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FILE: [ROOT]/phpbb/db/driver/driver.php LINE: 855 CALL: trigger_error() FILE: [ROOT]/phpbb/db/driver/mysqli.php LINE: 193 CALL: phpbb\db\driver\driver->sql_error() FILE: [ROOT]/phpbb/db/driver/factory.php LINE: 329 CALL: phpbb\db\driver\mysqli->sql_query() FILE: [ROOT]/phpbb/search/fulltext_native.php LINE: 1197 CALL: phpbb\db\driver\factory->sql_query() FILE: [ROOT]/search.php LINE: 550 CALL: phpbb\search\fulltext_native->author_search()
Im hoping this will be fixed in the next release of 3.1.x and fixed before 3.2.x is released. Any code fix before then would be greatly appriciated.