resetting stats

[the_evil_one44]

this rather long error code comes up whenever I connect and also when I do /whois

Code: Select all

when i first connect:
dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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.HandleLogin(Byte[] message)

Code: Select all

when I do /whois
----03/12/2013 18:26:19 ----
Type: SQLiteException
Source: System.Data.SQLite
Message: SQLite error
near " ": syntax error
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)

-------------------------

----03/12/2013 18:26:26 ----
Type: FormatException
Source: mscorlib
Message: String was not recognized as a valid DateTime.
Target: Parse
Trace:    at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
   at System.Convert.ToDateTime(String value)
   at MCDzienny.CmdWhois.Use(Player p, String message)
   at MCDzienny.Player.<>c__DisplayClass28.<HandleCommand>b__23()

-------------------------



I think it has something to do with my hours being broken as I can't actually change them through console.

[Leeizazombie]

Your SQL Database file may be corrupted, I suggest trying to get a new clean one (keep a backup of the other one, I might be wrong). This would mean redoing people's titles and colors ect..

[Leeizazombie]

There's actually two files that are possibly broken: System.Data.SQLite.dll and MySql.Data.dll

I might be wrong, but it's worth a try, so please keep a backup just incase.

[the_evil_one44]

would this get rid of people's stats (levels, ranks ect) too?

[Leeizazombie]

It might rid of stats and levels unfortunately but the ranks are stored in text files.

[the_evil_one44]

Ok, thanks for the help

[dzienny]

There's some problem related to the database structure. I probably can fix this, but I need more information. Please include a relevant fragment of the normal log, because it should contain important clues.

[the_evil_one44]

What do you mean by 'normal log'? Chat/command logs?

[dzienny]

What do you mean by 'normal log'? Chat/command logs?

I mean the main log, which consists of chat and - what's important here - server messages. It should contain information that an error occured and the sql query that failed.