Door Updates for 5.5???

[ripmage]

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]

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

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]

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]

!!! same prob

[samandhi]

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]

ok cool, thx for the help :)

[RexChaos]

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

That appears to be a popular one with mine

[Loosenut]

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

[RexChaos]

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

[Loosenut]

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

[smogo]

Well since we dont' update our CVS anymore...
from http://www.eqemulator.net/forums/viewtopic.php?t=13882&start=0&postdays=0&postorder=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]

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]

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

http://cvs.sourceforge.net/viewcvs.py/*checkout*/eqemu/eqemu/eqemu/EQEMu%20Release/doorupdate-03-15-04.sql?content-type=text%2Fplain&rev=1.1.1.1

Worked for me, but YMMV

[smogo]

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.py/eqemu/eqemu/eqemu/EQEMu%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]

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

[RangerDown]

If it's taking that long and it's giving errors about duplicate key entries and the like, it might be that it pauses to beep on each error.

If you don't want it to beep on each error, add a -b argument to mysql, ie

cd\mysql\bin
mysql -u username -b -p databasename

then the errors will just fly by but not beep.