|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::Windows Servers Support forum for Windows EQEMu users. |
|
|
|
11-06-2004, 11:56 AM
|
Fire Beetle
|
|
Join Date: Oct 2004
Location: South Australia, Australia
Posts: 15
|
|
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]
|
|
|
|
11-06-2004, 12:06 PM
|
Sarnak
|
|
Join Date: Aug 2003
Location: NY
Posts: 78
|
|
try doing this goto comand prompt
type
hit enter
next
Code:
mysql -u root mysql
hit enter
next
hit enter
then put in
Code:
ALTER TABLE `player_corpses` ADD `rezzed` TINYINT UNSIGNED DEFAULT "0";
this should work
__________________
|
11-06-2004, 02:21 PM
|
Sarnak
|
|
Join Date: Mar 2003
Posts: 71
|
|
Quote:
next
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
__________________
Cans O`Whoop Ass
LOADING, PLEASE WAIT...
|
11-06-2004, 02:46 PM
|
Sarnak
|
|
Join Date: Aug 2003
Location: NY
Posts: 78
|
|
yes thank you knew i forgot something hehe
__________________
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 11:32 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|