[Other] Have i broken my SQL/DB?

[RealLionSoul]

Hey guys.

Was trying to make some new boots and for some reason i cannot leave the row or delete the rows without getting this error. Google is telling me its a primary key issue?

Although i havent edited the primary key etc. Any help before i put the original back on and have to start from scratch.

Thanks.

 

[Paniko]

I think you have 2 IDX 666.. I think the error is here try to change one on the 2 idx with a new value

 

[RealLionSoul]

I tried this mate, i even ran this query to delete both the fields but then i got the code 10667 error.

So i have started fresh. Also set up the auto backup of the databases incase i break it in the future

Rep+ for the reply dude. Would like to know what caused this

 

[Paniko]

ok the backup is always the best choice

 

[ervinzed]

i use libre office calc to modify the database and then import it (.xls) to sql

i created 72k items not knowing about the 65k limit and then i didnt save it by mistake and i lost all my work LMAO :lol

now im left with broken 60k+ item .xls files