0.5.1 Released server

[cybermax]

I am having some serious DB problems.. at least i think so..

Decided to start from scratch with the 0.5.1 release, since TCS's db that works with 0.5.0 does not seem to keen on working (ie. zone.exe crashes even when i try to make a new character.. )

So.. What am i doing wrong?

I download the 0.5.1 binaries for Windows package.
Delete my old database, and remake a new one.
source db.sql that comes with the 0.5.1 binaries package.
Make account with world adduser myuser mypass 200 (also tried world adduser myuser mypass 0)

Start server, then World.exe complains about a missing "ldonpointtheme" in items..

Oki.. download the latest "dumpeditems.sql" (today) and source that in.

Server start without errors.. i make a character, and when i enter world, i get a zone.exe crash, and thats it.. Thats how far i can go. Why does not this work? I can understand that old databases with loads of stuff in it, has some conflicts, but i would believe that the database that COMES WITH the package at least would enable me to create a character??

And yes.. i also tried to download the "addon" pack.. EQEMu-0.5.1-Misc.zip and sourced the different db's in there as well, but that did not solve anything either.

So.. I had 0.5.0 Up and running with TCS's database.. But there are still many buggs, so i decided to try the CVS version.. Compiled with no trouble, and had the same zone.exe crash i am having now.. Latest i tried was 0.5.1-DR2, and it had the same problem. I posted this under "developement forum", and was told that TCS database was not compatible with 0.5.1 .. Fair nuff for me, thats why i scratched the db alltogether and decided to try with a totally clean DB.
But this does not seem to work either..

Pls.. Anyone got a small hint for me on what i am doing wrong? Why is zone.exe crashing the second i try to enter world? (And the "dos window" that is zone.exe poofs so fast its impossible for me to catch any glimpse of a possible error message i am afraid :()

[Mongrel]

Did you source in the "Server Update 0.5.1.sql" as well? (right after db.sql)

[cybermax]

Yes..

I got the 0.5.1-DR2 version to work with TCS db using his latest update file tho..

[Kroeg]

it seems he supported DR2 , instead of 0.5.1 official release.. which can be expected, since DR2 was seemingly "pushed" early.

I myself have attempted to get his latest db working with 0.5.1 official, but I am stuck back at the "Zone Unavailable" situation again.

Anyone else going to take a crack at this?

[Edgar1898]

Only a few fields were changed, I'll post the sql queries when I go home for lunch.

[Edgar1898]

for those of you with outdated dbs run the following sql queries:

alter table character_ add timelaston int(11) unsigned default '0';
alter table character_ add publicnote varchar(100) NOT NULL default '';


CREATE TABLE ground_spawns (
  id int(11) unsigned NOT NULL auto_increment,
  zoneid int(10) unsigned NOT NULL default '0',
  max_x float NOT NULL default '2000',
  max_y float NOT NULL default '2000',
  max_z float NOT NULL default '10000',
  min_x float NOT NULL default '-2000',
  min_y float NOT NULL default '-2000',
  heading float NOT NULL default '0',
  name varchar(16) NOT NULL default '',
  item int(10) unsigned NOT NULL default '0',
  max_allowed int(10) unsigned NOT NULL default '1',
  respawn_timer bigint(20) unsigned NOT NULL default '300000',
  comment varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'ground_spawns'
#

INSERT INTO ground_spawns VALUES("1", "54", "2400", "2400", "10000", "-2400", "-2400", "0", "IT403_ACTORDEF", "22119", "50", "Evergreen Leaves for Gfay");
INSERT INTO ground_spawns VALUES("2", "68", "3000", "3000", "10000", "-3000", "-3000", "0", "IT403_ACTORDEF", "16490", "50", "Oak Bark For Butcherblock");

That should fix any issues you have with an outdated db. As always with a new release you need to update your database with the new tables and definitions released with the emu. Look on sourceforge for the table definitions for each release.

[Armanthuz]

nm... i was being blind..