Page 1 of 1

Need some help

PostPosted: 09 Oct 2013, 16:01
by Elisa202
Hey, i just made some changes on my server and i am experiencing a error. It does not save titles, colors etc. And each time you join the server your name is yellow. Also everytime you login every data on your profile gets lost.

The error (In dutch)
-------------------------
----9-10-2013 16:49:21 ----
Type: OverflowException
Source: mscorlib
Message: De waarde is te groot of te klein voor een Int16.
Target: ToInt16
Trace: bij System.Convert.ToInt16(Int64 value)
bij System.Int64.System.IConvertible.ToInt16(IFormatProvider provider)
bij System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
bij System.Data.SQLite.SQLite3.GetValue(SQLiteStatement stmt, Int32 index, SQLiteType typ)
bij System.Data.SQLite.SQLiteDataReader.GetValue(Int32 i)
bij System.Data.SQLite.SQLiteDataReader.GetValues(Object[] values)
bij System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values)
bij System.Data.ProviderBase.SchemaMapping.LoadDataRow()
bij System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
bij System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
bij System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
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.DBInterface.fillData(String queryString, Boolean skipError)
bij MCDzienny.Player.HandleLogin(Byte[] message)

-------------------------
----9-10-2013 16:49:41 ----
Type: FormatException
Source: mscorlib
Message: De tekenreeks is niet als geldige DateTime herkend.
Target: Parse
Trace: bij System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
bij System.Convert.ToDateTime(String value)
bij MCDzienny.CmdWhois.Use(Player p, String message)
bij MCDzienny.Player.<>c__DisplayClass26.<HandleCommand>b__21()

-------------------------
----9-10-2013 16:49:57 ----
Type: FormatException
Source: mscorlib
Message: De tekenreeks is niet als geldige DateTime herkend.
Target: Parse
Trace: bij System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
bij System.Convert.ToDateTime(String value)
bij MCDzienny.CmdWhois.Use(Player p, String message)
bij MCDzienny.Player.<>c__DisplayClass26.<HandleCommand>b__21()

Re: Need some help

PostPosted: 09 Oct 2013, 19:11
by joppiesaus
Seems to be that a value is too big. Weird error. I think Dzienny could fix it.
Try rename your databases. Maybe that's a temporary solution? <ok>

Re: Need some help

PostPosted: 09 Oct 2013, 21:42
by dzienny
Does this happen only for you? I assume all other people's stats like title, color are saved?

Also, there should be additional sql information in the normal server log at 9-10-2013 16:49:21.