[PHPBB3-14782] Quick Links > Your Posts gives mysql error

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 3.1.9, 3.2.0-RC1
Fix Version/s: 3.1.10-RC1, 4.0.0-a1, 3.2.0-RC2
Component/s: Search
Labels:
None
Environment:

Hide
php -v
PHP 7.0.8-0ubuntu0.16.04.2 (cli) ( NTS )
Copyright (c) 1997-2016 The PHP Group
Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.8-0ubuntu0.16.04.2, Copyright (c) 1999-2016, by Zend Technologies

mysql Ver 14.14 Distrib 5.7.13, for Linux (i686) using EditLine wrapper
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Show
php -v PHP 7.0.8-0ubuntu0.16.04.2 (cli) ( NTS ) Copyright (c) 1997-2016 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies with Zend OPcache v7.0.8-0ubuntu0.16.04.2, Copyright (c) 1999-2016, by Zend Technologies mysql Ver 14.14 Distrib 5.7.13, for Linux (i686) using EditLine wrapper Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

When trying to select Your Posts from the drop down Quick Links there is a mysql error

is duplicated by

PHPBB3-14300 Mysql 5.7.X support

PHPBB3-14637 MySQL 5.7.* compatibility

obsoletes

PHPBB3-11126 DB error while running mysql database in strict sql mode