New bug in dbsever?

[qwqwqw]

Me and some friends are playing with the files and dbsever is sometimes saying cannot add to TBL_UserItems violation of primary key.
But there is only 1 item with the primary key

so maybe the item is not deleted from database before it goes to new char and added to database again
or maybe some dupe bug

or maybe something else

sometimes when this happens the item vanishes too :eek:

[MentaL]

[thedeath]

ye i noticed the server sometimes 'dupes' (not really duping but anyway) certain shop items like torches
server likes to use the same makeindex 2/3 times for same item
just allow it to dupe i'd say (not seen any good items dupe just torches, teleport scrolls)
and well the stacked items use the same id on purpose aswel so :(

[qwqwqw]

No no these items drop from monster or GM made
it happens when player A drop item and player B pick up (also trade to)
it says can not insert value violation of primary key TBL_UserItems
error inserting item char:playerb idx:3166723

and sometimes not always item vanish and these are good items!

[thedeath]

just enable duplication :p
obviously if an item is traded it can get duped for a short while
(normaly dbserver only saves every 10 mins or when you logout so if the person recieving the item gets saved before the person giving the item then it's 'duped' untill the person giving the item gets saved

[qwqwqw]

So remove primary key?

[thedeath]

yes

[qwqwqw]

I did this
I set char name and idx to combined primary key this way 1 person can not dupe but allows accidental "dupe"