Quote:
|
Originally Posted by Snoopdog
While trying to fix my black screen zoning errors i went to the CVS and downloaded the latest release and now getting this error after logging in. On the client i get zone not available. On the server i get this.
Init: Loading zone lists, zone state or spawn list, player corpsesError in LoadPlayerCorpses query 'SELECT id, charid, charname, x, y, z, heading, data, timeofdeath, rezzed FROM player_corpses WHERE zoneid='54'' #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
Now i did finally download the player_corpses.sql from cvs then sourced it in to Mysql. After that the same error, then i did the
ALTER TABLE 'player_corpses' ADD 'rezzed' TINYINT UNSIGNED DEFAULT "0";
and I get this error ........
ERROR 1060: Duplicate column name 'rezzed'
If i into EQ Admin i should be able to see this coumn correct ?? Well i do not see a column called rezzed but Mysql says that it exist. I am no SQL guru and do not claim to be, i have went as far as i can without some pro assistance.
|
dude drop the table add it back in then do this.
I had the same problem.
ALTER TABLE 'player_corpses' ADD 'rezzed' TINYINT UNSIGNED DEFAULT "0";