Pet Bug

[RealSubaru]

Hello,

today i experienced a bug that is about pets. When i place a cat in my room, it changes to a horse after i reconnect. I get the following error in the console:

Spoiler: Error

23:15:54 - [ERROR] Error in query:
INSERT INTO bots_petdata (id,type,race,color,experience,energy,createstamp) VALUES (1, 1,@1race,@1color,0,100,UNIX_TIMESTAMP())
MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry '1' 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.ExecuteNonQuery()
at Plus.Database.Adapter.QueryAdapter.RunQuery() in C:\Users\Sledmore\Desktop\PlusEMU\Database\Adapter\QueryAdapter.cs:line 167

Are there any solutions i can test? (Sorry for my bad english, i am from germany)

 

[JayC]

Bots_petdata needs to have the ID as a primary key that is auto increment

 

[RealSubaru]

Bots_petdata needs to have the ID as a primary key that is auto increment

Hmm ok. But i don't know how to do this. I am new in this Retro Scene and i have no clue what todo now :/

 

[cammy]

I think this is done via table design on navicat.

 

[AssLikeThat]

Hmm ok. But i don't know how to do this. I am new in this Retro Scene and i have no clue what todo now :/

If you are using Navicat, do CTRL + D on your bots_petdata

Click on "id" and tick "auto increment" and click in the "Key" column to add the primary key

 

[RealSubaru]

Thanks for your help i fixed it!