MySQL Support - Can't create account & chars

[nanakiwurtz]

OMG, I don't know what went wrong, now I can't create a new account and even chars.

1. I have tried to manually create an account in MySQL and I'm able to log in, but can't create a new char.

I have recheck the conf files

new_account: yes
char_new: 1

2. Another issue I found is the value in 'sc_data' isn't reset even after logout, I have set this but still no luck

// Will certain skill status-changes be removed on logout?
// This mimics official servers, where Extremity Fist's no SP regen,
// Strip Equipment, and some other buffs are removed when you logout. Setting is:
// 0 = remove nothing.
// 1 = remove negative buffs (stripping, EF)
// 2 = remove positive buffs (maximize power, steel body...)
// 3 = remove both negative and positive buffs.
debuff_on_logout: 3

3. What is the difference between 'char_server_db' and 'char_db' ?

Hmm..

[Spre]

What EXE date are you using, I have noticed Some exe's Suck really badly and you can;t create chars, and when you do, you have to relog to see them AND you can not ever log them in.

Other then that, if you think it is a setup error, just dump your database, reimport the sql files and go from there.

[nanakiwurtz]

Okay, thanks for the reply Spre, I'm using 2012-04-10.

I'll try to dump and dig into it further

[Akkarin]

Are there any errors showing up on the char server?

When trying to create the new character, how far do you get? (Are you able to click on the button, can you get to the creation screen, can you change the stat modifier?)

[nanakiwurtz]

Thanks for replying Akkarin, when I want to create a new account it just shows unregistered ID, after I dig in in the source files and modify them, eventually I can get it to work now.

When I create a new char, I can only choose the name, hair and hair color. I modify my mmo_auth function and it works now too.

(It takes me up to 3 weeks to figure it out)

Hmm another thing that still confuses me is that the sc_data isn't reset even after logout.