Page 1 of 1

Problems with my server

PostPosted: 03 May 2014, 10:34
by Elisa202
Hello, i am hosting [KCraft] Lava Survival and something has gone insanely wrong. Everyone's title has been removed, color names, welcome and farwell messages, all their experience and money. You could set a new title but when logging in again it will be gone. So anything you do will be lost. Please help me?

-------------------------
----30-4-2014 0:05:53 ----
Type: SQLiteException
Source: System.Data.SQLite
Message: SQLite error
near " ": syntax error
Target: Prepare
Trace: bij System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
bij System.Data.SQLite.SQLiteCommand.BuildNextCommand()
bij System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
bij System.Data.SQLite.SQLiteDataReader.NextResult()
bij System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
bij System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
bij System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
bij System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
bij System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
bij System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
bij System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
bij MCDzienny.SQLite.fillData(String queryString, Dictionary`2 parameters, Boolean skipError)
bij MCDzienny.SQLiteFront.fillData(String queryString, Dictionary`2 parameters, Boolean skipError)
bij MCDzienny.DBInterface.fillData(String queryString, Boolean skipError)
bij MCDzienny.Player.LoadPlayerAppearance()
bij MCDzienny.Player.HandleLogin(Byte[] message)

So i look up the SQlite error log and it says this:
SELECT Model, Skin FROM PlayerAppearance WHERE Player =

Re: Problems with my server

PostPosted: 03 May 2014, 12:56
by joppiesaus
Looks like your database(or some code) is messed up somehow. I had this once too. That sucks! :(
Try renaming the database and start from scratch temporary until there's a solution from someone else.

Re: Problems with my server

PostPosted: 03 May 2014, 13:18
by Leeizazombie
Did you enable MySQL in properties?

Re: Problems with my server

PostPosted: 03 May 2014, 14:03
by Elisa202
Leeizazombie wrote:Did you enable MySQL in properties?


Where is it in properties? I can't find it

Re: Problems with my server

PostPosted: 03 May 2014, 14:46
by Leeizazombie
The problem is solved, one of her custom commands was effecting it.