Server can't update 'characters' - SQL syntax error

[PhatChilla]

Edit: I set the server up using Bullsito's set up guide

Whenever I log into the character, the server tries to update character data and then this happens:

ACTIVE QUERY Thread 12: UPDATE `characters` SET `x`=1143,1831, `y`=-640,93115, `z`=56,753082, `rz`=-136,22603, `health`=100, `armor`=0, `last_seen`=CURRENT_TIMESTAMP, `dimension`=0 WHERE id=2556;
ACTIVE QUERY Thread 11: UPDATE `characters` SET `impairment`=0, `drug_fx1`=False, `drug_fx2`=False, `drug_fx3`=False, `drug_fx4`=False, `drug_fx5`=False, `drug_fx1_duration`=0, `drug_fx2_duration`=0, `drug_fx3_duration`=0, `drug_fx4_duration`=0, `drug_fx5_duration`=0 WHERE id=2556;
ERROR IS WITH THE FOLLOWING QUERY: UPDATE `characters` SET `x`=1143,1831, `y`=-640,93115, `z`=56,753082, `rz`=-136,22603, `health`=100, `armor`=0, `last_seen`=CURRENT_TIMESTAMP, `dimension`=0 WHERE id=2556;
INNEREXCEPTION: None
MESSAGE: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1831, `y`=-640,93115, `z`=56,753082, `rz`=-136,22603, `health`=100, `armor`=0...' at line 1
SOURCE: MySql.Data
EXSTACK:    at MySqlPacket MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at int MySql.Data.MySqlClient.NativeDriver.GetResult(ref int affectedRow, ref long insertedId)
   at int MySql.Data.MySqlClient.Driver.GetResult(int statementId, ref int affectedRows, ref long insertedId)
   at ResultSet MySql.Data.MySqlClient.Driver.NextResult(int statementId, bool force)
   at bool MySql.Data.MySqlClient.MySqlDataReader.NextResult()
ENVSTACK:    at System.Environment.get_StackTrace()
   at Core.HandleServerException(Exception ex)
   at System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TStateMachine](TStateMachine& stateMachine)
   at Core.HandleServerException(Exception ex)
   at Core.<.ctor>b__52_1(Object sender, FirstChanceExceptionEventArgs eventArgs)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
   at System.Data.Common.DbCommand.ExecuteNonQueryAsync()
   at Database.ThreadedMySQLConnectionPool.ThreadedMySQLConnection.ProcessCurrentQuery()
   at System.Runtime.CompilerServices.AsyncMethodBuilderCore.Start[TStateMachine](TStateMachine& stateMachine)
   at Database.ThreadedMySQLConnectionPool.ThreadedMySQLConnection.ProcessCurrentQuery()
   at Database.ThreadedMySQLConnectionPool.ThreadedMySQLConnection.ThreadedTick()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

I can keep playing after this error but no one else can join and when I try to reconnect or change character I can't log back in as well. Any ideas?

[Bullsito]

x=1143,1831, y=-640,93115, z=56,753082, rz=-136,22603

I had this error, its about the coords, you have to set in your server/computer/wherever_you_host_the_database, the decimal separator as point instead of comma, that error is caused because the MySql query that is trying to make failed and therefore, the whole database.

Right now, for the 'x' valor, it is trying to insert 1143 AND 1831, not 1143.183100000 (I put some zeros to not be mistaken with thousands).

In Windows it was something at the Language settings, I don't remember right now (I recomend you to search at google how to change the decimal separator at your computer).

If its Linux, no clue, I guess there is something similar at settings.

I hope this helps you.

[PhatChilla]

Hahaha how did I not notice they were commas instead of points... Yeah changing the decimal pointer fixed it, for anyone else having the same issue you can change it from Control Panel > Region > Additional Settings in Formats tab > Decimal Symbol, change it to a .

[Bullsito]

It took me a while figuring out what could be haha, good luck with the gamemode, Im trying to fix the rest of known issues, if you could fix the custom maps/interiors, don't hesitate on sharing the answer.