Incomplete Databases and Invisible Toons

Project news and announcements can be found here, along with site/forum rules. Be sure to read this first!
Locked
User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Incomplete Databases and Invisible Toons

Post by John Adams » Sat Mar 20, 2010 8:52 pm

This fix is just for those new servers starting out who notice issues with getting a new database setup.

I've finally realized what's happening on those few reports we've been getting about logging into the world, and you cannot see your toon. There is a connectivity problem with our DB Update Service (long standing problem) that is more likely internet latency than anything to do with LE's servers... if you know what you're looking for, you can see a "Connection reset by peer" error message.

What this means is that while the bulk data is downloading to your clean DB, a connection is getting reset and you are not getting the entire table (in this case, Appearances). This also happens with visual_states, reference_spell_effects, and sadly, opcodes. These are currently our largest tables, so it takes a fairly robust and steady connection to download that much data.

The solution (for now) is to download the attached full DB sql file, source it in, then run your EQ2World.exe to update it passed Public SVN Rev 415. Crappy solution, but this will fix those of you who keep getting partial databases.
EQ2EmulatorDB_Rev415.zip
Note: This will drop ALL your tables, so don't apply it if you care about your world data...

A (better) long-term solution is in the works to deliver not only the core database, but our (hopefully) first release of EQ2Emulator data to the public. It'll likely be in the form of a massive SQL file to source in, because there is no way with these current problems we will be able to continue delivering data via our DB Update service. ~very sad face~

Unless LE returns with a miracle save, this is the direction we're going with our data delivery; SVN.

This fix is just for those new servers starting out who notice issues with getting a new database setup.

Edit: Made it more clear who this post is directed at ;) sorry
You do not have the required permissions to view the files attached to this post.

User avatar
ZexisStryfe
Posts: 1026
Joined: Thu Jul 26, 2007 6:39 am
EQ2Emu Server: Sytherian Legends
Location: Connecticut
Contact:

Re: Incomplete Databases and Invisible Toons

Post by ZexisStryfe » Sat Mar 20, 2010 9:11 pm

Hey John,

For those of us with custom data in their databases, are there any DB struct updates in this? Also, is it updating any data?

I needs to know!

-Zexis
~ EQ2 Emulator Project Manager

Image
Image
Image
"Zexis, from this day forth, you shall be known as... '3 of 6'" - John Adams

User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:

Re: Incomplete Databases and Invisible Toons

Post by John Adams » Sat Mar 20, 2010 9:51 pm

If you already have a fully functioning DB and are just getting the Rev 415 updates tomorrow, then no - you should be fine. It's merely a change to zones, adding the `xp_modifier` column, and the change we've been discussing about visual_states.

The normal updates should work for you.

This fix is just for those new servers starting out who notice issues with getting a new database setup.

Locked

Who is online

Users browsing this forum: No registered users and 0 guests