[SQL] DB Error when trying to make characters on the server

[EpsilonX74]

hello been trying to setup a private server and been getting an error when trying to make characters on the server

[SQL] DB Error - duplicate entry "21828-0" for key "primary"
[SQL] Query: Insert into chars(Charid,accid,charname,pos_zone,nation) Values(21828,1000,"",236,1);


i can see that its either wanting to populate, or its supposed to be populated, i just don't know which it is.
cant figure out how to get around it any help would be appreciated

[whasf]

Your chars table is messed up. It gets the next ID by doing a SELECT MAX(charid) FROM chars

[EpsilonX74]

yeah i can see that part i just don't know its supposed to populate when i create a character or if its supposed to already be populated. but since this post i tried re-executing the table in my SQL which seemed to have solved said issue, unfortunately now i'm getting an issue with it hanging up at the downloading data screen before getting a 3001 error. i did read how this can be an issue at times where i just need to log out then back in to see if its remedied. if i'm wrong please let me know.


Edit:
ok i see that the login server is not handing the characters off to the game server. i've rechecked my zone_settings, and rerun them just to make sure they were infact running, they are. i know they different servers have a conf file that has ips for them i just don't know if i need to turn those into the external as well. i could just be over thinking it i just don't know whats causing the login server to not hand off to the game server.

[kjLotus]

just to make sure... your game server has absolutely nothing in the output window, right?

[EpsilonX74]

correct, the log in server shows all the activity, but when i go to log into game it just hangs at the downloading data. and still no activity on the game server.

[kjLotus]

ok yeah, it's your zone_settings IP addresses then. what do you have in zone_ip column in your zone_settings table?

[EpsilonX74]

its the same as the wiki says,

UPDATE zone_settings SET zoneip = 'externalIP';

i even went into the zone settings to confirm they have all been changed to my extenalIP, and they have


i am trying to connect on the same machine as the server, i am using the hairpin, but i also have someone else outside the lan trying to connect as well with the same results.

EDIT: so i've cleared up alot of the problems i'm having but keep finding more as i clear one up. as it stands now as soon as i open my servers they close, or crash i can't but they go away as soon as i open them.