PDA

View Full Version : Help - Problem with zones


darkdonno
11-06-2004, 11:56 AM
here is the basics
I install mysql to c:\mysql
I installed perl to c:\perl
I using EQEMU 6 with Perl, The 5.8 PEQ Classic Database.
I am using mini login
I have the three freeport maps in C:\eqemu\Maps

The problem i am having is when I go to the characther selection and try entering it say That zone is unavible.

- I have 5 zones loaded up I wait until they start sleeping to log into the server.

This is what my zone window says

Connected to worldserver: 127.0.0.1:9000
Map header: 42521 faces, 650 nodes, 56765 facelists
Loaded map: 127563 vertices, 42521 faces, 0 branch nodes, 0 final nodes
Map BB: (-1693.31 -> 1399.44, -783.69 -> 1637.34, -113.97 -> 149.94)
Map ./Maps/freportw.map loaded.
[Status] Weather should change in 13952 seconds
Init: Loading zone lists, zone state or spawn list, player corpsesError in LoadP
layerCorpses query 'SELECT id, charid, charname, x, y, z, heading, data, timeofd
eath, rezzed FROM player_corpses WHERE zoneid='9'' #1054: Unknown column 'rezzed
' in 'field list'
Note that if your missing the 'rezzed' field you can add it with:
ALTER TABLE `player_corpses` ADD `rezzed` TINYINT UNSIGNED DEFAULT "0";
ERROR: Couldn't load player corpses.
Zone->Init failed
Map header: 42521 faces, 650 nodes, 56765 facelists
Loaded map: 127563 vertices, 42521 faces, 0 branch nodes, 0 final nodes
Map BB: (-1693.31 -> 1399.44, -783.69 -> 1637.34, -113.97 -> 149.94)
Map ./Maps/freportw.map loaded.
[Status] Weather should change in 14038 seconds
Init: Loading zone lists, zone state or spawn list, player corpsesError in LoadP
layerCorpses query 'SELECT id, charid, charname, x, y, z, heading, data, timeofd
eath, rezzed FROM player_corpses WHERE zoneid='9'' #1054: Unknown column 'rezzed
' in 'field list'
Note that if your missing the 'rezzed' field you can add it with:
ALTER TABLE `player_corpses` ADD `rezzed` TINYINT UNSIGNED DEFAULT "0";
ERROR: Couldn't load player corpses.
Zone->Init failed
Map header: 42521 faces, 650 nodes, 56765 facelists
Loaded map: 127563 vertices, 42521 faces, 0 branch nodes, 0 final nodes
Map BB: (-1693.31 -> 1399.44, -783.69 -> 1637.34, -113.97 -> 149.94)
Map ./Maps/freportw.map loaded.
[Status] Weather should change in 14090 seconds
Init: Loading zone lists, zone state or spawn list, player corpsesError in LoadP
layerCorpses query 'SELECT id, charid, charname, x, y, z, heading, data, timeofd
eath, rezzed FROM player_corpses WHERE zoneid='9'' #1054: Unknown column 'rezzed
' in 'field list'
Note that if your missing the 'rezzed' field you can add it with:
ALTER TABLE `player_corpses` ADD `rezzed` TINYINT UNSIGNED DEFAULT "0";
ERROR: Couldn't load player corpses.
Zone->Init failed



Everything else seems to be working.[/quote]

Laviathon
11-06-2004, 12:06 PM
try doing this goto comand prompt
type
CD C:\mysql\bin hit enter

next

mysql -u root mysql hit enter

next
Use eq; hit enter

then put in
ALTER TABLE `player_corpses` ADD `rezzed` TINYINT UNSIGNED DEFAULT "0";

this should work

Cans
11-06-2004, 02:21 PM
next
Use eq; hit enter

this should work

Only put in 'Use eq;' if your database name is called 'eq'. If your database is called something else, then replace it.

Just posting this in case you ran into that problem ;)

Laviathon
11-06-2004, 02:46 PM
yes thank you knew i forgot something hehe