tMySQL query error: Duplicate entry

[CASAVANT]

As stated in the title, i'm getting an error that is causing saving issues for players on our server. Everytime they leave, and come back, it's as if they are new players. They get the same amount of money they started with, etc. Im not really sure what to do about this. It was working fine before.

tMySQL query error: Duplicate entry 'STEAM_0:1:91356093' for key 'PRIMARY'Query:
 INSERT INTO metrorp_wallets (`steam`, `rpname`) VALUES('STEAM_0:1:91356093', 'T

Found something else:

Trace:
        1: Line 32      "Trace" lua/includes/extensions/debug.lua
        2: Line 33      "nil"   gamemodes/catalystrp/gamemode/data.lua
3       C function
        4: Line 84      "nil"   lua/includes/modules/hook.lua


tMySQL query error: Duplicate entry 'STEAM_0:0:53698800' for key 'PRIMARY'Query:
 INSERT INTO metrorp_wallets (`steam`, `rpname`) VALUES('STEAM_0:0:53698800', 'T

[Pandaman09]

Your problem is likely that you are attempting to use INSERT for every call. Instead, you need to use INSERT when creating a new entry and UPDATE when updating information.
[URL="http://sapabaptutorial.blogspot.com/2009/11/difference-between-insert-update-and.html"]This link may help you understand the differences between the two along with the MODIFY command[/URL]

[CASAVANT]

[QUOTE=Pandaman09;49493613]Your problem is likely that you are attempting to use INSERT for every call. Instead, you need to use INSERT when creating a new entry and UPDATE when updating information.
[URL="http://sapabaptutorial.blogspot.com/2009/11/difference-between-insert-update-and.html"]This link may help you understand the differences between the two along with the MODIFY command[/URL][/QUOTE]

Not sure where to even look then. It has been working for a while until today.

[Blasteh]

or edit the update statement to include this on the end:

ON DUPLICATE KEY UPDATE rpname = rpname

or something similar

[RealDope]

So you don't even know where your own gamemode updates the database?

Is "catalystrp" from catalyst-gaming.net?

[CASAVANT]

[QUOTE=RealDope;49494059]So you don't even know where your own gamemode updates the database?

Is "catalystrp" from catalyst-gaming.net?[/QUOTE]

We managed to fix it, and no, they have hosted the gamemode, and we are now hosting. They created the gamemode at "catalyst-gaming.net" but we now own a copy of the gamemode.