Error 2 at SQL CMD?

[Havocide]

Thus far the guide has worked fine. But when i get to the "Project EQ" section of the guide and get into the sql through dos cmd I am able to create database but am getting an error at source load_system.sql & source load_player.sql . Can anyone enlighten me as to what possible might be wrong? :shock:



http://i215.photobucket.com/albums/cc108/Havocide1/error2.jpg

[Zandig]

You are using the wrong syntax.

Here is the proper syntax:


\. load_system.sql


Also make sure all of the files are in your mysql/bin directory.

[Sakrateri]

Or you could

source load_system.sql;

[Attere]

Okay, so .. I'm in the midst of attempting to set up my own server. I've read over this, and tried each of the ways that have been posted to load the .sql files.

I get the same error, no matter the syntax. Also, the .sql files are in the bin folder, 'cept it seems to change absolutely nothing.

Is there any other issue that it could be..?

[techguy84]

Navigate to the directory you downloaded the database to, like C:\peqdb first. Do this by running your command prompt and typing cd\peqdb or whatever directory you put it in.

Another method would be to copy the two load files over to your C:\Program Files\Mysql\bin directory and then run the MySQL CLI from your start menu and do exactly what you are already doing.

Detailed instructions to do the first method are located in my PDF guide so you have some screen shots to go along with.

\. and source are the same thing, so either will work.

[Havocide]

Well it turns out that it was a directory issue that I corrected and it compiled ok. I am on the finalizing stages of the guide where it says " You will see a 2 windows come up, one will say

Wait for World to Finish LoadingPress Enter to Continue


And the other will say several lines of code, give it a second and it should stop, with the final two lines reading

[DEBUG] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[DEBUG] [WORLD__LS] Loginserver provided YOUREXTERNALIP as world address


It opens up the first window and closes too fast for me to read and leaves up the "Wait for World to Finish LoadingPress Enter to Continue" . I click continue and it opens up the 3rd bow which displays nothing at all no matter how long i wait. Not sure where to start looking for the problem other than retracing steps. :rolleyes:

[Derision]

It opens up the first window and closes too fast for me to read

This sounds like world.exe has a problem. What I would do would be open up a command prompt/ DOS window, then change directory to where you have world.exe installed and run it from there, e.g.

C:> cd \EQEmu (assuming this is where you have world.exe)
C:\EQEMU> world

This should display any error messages form World without closing the window. Then copy/paste the output here to allow further diagnosis.

[Havocide]

C:> cd \EQEmu (assuming this is where you have world.exe)
C:\EQEMU> world


This is what comes up.

http://i215.photobucket.com/albums/cc108/Havocide1/Error1045.jpg

[techguy84]

Did you set up a account with the name "eq" in mysql. I normally just use the root account at first until I can get things running right, then I vary with other features and settings. Try your root acount and see how it goes.

[Havocide]

Did you set up a account with the name "eq" in mysql. I normally just use the root account at first until I can get things running right, then I vary with other features and settings. Try your root acount and see how it goes.


Used "root" on both as a basic setup.

[techguy84]

Used "root" on both as a basic setup.

Well, your world window says that your using "eq" as the database username. Check your eqemu_config.xml file under the Database section and change eq to root.

[Havocide]

Well, your world window says that your using "eq" as the database username. Check your eqemu_config.xml file under the Database section and change eq to root.


Ya I seen that, thats very odd. here is my config.xml

http://i215.photobucket.com/albums/cc108/Havocide1/config.jpg

does this look correct ?

[Havocide]

Actually that picture posted above is wrong, this is what it actually reads.

http://i215.photobucket.com/albums/cc108/Havocide1/error14052nd.jpg

[techguy84]

Are you editing the right config file. Make sure its eqemu_config.xml and not the one that says full on the end of it.

Bout the only thing I can think of if your config file is right. World is saying its using "eq" as a account, soooooo.... I really dont quite know.

[Havocide]

Well like I said sql username and password are both set to "root" yet somehow its saying in the dos box its "eq" . I modified the correct xml file and still getting same db load error. So this is the end of the line for me. Thank you to all that helped and i made it to the end of the tunnel with the guide but just couldnt get through the door. Best of luck and thanks for the help.

[Diuretic]

I printed out techguy's guide before it went down and followed it page by page. It worked exactly as written.

I can't tell if we're all using the same instructions, but I wanted to give techguy props for creating a clear, working doc.

[Havocide]

I printed out techguy's guide before it went down and followed it page by page. It worked exactly as written.

I can't tell if we're all using the same instructions, but I wanted to give techguy props for creating a clear, working doc.

I am not saying that the guide is not direct and on target. I'm simply saying that I myself have something configured or installed incorrect with sql, the db, or path directories. So yes the guide worked great imo and was pretty simple to follow. My drives are different paths and somewhere down the line I went off track. Thanks to Zandig, Sakrateri, techguy84, Derision, for taking the time to try and help me out.