-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
3.1.6, 3.2.0-dev
-
None
-
PHP 5.6.15, MYSQL 5.7.9, Firefox 42
When the post number is pressed in viewtopic.
Example.
http://domain.com/forum/search.php?author_id=2&sr=posts
This error is shown.
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 [3065] |
|
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()
|
- duplicates
-
PHPBB-14782 Quick Links > Your Posts gives mysql error
- Closed