|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Archive::General Support Archive area for General Support's posts that were moved here after an inactivity period of 90 days. |
09-28-2003, 06:42 PM
|
Sarnak
|
|
Join Date: Jul 2002
Posts: 75
|
|
5.0 server error :(
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
|
09-29-2003, 12:29 AM
|
Sarnak
|
|
Join Date: Jun 2003
Location: Newcastle, Australia
Posts: 73
|
|
That image link is broken
|
09-29-2003, 04:15 AM
|
|
This page is not available. when i click on that link.
|
09-29-2003, 06:32 AM
|
Fire Beetle
|
|
Join Date: Sep 2003
Posts: 9
|
|
Add a space after the link
its a trick with Geocities links .. just copy the link then add a single space at the end of the line.
Works fine
|
09-29-2003, 06:33 AM
|
Sarnak
|
|
Join Date: Jul 2002
Posts: 75
|
|
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
|
09-29-2003, 09:39 AM
|
|
Discordant
|
|
Join Date: Feb 2002
Posts: 452
|
|
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.
__________________
Founder PEQ (ProjectEQ)
|
09-29-2003, 03:40 PM
|
Sarnak
|
|
Join Date: Jul 2002
Posts: 75
|
|
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 :(
|
09-29-2003, 03:47 PM
|
|
Discordant
|
|
Join Date: Feb 2002
Posts: 452
|
|
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.
__________________
Founder PEQ (ProjectEQ)
|
09-29-2003, 03:58 PM
|
Sarnak
|
|
Join Date: Jul 2002
Posts: 75
|
|
same exact error *sigh* :( is it possible some kind of file is missing somewhere, or corrupt or anything like that?
|
09-29-2003, 05:12 PM
|
|
Discordant
|
|
Join Date: Feb 2002
Posts: 452
|
|
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.
__________________
Founder PEQ (ProjectEQ)
|
09-30-2003, 04:42 AM
|
Sarnak
|
|
Join Date: Jul 2002
Posts: 75
|
|
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!
|
09-30-2003, 06:02 AM
|
Sarnak
|
|
Join Date: Sep 2003
Posts: 30
|
|
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
|
09-30-2003, 02:58 PM
|
|
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!
|
09-30-2003, 03:06 PM
|
|
Dragon
|
|
Join Date: Jan 2003
Location: College park, GA (atlanta)
Posts: 640
|
|
Kyle9,
Come on, read the forums....
Join Mirc.
you make your self look very dump with 80+ post asking:
Quote:
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.
__________________
AMD AM2 X2 3.01Ghz(OC'ed at 3.8Ghz) 4096MB DDR2 800 Geforce 8800 ultra SLI 1.2TB HD <-- All water cooled
Thanks to Imageshack.us for free image hosting!
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 08:07 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|