New Accounts Crash Logon Server

[nubblez]

Whether I am using the Account Creation Page or manually editing the 'accounts' table, both cause the logonserver to crash or unable to start. This image sums up what happens. It stops there and I get a Vista error saying "This program has stopped working."

I am using Keazain's repack x30 (2/14/09)

Thanks for any and all help!!

[Remus]

perhaps you should get that fixed...







, on the lighter note; sorry i cant be arsed to help you as we cant see your configs

[nubblez]

Sorry about that. They will be below.

pastebin - collaborative debugging tool - Logon Server
pastebin - collaborative debugging tool - Realms
pastebin - collaborative debugging tool - World

[1ns0mnia]

1. <LogonServer RemotePassword = "root"
2. AllowedIPs = "5.167.234.78/24"
3. AllowedModIPs = "127.0.0.1/24">

To This:

1. <LogonServer RemotePassword = "root"
2. AllowedIPs = "5.167.234.78/24"
3. AllowedModIPs = "5.167.234.78/24">

about the crashing problem, have you tried this on a different database? your configs look fine to me, the only thing i can think of is an out of date database, im not 100% sure though but its worth a try?

Take a look at this thread for Db's and Latest Compiles:
http://www.mmowned.com/forums/emulat...ready-use.html

Hope this helps

[nubblez]

Hi. Thanks for the reply! I will make that change, thanks.

As for the database, I don't really see a link there for DBs? I recently updated the DBC files. Is that what you are talking about?

Thanks for all your help =)

[1ns0mnia]

ah no, thats the client server files, what the server uses i mean the actual Database,

if your running an out of date database, then the logonserver might not read it proply = crash, lemme look at ur configs a sec hang on

[1ns0mnia]

ok your using navicat or some other DB editor for your database right?

Download NCDB

run that into your database, and update your config files with the new database name

[nubblez]

Like execute the batch file? Can you explain it in more "noob-like" terms?

[Lakelog]

The crash is caused by (null) fields in the accounts table. If you fill in the (null) fields, you won't get the logonserver crash. However, when you create an account via a website, it leaves (null) fields in the table, and thus the logonserver will crash every time you create a new account via a website unless you do some fancy schmancy mysql thingie in the account creation php file.

[Invisible]

i'm having this problem as well and i made sure there were no null fields but it still didn't work so i have no idea what to do lol

[nubblez]

i'm having this problem as well and i made sure there were no null fields but it still didn't work so i have no idea what to do lol

Same. I eventually figured out what Lakelog stated, and tried putting values in where they were needed or putting a "blank field". It still didn't work.

I am going to try a newer logon.sql file to see if it helps. EDIT: Okay, the newest logon.sql is from the 10th of Feb. So where can I grab an updated ArcEmu logon.sql?

What could be wrong here?

[nubblez]

ok your using navicat or some other DB editor for your database right?

Download NCDB

run that into your database, and update your config files with the new database name

Sorry for the double post - How does this work? Not familiar with this folder structure. =/

[1ns0mnia]

ignore my previus post, thats the NCDB World database, you need the logon one, forgive me

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ok, ive uploaded a file onto filebeam for you,

Filebeam - Free Fast File Hosting

its the character and logon database structure, with all the rev updates so far (updated it like a second ago)

Installation:

ok, a new logon database, basically install the character and logon structure SQL's (in the .zip file) (execute them both into the same database).

after this to into the updates folders and execute all the SQLS from about rev 1000+ from both logon and character updates. (number on the left hand side)

this should fix your problem, but if not then heyy, atleast you have an upto date logon database haha

but yeh this should fix the problem with your logon server

p.s. this WONT effect your world database in any way, these files are only the logon database, nothing to do with the world, any more questions or proelms then just pm me

[Algorithm]

you can simply edit the table and set default value to Not Null

[nubblez]

ignore my previus post, thats the NCDB World database, you need the logon one, forgive me

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ok, ive uploaded a file onto filebeam for you,

Filebeam - Free Fast File Hosting

its the character and logon database structure, with all the rev updates so far (updated it like a second ago)

Installation:

ok, a new logon database, basically install the character and logon structure SQL's (in the .zip file) (execute them both into the same database).

after this to into the updates folders and execute all the SQLS from about rev 1000+ from both logon and character updates. (number on the left hand side)

this should fix your problem, but if not then heyy, atleast you have an upto date logon database haha

but yeh this should fix the problem with your logon server

p.s. this WONT effect your world database in any way, these files are only the logon database, nothing to do with the world, any more questions or proelms then just pm me

So I am executing character.sql, logon.sql, and 1000+ rev .sqls?