Back to Square 2

06/19/2009 22:57 Andrew.A#1

Right I went out left my server running, I come home my bros trying to make his own but wrote over my database in Navicat...

I try and run my server and in gameserver.exe when i try log i get System.IndexOutOfRangeException: Coul not find specified column in results
at MySql.Data.MySqlClient.MySwlDataReader.GetOrdinal( String name)
at MySql.Data.MySqlClient.MySwlDataReader.get_Item(St ring name)
at CoEmu_v2_Gameserver.Database.Database.GetItems(ClientSocket CSocket) in C:\Documents and Settings\Andrew\Desktop\CoEmu V2\CoEmu v2\CoEmu v2 Gameserver\Database\Database.cs:line 419
at CoEmu_v2_GameServer.PacketProcessor.ProcessPacket( Byte[] data,ClientSocket CSocket) in C:\Documents and Settings\Andrew\Desktop\CoEmu V2\CoEmu v2\CoEmu v2 Gameserver\PacketProcessor.cs:line 124

Help please I've got no idea what the problem is.

06/19/2009 23:01 Zeroxelli#2

Quote:

System.IndexOutOfRangeException: Coul not find specified column in results

Your database is fucked, delete it and use the backup again.

Code:

DROP DATABASE conqueremu;

EDIT: Actually, that should reference the items table. Maybe he tried to add my WuxingOven without adding the column.

06/19/2009 23:40 Andrew.A#3

Say what now?

06/19/2009 23:48 Zeroxelli#4

Code:

Database\Database.cs:line 419

Copy paste that line to here.

06/19/2009 23:53 Andrew.A#5

Code:

                Item.Progress = Convert.ToInt32(DR["Progress"]);

06/20/2009 00:04 Zeroxelli#6

Yep, that's my WuxingOven code. You'd need to finish adding it or remove it, here's what is supposed to be added (or removed if you'd like) [Only registered and activated users can see links. Click Here To Register...]

06/20/2009 00:26 Andrew.A#7

Well ive added the rest now im gonna try it out.
Edit: still didn't work, im confused what happend, when i had my server i had this running perfectly but now i cant even log on.

Edit 2:Fixed it lol I made a typo ty =)