Console errors after RUST update

05/02 21:46:20 | MySql handle raised an exception (MySqlException: Incorrect string value: '\xF0\x9F\x8C\x9F' for column `of_xstatistics`.`StoredDataT_pve`.`UserName` at row 1)
at MySqlConnector.Core.ServerSession.ReceiveReplyAsync (MySqlConnector.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x0011b] in <dbba0abc564f4cbc913b724e430f6d9b>:0
at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync (MySqlConnector.Protocol.Serialization.IOBehavior ioBeha

Do you have players with non-standard characters in their nicknames or emojis?

Yes I have, and their nicknames are not being stripped by the plugin

@MonsterIs there any way to strip player names from characters that prevent DB write? Can this be embedded in one of the releases so that I don't need to GPT-shitcode this?

This was fixed by adjusting default UserName column type in MySQL.
You can fix it for the plugin by adjusting

ALTER TABLE StoredDataT_pve

MODIFY UserName VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

I suppose you can fix this in your code by forcing "UserName" column charset to utf8 when table is initially created by the plugin. line 867.

_mySql.ExecuteNonQuery(Sql.Builder.Append($"CREATE TABLE IF NOT EXISTS {config.DB.TableName2} (userID BIGINT(17) PRIMARY KEY, ActStats BOOLEAN, PlayTimeAll INT(10), KillAll INT(10), DeathAll INT(10), FirstCon INT(10), LastCon INT(10), UserName VARCHAR(64), ActTOPChat BOOLEAN);"), _mySqlConnection);

Changed Status from Pending to Closed

Changed Fixed In to Next Version