Error for owner (me)

[Grapejelly1231]

I own a zombie survival server with mcdzienny software, it works great for all my guests and everyone else except for me. Every time I come on I get an error on the console and all of my stats are erased, and I can't even use /whois grapejelly1231 cause it says i'm offline, no stats show up, and it says to use /whowas instead even though I am in the game.

Error:

Spoiler:

Type: OverflowException
Source: mscorlib
Message: Value was either too large or too small for an Int16.
Target: ToInt16
Trace: at System.Convert.ToInt16(Int64 value)
at System.Int64.System.IConvertible.ToInt16(IFormatProvider provider)
at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
at System.Data.SQLite.SQLite3.GetValue(SQLiteStatement stmt, Int32 index, SQLiteType typ)
at System.Data.SQLite.SQLiteDataReader.GetValue(Int32 i)
at System.Data.SQLite.SQLiteDataReader.GetValues(Object[] values)
at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values)
at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataTable[] 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)

If someone could please help me out with this i'd really appreciate it .

[ismellike]

You can use this command. Note that it has to be compiled in VS.

Code: Select all

//
// Coded by dzienny - 2013
//

using System;
using System.Data;
using System.Linq;

namespace MCDzienny
{
    public class CmdSql : Command
    {
        public override string name { get { return "sql"; } }
        public override string shortcut { get { return ""; } }
        public override string type { get { return "other"; } }
        public override bool museumUsable { get { return true; } }
        public override LevelPermission defaultRank { get { return LevelPermission.Nobody; } }

        public override void Use(Player p, string message)
        {
            DataTable queryResults = DBInterface.fillData(message, false);
            if (queryResults.Columns.Count == 0)
            {
                Player.SendMessage(p, "Query executed.");
                return;
            }
            if (queryResults.Rows.Count == 0)
            {
                Player.SendMessage(p, "No results found.");
                return;
            }

            // Display column names.
            string columnNames = String.Join(" | ", queryResults.Columns.Cast<DataColumn>().Select(c => c.ToString()).ToArray());
            Player.SendMessage(p, columnNames);

            // Display rows data.
            foreach (DataRow row in queryResults.Rows)
            {
                string rowItems = String.Join(" | ", row.ItemArray.Select(i => i.ToString()).ToArray());
                Player.SendMessage(p, rowItems);
            }

            queryResults.Dispose();
        }

        public override void Help(Player p)
        {
            Player.SendMessage(p, "/sql [query] - executes [query] on the server database.");
        }
    }
}

If you want to delete your record:
/sql DELETE FROM Players WHERE Name='Grapejelly1231'

I will upload the dll for you.

www.mediafire.com/?2k544t45pm0kldm

Once you have that downloaded just move it into your extra>commands>dll folder

Then on your server do /cmdload sql

Then use this command-
/sql DELETE FROM Players WHERE Name='Jay53928'

*if your username isnt Jay53928 replace that^

Try this

www.mediafire.com/?2k544t45pm0kldm

Add it to your server like a normal cmd

If you want to delete your record:

/sql DELETE FROM Players WHERE Name='Grapejelly1231'

[Grapejelly1231]

@ismellike
It worked!! Thanks so much I really appreciate you taking your time to do that for me .

[ismellike]

You should really thank Dzienny I just gave you the info.

[dzienny]

I haven't even expected that so many people got this error. Well solved ismellike!