Jump to content
  • 0

Duplicate Primary Key Mysql


SmokeyBR

Question

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 ?

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

@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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
  • Discord

×
×
  • Create New...