Zone.exe Crash... help!

[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.

[techguy84]

Well, I just went and removed everything and tried a fresh installation. I am now getting the same error myself. I think that I may made a version mistake in the guide regarding the emulator itself. I am looking into it so hold on lol.

Feel free to slap me if I made a mistake.

[techguy84]

As far as the zone corrdinates issue, what race is your character. Froglok default to south qeynos and there is no starting area for them. Dont know what this is as I havnt played live for a while.

[rameho2433]

well. my character was a froglok. But the zone crashed with my dark elf too. who DID start in neriak.

[techguy84]

I know about the crash, I am trying to determine what mistake "I Made" in the guide. I had it working, but for some reason now I am also getting the zone crash. Hopefully I can figure it out and get back to you.

Like i said, feel free to /smack me

***UPDATE****

I figured out what "I" did wrong. There was a step that I more or less to for granted and forgot to add into the guide. So here's your fix

In your EQ directory, there are two files called

Spells_en.txt
Spells_us.txt

Copy both of these over to your EQEmu directory. Now your good to go.

I do apoligize for this. It was a simple step that I normally do without thinking, like a habit, and I completely omited out of the guide. It has since been updated so you should be ready to go.