Dc when i create character

[hatten]

Hey, i have this problem:

When i try to create a account on my own private server, i disconnect. The wierd thing is, that i don't use any repacks and neither my logonserver or world says any errors, it just disconnects me... please help

[TheZaronz]

It probably is a DB related error, try updating your DBs

[hatten]

Updated them, but i still get the same error...

[Glorianglorre]

Hmm that happend to me but i deleted it and installed it again.

[hatten]

What did you delete? and did it work after??

[Moffeman]

Check your Playercreateinfo tables, usually those who disconnects you when trying to create a character. Either one of them are empty, or a few, maybe all. Probably you downloaded a DB which isnt fully done :O

[hatten]

Hmmm after looking into some maters, i found out i get a bunch of Errors when i try to update, can it be that? and do you maybe know how to fix them??

[hatten]

what it says is:

ALTER TABLE `playercreateinfo` ADD COLUMN `introid` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `maxdmg`;
UPDATE `playercreateinfo` SET `introid` = '81' WHERE `race` = '1';
UPDATE `playercreateinfo` SET `introid` = '21' WHERE `race` = '2';
UPDATE `playercreateinfo` SET `introid` = '41' WHERE `race` = '3';
UPDATE `playercreateinfo` SET `introid` = '61' WHERE `race` = '4';
UPDATE `playercreateinfo` SET `introid` = '2' WHERE `race` = '5';
UPDATE `playercreateinfo` SET `introid` = '141' WHERE `race` = '6';
UPDATE `playercreateinfo` SET `introid` = '101' WHERE `race` = '7';
UPDATE `playercreateinfo` SET `introid` = '121' WHERE `race` = '8';
UPDATE `playercreateinfo` SET `introid` = '162' WHERE `race` = '10';
UPDATE `playercreateinfo` SET `introid` = '163' WHERE `race` = '11';
UPDATE `playercreateinfo` SET `introid` = '165' WHERE `class` = '6';

[Moffeman]

No idea... Haven't worked with SQLs since months ago... Well, we got a clear evidence that it is the playercreateinfos that is screwing your creation :P

[hatten]

Can i download a new one anywere??

[TheZaronz]

Just download a new DB and copy over it's Playercreate tables to your current DB.

[Buduh]

Use rivalDB (google it) i had the same problem till i used theirs.