EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=617)
-   -   Door Updates for 5.5??? (https://www.eqemulator.org/forums/showthread.php?t=12830)

ripmage 04-04-2004 03:35 AM

Door Updates for 5.5???
 
where is this door update for 5.5???? when i run my server which was running fine to 5.5 i get door errors. the main page talked about door updates but i cant seem to find em. Thanx :)

samandhi 04-04-2004 04:37 AM

It is in the db.sql file located in the file EQEMu-0.5.5-Configuration.zip... unzip, then copy that file (db.sql) to your c:/mysql/bin folder then source it in as if you would source any DB.. Below is how to do this:


start>run> type cmd>> hit enter

*NOTE hit the enter key after each line you type in your dos command window

Code:

cd c:/mysql/bin
mysql -u root mysql
USE eq;      (assuming eq is what you named your db, if you followed the guides then you did)
source db.sql;
quit


ripmage 04-04-2004 06:00 AM

Im confused about something. How could you source mw055_alpha_02.sql and then db.sql, arent they just overwriting eachother? when i do so i get plenty of errors when sourcing.

Loosenut 04-04-2004 06:36 AM

!!! same prob

samandhi 04-04-2004 06:55 AM

If they are errors then you have a problem... But if it is just saying that you are trying to duplicate a table or data already there 0 rows changed, then ignore it.. not a problem..:)

And yes, you source it over the top of the other DB....

ripmage 04-04-2004 07:22 AM

ok cool, thx for the help :)

RexChaos 04-04-2004 07:27 AM

Column count doesn't match value count at row 1....

That appears to be a popular one with mine

Loosenut 04-04-2004 07:32 AM

yep yep, same..... will it ever end?

RexChaos 04-04-2004 07:33 AM

Anyone know of a reason why this db.sql isn't playing nice with mw055?

Loosenut 04-04-2004 07:39 AM

Rex, is that error going to stop?? because its still going and i had it up for a while now

smogo 04-04-2004 07:44 AM

Quote:

Well since we dont' update our CVS anymore...
from http://www.eqemulator.net/forums/vie...asc&highlight=
Got to find a source that keeps up to date ... :/

Check CVS, there's been an update 4 days ago as of this post 8)

RexChaos 04-04-2004 09:17 AM

What's the CVS have to do with the database not working? I downloaded the rar and didn't see anything in it except source. No .sql's or anything.

Derision 04-04-2004 09:21 AM

You could try sourcing MW's db, then this:

http://cvs.sourceforge.net/viewcvs.p...in&rev=1.1.1.1

Worked for me, but YMMV

smogo 04-04-2004 09:38 AM

Quote:

What's the CVS have to do with the database not working?
The CVS (real CVs, not the snapshots avaliable now) was keeping track of correct Db updates to work with source
http://cvs.sourceforge.net/viewcvs.p...EMu%20Release/
This has always been working perfectly so far.

CVS is Concurrent Versions System, something used by developpers to avoid such unpleasant situations like you are experiencing now.

What is distroed now is snapshots of the code, not CVS, no matter the name.

However this can be just easily solved when the source download site also provides database snapshots =)

Loosenut 04-04-2004 11:59 AM

Does sourcing the alpha 1 sql supose to take 3 hours? cause its its still going and i started about 3-4 hours ago.


All times are GMT -4. The time now is 08:40 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.