SQL error: #cashpoints vs #CASHPOINTS

[Peopleperson49]

In my global_reg_value there are two cashpoint entrys. One is #CASHPOINTS and another is #cashpoints. When I first setup my server I tried using them, but they always errored when you actually tried to buy something with them. It would show that your cashpoints increased and even that you had them, but when tried to use them the game would error and players client would crash. The server would indicate an error, something like invalad #cashpoints. It is giving me the following errors:

: DB error - Duplicate entry '0-#cashpoints-200063' for key 'PRIMARY'[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color]

[color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][Debug]: at inter.c:622 - INSERT INTO 'global_reg_value' ('type...[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color]

[color=#000000][font=Segoe UI]Peopleperson49[/font][/color]

Edited August 9, 2012 by peopleperson49

[Euphy]

What revision are you using?

[Peopleperson49]

Happened with both 16265 and 16600.

Peopleperson49

[Mystery]

Isn't it supposed to be #CASHPOINTS and not #cashpoints?

(Currently stored as account vars in global_reg #CASHPOINTS and #KAFRAPOINTS.)

This type of shop will not allow you to sell items at it, you may only

purchase items here. The layout used to define sale items still count, and

"<price>" refers to how many points will be spent purchasing the them.

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/doc/script_commands.txt

[Peopleperson49]

I'm not sure what was happening with it, but it is listed twice there. I used "@cash 10" which said that I gave recieved ten cash points. When I went to my control panel I got the error below. This also happened with another person I had test it out. On top of that we can't buy anything from a cashshop with it.

: DB error - Duplicate entry '0-#cashpoints-200063' for key 'PRIMARY'[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color]

[color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][color=#000000][font=Segoe UI][Debug]: at inter.c:622 - INSERT INTO 'global_reg_value' ('type...[/font][/color][/font][/color][/font][/color][/font][/color][/font][/color][/font][/color]

Peopleperosn49

Edited August 9, 2012 by peopleperson49

[Mystery]

Have you tried removing the cashpoints value for account 200063?

[Peopleperson49]

Modifying the db may remove the value, but I'm trying to fix the problem!

Peopleperson49