Issue preventing new character creation

[CatsEyeXI]

Hello, when my users are trying to start a new character they are getting kicked... in the topaz_connect log i'm seeing

[23/Jun] [15:17:33] [SQL] DB error - Duplicate entry '109-0' for key 'PRIMARY'
SQL: INSERT INTO chars(charid,accid,charname,pos_zone,nation) VALUES(109,1077,'Limabean',234,1);

How can i fix this?

[TeoTwawki]

duplicate entry means the entry already exists for some row that is trying to be added. check your database - you might have a half-made or half-deleted character

[CatsEyeXI]

how can i fix this? im not great with sql? i did delete some rows from chars as someone created a load of alts on the server and abusing the starting gil

[TeoTwawki]

look for the rows that match the character/account mentioned in the duplicate warning. some undoubtedly got left behind on some of the tables.

[Brierre]

I'm not sure if you found the cause of this, but I was getting something similar when I first tried to move my code to LSB from Topaz. I found that the migrations weren't all completing because my python was out of date. Once I updated that, no more issues. Hope this helps.

[CatsEyeXI]

What is the 'correct' way to remove characters or accounts?

[zach2good]

You had it right, deleting from the char table should clean up all the related stuff

[TeoTwawki]

You had it right, deleting from the char table should clean up all the related stuff

Depends where you do the delete at. the char table itself should kick off the trigger that nukes the rows in the other tables. but if rows in the other tables were partly removed first the trigger might error.

If the trigger is missing/damaged or we had a new table with char data that also gets created at char create that we then forgot to cleanup at char delete that could also cause this.

[CatsEyeXI]

sadly, i dont know enough about sql to help, im a sysadmin by trade. i can get my hands a little dirty with the dev stuff but after a while i start sinking... If theres anything i can do to help diag the problem to benefit the project please let me know. thanks for your prompt responses.

[TeoTwawki]

for now lets focus on getting your server back to normal. we'll circle back to the cause after. if you find the "duplicate" its complaining of char create should get back to normal.