hot to fix the sql cash points debug

[Famous]

[Famous]

bump!

anyone?

[GmOcean]

As far as I can see, it clearly says Duplicate Entry, which would suggest somewhere in your query You have a duplicate entry. Also, I failed to see why you needed to specify the account ID repeatedly when trying to replace certain values.

[Patskie]

Primary key should be unique. In your case you are duplicating a data in a column which is considered a primary key 

[Emistry]

since most of the "ID" inside the table of each SQL table for RO is kinda useless...and meaningless...you can just simply remove all the "ID" column / datafield ...and re-import it ...