Duplicate Primary Key Mysql

[SmokeyBR]

a few days back i saw this on hive log

Database: [Error] Error 1062 (Duplicate entry '69457' for key 'PRIMARY') in MySQLStmtExecute SQL: 'DELETE FROM `Object_DATA` WHERE `ObjectID` = ? AND `Instance` = ? VALUES(69457, 11)'

tried to deleate manually but could not then i kinda forgot about it....

Today when i was updating and testing garage another one showed up.

Quote

Server RPT

13:44:48 "GARAGE: Smokey (xxxxxxxxxxxxxxxxx) retrieved MTVR @038124 [3871.62,2941.31,0.0952187]"
13:45:27 "GARAGE: Smokey (xxxxxxxxxxxxxxxxx) stored MTVR @038124 [3871.71,2939.65,0.102194]"
13:45:27 "DELETE: Player PID#x(Smokey)(xxxxxxxxxxxxxxxxx) deleted object with ID: 70447"

Quote

HiveExt.log

2018-02-24 13:45:27 Database: [Error] Error 1062 (Duplicate entry '70447' for key 'PRIMARY') in MySQLStmtExecute SQL: 'DELETE FROM `Object_DATA` WHERE `ObjectID` = ? AND `Instance` = ? VALUES(70447, 11)'

I have no ideia how to resolve this or what is the actual issue, from what i can tell its trying to delete the object but not deleating due to the primary key error, can anyone help out with this ?

[SmokeyBR]

heres the thing when i search for ObjectID = 70447 only one result shows theres no duplicates or at least not showing duplicates, and when i try to delete it gives the same error and doesnt delete.

[SmokeyBR]

im searching through phpmyadmin i did also search with Mysql workbench (without limiting rows) both showed only one result.

i have not tried changing ObjectID will do once i get a chance, thou if anyone knows why this is happening be nice to know why.

thanks

[SmokeyBR]

@ebayShopper thanks for the help even thou i tried changing ObjectID number still couldnt not delete the data.

i had seached before for solutions to the error on more specified forums for mysql and i did come across a guy saying that backing up database, dropping it and recreate the database could solve it, i tried and did work did not even need to delete the vehicles causing the error.

Something broken in database ? anyways its fixed... hopefully hehe

for reference http://www.rathishkumar.in/2016/01/how-to-solve-mysql-error-code-1062.html