EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Help - Problem with zones (https://www.eqemulator.org/forums/showthread.php?t=16831)

darkdonno 11-06-2004 11:56 AM

Help - Problem with zones
 
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
Quote:

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
Code:

CD C:\mysql\bin
hit enter

next

Code:

mysql -u root mysql
hit enter

next
Code:

Use eq;
hit enter

then put in
Code:

ALTER TABLE `player_corpses` ADD `rezzed` TINYINT UNSIGNED DEFAULT "0";
this should work

Cans 11-06-2004 02:21 PM

Quote:

next
Code:

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


All times are GMT -4. The time now is 11:14 AM.

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