Zone.exe Crash... help!

[rameho2433]

Also, I noticed when I'm logging in and creating a character, it isn't showing up on the _character table.

but when i log back in, the characters are there. odd?

[kouhei]

[Status] Start zone query: SELECT x,y,z,zone_id,bind_id FROM start_zones WHERE p
layer_choice=14 AND player_class=12 AND player_deity=208 AND player_race=330

No start_zones entry in database, using defaults

I think it has to do with your start_zones in the DB. Try and re source the new start_zones.sql and zones.sql into the db and then restart the db that probaly should fix it.

[rameho2433]

sorry i'm a noob. what exactly do you me by re sourcing the files?

[Dr Zauis]

Look at this tutorial:
http://www.eqemulator.net/wiki/wikka...indowsServer64

Now look how as they are logged in to mysql as user eq they are sourcing empty_users from the .sql files (usually people put them in the /bin folder of mysql.

Now..I dont know where you got your database but it might be missing the tables mentioned so check the /bin folder in mysql to see if they are there.

If so then you need to log back in to mysql and source them.

[rameho2433]

There are no sql files in my bin folder.

i used the most recent tutorial, with CVS to download the PEQ database.


I don't know if that helps. I have no file called "empty_zones"

[techguy84]

Ok, since you mentioned CVS, your using PEQ right. In the folder that you downloaded the database, (if you used my guide, It would be proably C:\peqdb) there are two sql files. start_zones.sql and zone.sql

Try resourcing both of those manually.

Open up your cmd prompt, navigate to the directory (cd\peqdb) load up mysql (mysql -u root -p), select your peq db (\u peq) and type source start_zones.sql and source zone.sql



Furthermore, try to run your zone.exe files as a standalone, by simply clicking on zone.exe and see if it still crashes. I get crashes when using the launcher. I am working to find out why, and when I do, I will upadte the guide accordingly.


Also, when you sourced in the load_system and load_player sql files, did you first navigate to the peq directory.

[rameho2433]

alright, well I'm not at home at the moment, so I can't try it out, but I can tell you that when I attempt to source zone.sql and start_zones.sql, i get mysql error 2, cannot open or access table.

I got it to go once, and it gave me about a million system beeps saying that the table and rows already exist.

I will try running standalone zone.exe when I get home, but any info you have on why I'm getting the error when I try to source those files would be helpful. I'm thinking maybe they're already properly sourced. or maybe they're corrupt and I should just start over?\

as for when I originally sourced system and players sql files, yes I did navigate properly.


I'll get back to you on the standalone zones.