Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
3.1.9
-
None
-
None
-
PHP 5.6.
MySQL 5.7.
Apache 2.2.11.
Safari/Chrome last versions.
Description
It appears as after a migration of my MySQL server from 5.2 to 5.7 the phpBB 3.1.9 isn't fully compatible with the new MySQL version.
Each time I try to search users posts (the link under avatar) or my own posts (egosearch in the nabber) I got the following error.
AFTER CLICKING "EGOSEARCH" IN NAVBAR
General Error
|
SQL ERROR [ mysqli ]
|
|
|
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.p.post_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055] |
AFTER CLICKING POSTS LINK NUMBER UNDER AVATAR
General Error
|
SQL ERROR [ mysqli ]
|
|
|
Expression #1 of ORDER BY clause is not in SELECT list, references column 'mydb.p.post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065] |
Attachments
Issue Links
- duplicates
-
-
- Closed
-