Player error

[ismellike]

This error stops all chat and creates some errors with commands.

Here is what I get when I join the server.

Code: Select all

Type: SQLiteException
Source: System.Data.SQLite
Message: SQLite error
no such table: PlayerAppearance
Target: Prepare
Trace:    at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at MCDzienny.SQLite.fillData(String queryString, Dictionary`2 parameters, Boolean skipError)
   at MCDzienny.DBInterface.fillData(String queryString, Boolean skipError)
   at MCDzienny.Player.LoadPlayerAppearance()
   at MCDzienny.Player.HandleLogin(Byte[] message)
   at MCDzienny.Player.HandleMessage(Byte[] buffer)

I can still use commands, but when I do /players, it says 0 players online.

[_Retaliate_]

So, something is wrong with your sql database.
because apparently in your database there isn't a "PlayerAppearance" table.
Idk how to fix it, not good with sql.

[dzienny]

Thank you for the report. There was an error in the MySQL query syntax. It's fixed it the version 10.8.2.