Duplicate entry '14137' for key 'PRIMARY'

[deannnnnnnnnnnnn]

When I enter my hotel client and type anything I automatically disconnect. Any user who types anything disconnects. I know why this has happened. I was inserting customs into my catalogue and I may have put the query in multiple times. If someone could help me fix this I'd be grateful.

I now get "Exceptions has been saved" connection dropped" everytime someone types. I'm new to owning a hotel
I believe there's 2 errors.

exceptions.err
1/8/2014 11:16:48 PM: Error: MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '9566' for key 'PRIMARY'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at Phoenix.Storage.DatabaseClient.ExecuteQuery(String sQuery)
at Phoenix.HabboHotel.Users.Inventory.InventoryComponent.method_11(UInt32 uint_1, UInt32 uint_2, String string_0, Boolean bool_0)
at Phoenix.HabboHotel.Catalogs.Catalog.method_9(GameClient Session, Item Item, Int32 int_0, String string_0, Boolean bool_0, UInt32 uint_1)
at Phoenix.HabboHotel.Catalogs.Catalog.method_6(GameClient Session, Int32 int_0, UInt32 uint_1, String string_0, Boolean bool_0, String string_1, String string_2, Boolean bool_1)
at Phoenix.Communication.Messages.Catalog.PurchaseFromCatalogEvent.Handle(GameClient Session, ClientMessage Event)
at Phoenix.HabboHotel.GameClients.GameClient.method_13(Byte[]& byte_0)

1/8/2014 11:51:48 PM: Error: MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '14137' for key 'PRIMARY'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar()
at Phoenix.Storage.DatabaseClient.ExecuteQuery(String sQuery)
at Phoenix.HabboHotel.Rooms.RoomUser.method_1(GameClient Session, String string_1, Boolean bool_13)
at Phoenix.Communication.Messages.Rooms.Chat.ChatMessageEvent.Handle(GameClient Session, ClientMessage Event)
at Phoenix.HabboHotel.GameClients.GameClient.method_13(Byte[]& byte_0)

 

[Data]

A item with the ID '9566' already exists.

 

[deannnnnnnnnnnnn]

... I can see that lol how could I fixit..

 

[Hindi]

... I can see that lol how could I fixit..

Find that item and delete it from the database.

 

[deannnnnnnnnnnnn]

It's not in catalog_items or furniture

 

[Sarbaz]

Try a search through your database to see if you have it located in your database at all.

 

[deannnnnnnnnnnnn]

Try a search through your database to see if you have it located in your database at all.

Is there a way I can check my previous queries I made and delete the ones I entered? I can't find it in db

 

[Sarbaz]

It's easier if you just start from a fresh/clean database. Just make sure you transfer your users table to that new database to keep your users information.
Then try running the queries you need.

 

[deannnnnnnnnnnnn]

It's easier if you just start from a fresh/clean database. Just make sure you transfer your users table to that new database to keep your users information.
Then try running the queries you need.

i'm a n00b. i how do I clean my db and keep users table?

 

[Hindi]

i'm a n00b. i how do I clean my db and keep users table?

Extract SQL of users table, Now drop the database.
>Execute new SQL(Clean DATABASE)
>Execute that "Users.sql"
and you're done.
You could even keep rooms table for the users.

 

[deannnnnnnnnnnnn]

Extract SQL of users table, Now drop the database.
>Execute new SQL(Clean DATABASE)
>Execute that "Users.sql"
and you're done.
You could even keep rooms table for the users.

I must be brain dead.. i don't even know how to do that .-.