Although the preview works.
- {l Code}: {l Select All Code}
SQL ERROR [ mysqli ]
Incorrect string value: '\xF0\x9F\x8C\x9E I...' for column 'post_text' at row 1 [1366]
This might be helpful:
https://www.phpbb.com/community/viewtopic.php?t=2083565
https://www.phpbb.com/community/viewtopic.php?t=2179126
https://www.phpbb.com/community/viewtopic.php?t=2160948
says: "To fix the error, set the column to UTF8 or UTF8-BIN . This should fix the error."
Clicking the "Show your posts" link in Settings also triggers an error.
- {l Code}: {l Select All Code}
SQL ERROR [ mysqli ]
Expression #1 of ORDER BY clause is not in SELECT list, references column 'fgd_phpbb.p.post_time' which is not in SELECT list; this is incompatible with DISTINCT [3065]
This might be helpful:
https://tracker.phpbb.com/browse/PHPBB3-14637
https://www.phpbb.com/community/viewtopic.php?t=2345496
https://tracker.phpbb.com/browse/PHPBB3-14300
There's a source patch for the file includes/search/fulltext_native.php