5.0 server error :(

[DuDeMaN]

I've been trying to get a 5.0 server up for a week or two now, but still having a weird error i can't seem to figure out. I've installed the DB found here: http://www.eqemulator.net/forums/viewtopic.php?t=10314

(looks nice btw, i've seen it on another server)

although I'm getting this error while loading world.exe:




I see it's a database problem, but I'm sure its not just THIS database, cause I get it no matter which i try
If it were any other kind of error, I may be able to fix it, but I'm not the brightest crayon in the box when it comes to this SQL stuff. I've run lots of other servers, so I'm 99% sure It's not just some dumb error I caused ... everything is set up the same as the others.

Any help is greatly appriceated, looking forward to having a 5.0 server up and runnin for ya'll

[predominant]

That image link is broken

[DuDeMaN]

DOH!... i can see it just fine :(


h8 geocities...try here


http://www.geocities.com/dudeman_200/theerrorwindow.JPG

This page is not available. when i click on that link.

[Qtoken]

its a trick with Geocities links .. just copy the link then add a single space at the end of the line.

Works fine

[DuDeMaN]

lmao... like i said, Geocities sucks, you have to copy and paste the link into your browser, Geocities doesn't alow direct linking of images , sorry i didn't mention it

[tcsmyworld]

Apparently you sourced something other than the .sql that comes in the D/L.
The .sql that is in the D/L is a Complete DB with Items, npcs , loot , vendors etc..
To use it , create a fresh DB and source "ONLY" the .sql found in the D/L.
If you are setting up a public server , you need to do nothing else except make sure all your .ini files are correct.
If you are creating a LAN server , then you need to add account info to the DB , and make sure that your Miniloginaccounts.ini is correct.
Hope that helps you out.

[DuDeMaN]

thanks for the reply, but that's all that i have been doing, i've only sourced the db that comes in the download... i get the error. I dump the DB and try again with a different DB name, resource, change the db in DB.ini, same thing :-\... i've run out of ideas :(

[tcsmyworld]

Try the DB in the link on this post-
http://eqemulator.net/forums/viewtop...96a3a31e367d21

Thats the new one , and will be the one I'll be updating.
Same thing , just source the single .sql file.

[DuDeMaN]

same exact error *sigh* :( is it possible some kind of file is missing somewhere, or corrupt or anything like that?

[tcsmyworld]

That error can only occur if you source in the db.sql before you source my .sql file , that items_ is the result of sourcing that file before mine.
NO other files are needed , JUST the .sql file from the D/L sourced into a clean EMPTY DB.
Then run it.

[DuDeMaN]

lol, i know it doesn't seem like it, but that's what i'm doing :(.. i've deleted, then created the database over and over, yet still the same error. :(

Here's what I'm doing:

open mysql.exe
>Drop database eq;
>database create eq;
>use eq;
>source newdb; (i renamed it, cause i got tired of typeing all that)

5000000 lines go by.. no errors.... I then go into my db.ini and change the DB there if i changed the name of it. I run it, and its the same error. I then go to try to open boot5zones.exe, i get some error saying this stuff:

http://www.geocities.com/dudeman_200/errorwindows2.JPG

(again copy and paste, cause geocities sucks)

anyway, I appriceate you trying to help!

[wguidry]

Dudeman,

I don't think you are reading his posts.

He is saying... DO NOT SOURCE A NEW DB BEFORE SOURCING his.

You are clearly doing that here: source newdb.

so you are actually just doing this:

create database eq;
use eq;
source db.sql (His db.sql)

Also, before doing that make sure you set your permissions for EQ to admin it.

And before all that. Uninstall MYSQL, I find that helps when I have a big problem with my DB's.

Hope you get it.

Cheers

Wait a sec for 5.0 all you need to do is type in

create database eq;
use eq;
source newdb.sql;

where do you get this NEWDB from?

and dont tell me that wincvs crud I dont get that program AT ALL. If someone could e-mail me or send me a website with an empty database for 5.0 they would be awsome!

[Memener]

Kyle9,
Come on, read the forums....
Join Mirc.
you make your self look very dump with 80+ post asking:

If someone could e-mail me or send me a website with an empty database for 5.0 they would be awsome!

Read around..
I will give you a hint look at tcsmywould's posts.