phpBB forum errors (UTF-8 chars & "Show your posts")

phpBB forum errors (UTF-8 chars & "Show your posts")

Postby kolAflash » 06 Jan 2023, 13:49

If I post a UTF-8 emoticon like the sun I get a SQL error.
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
kolAflash
 
Posts: 5
Joined: 05 Jan 2023, 21:26

Re: phpBB forum errors (UTF-8 chars & "Show your posts")

Postby kolAflash » 06 Jan 2023, 13:51

P.S.
Probably related to the "Show your posts" issue: https://forum.freegamedev.net/viewtopic ... 28#p109728
kolAflash
 
Posts: 5
Joined: 05 Jan 2023, 21:26

Who is online

Users browsing this forum: No registered users and 1 guest

cron