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

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

Postby melvinar » 31 Mar 2023, 21:41

kolAflash {l Wrote}:If I post a UTF-8 emoticon like the sun I get a SQL error youtube apk
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

the issue is still there
Last edited by melvinar on 03 Apr 2023, 05:32, edited 1 time in total.
melvinar
 
Posts: 2
Joined: 29 Mar 2023, 14:33

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

Postby Julius » 01 Apr 2023, 01:20

This forum is half-broken and depreciated. Don't expect any fixes.
User avatar
Julius
Community Moderator
 
Posts: 3297
Joined: 06 Dec 2009, 14:02

Who is online

Users browsing this forum: No registered users and 1 guest