Some addresses have two rows in the database

tmpim / Krist

Krist is a centralized-database economy system for Minecraft servers. Krist does not use a block-chain, or any similar technology. Krist is not a "cryptocurrency".

https://krist.dev/

GNU General Public License v3.0

24 stars 19 forks source link

Some addresses have two rows in the database #30

Closed BTCTaras closed 7 years ago

BTCTaras commented 7 years ago

A small subset of addresses registered since August are showing up twice in the /addresses list. Here is a list of affected addresses in order by date first seen:

klyqydsfap
ke79ome5b8
kn02cr56r7
kjeecrrqqr
kicik2r5g6
kr7kmk9l1x
ki4cczc2kh
ktp72zdq9h
kgnlf4rp73
kpnk2cuyl8
k8ctexesav
k45p93qf19
klj8lsgqa2
kxou7tf2en
k87uxxrrpl
kuejyswywp
kggjd0msht
kvqncijeeh
kisqtrv6d8

I don't think this has happened earlier than August.

Lemmmy commented 7 years ago

i think i know what caused it but not 100% sure how to fix it. for now i removed the duplicate addresses.

Lemmmy commented 7 years ago

updated the database - there was an address your list missed out. the address column now has a unique key, so the server will error when somebody does something resulting in a duplicate address. this will probably lead me to the error