Others can't enter?

Tangeleno · #1 05-05-2004, 09:23 PM

Alright so I followed the how-to HOWTO: Setup an EQEmu server as of 04/23/04 I got my server set up and people can create characters but when they goto play the character I get an error dealing with an opcode

From zone.exe

Code:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.7-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading Doors from database...
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'help' defaulting to access level 0!
[Status] command_init(): Warning: Command 'version' defaulting to access level 0
!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] 160 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
[Status] Weather should change in 13232 seconds
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 61; Time Offset = 0
Reading zhdr file './cfg/felwithea.cfg'
Using database for safe coords.
Zone safe coords are x = 94; y = -25; z= 3.75
Reading zhdr file './cfg/felwithea.cfg'
Using database for safe coords.
Zone safe coords are x = 94; y = -25; z= 3.75
Using default zone header data...
Converting old zone data...
Attempting to write ./cfg\felwithea.cfg
Write complete.
Reading zhdr file './cfg/felwithea.cfg'
Using database for safe coords.
Zone safe coords are x = 94; y = -25; z= 3.75
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for felwithea ...
[Status] Done loading doors for felwithea ...
Petition 1 pettime = 1075244406
Petition 4 pettime = 1077918843
Petition 18 pettime = 1077916536
Petition 20 pettime = 1077476008
Petition 44 pettime = 1077493301
Petition 54 pettime = 1075595761
Petition 94 pettime = 1077935724
Petition 174 pettime = 1077767613
[Status] Zone Bootup: felwithea (61)
Error in GetWaypoints query 'SELECT type,type2,wp1,wp2,wp3,wp4,wp5,wp6,wp7,wp8,w
p9,wp10,wp11,wp12,wp13,wp14,wp15,wp16,wp17,wp18,wp19,wp20,wp21,wp22,wp23,wp24,wp
25,wp26,wp27,wp28,wp29,wp30,wp31,wp32,wp33,wp34,wp35,wp36,wp37,wp38,wp39,wp40,wp
41,wp42,wp43,wp44,wp45,wp46,wp47,wp48,wp49,wp50 from grid where id = 1063 and zo
neid = 0' #1054: Unknown column 'zoneid' in 'where clause'
[Status] 298529 New client from ip:65.70.232.187 port:3697
Client linkdead: Akasha
Dropping client: Process=false, ip=65.70.232.187, port=3697
[Status] Zone Shutdown: felwithea (61)
Zone bootup by Cloud
[Status] Weather should change in 1778 seconds
Init: Loading zone lists, zone state or spawn list, player corpses
Zonepoints loaded into memory
, timezone data - Done. ZoneID = 61; Time Offset = 0
Reading zhdr file './cfg/felwithea.cfg'
Using database for safe coords.
Zone safe coords are x = 94; y = -25; z= 3.75
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for felwithea ...
[Status] Done loading doors for felwithea ...
Petition 1 pettime = 1075244406
Petition 4 pettime = 1077918843
Petition 18 pettime = 1077916536
Petition 20 pettime = 1077476008
Petition 44 pettime = 1077493301
Petition 54 pettime = 1075595761
Petition 94 pettime = 1077935724
Petition 174 pettime = 1077767613
[Status] Zone Bootup: felwithea (61)
Error in GetWaypoints query 'SELECT type,type2,wp1,wp2,wp3,wp4,wp5,wp6,wp7,wp8,w
p9,wp10,wp11,wp12,wp13,wp14,wp15,wp16,wp17,wp18,wp19,wp20,wp21,wp22,wp23,wp24,wp
25,wp26,wp27,wp28,wp29,wp30,wp31,wp32,wp33,wp34,wp35,wp36,wp37,wp38,wp39,wp40,wp
41,wp42,wp43,wp44,wp45,wp46,wp47,wp48,wp49,wp50 from grid where id = 1063 and zo
neid = 0' #1054: Unknown column 'zoneid' in 'where clause'
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [08:11 am]
[Status] 789896 New client from ip:192.168.1.1 port:2104
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
 opcode: 0x032a, size: 8
[Status] 859236 New client from ip:65.70.232.187 port:3915
Client linkdead: Akasha
Dropping client: Process=false, ip=65.70.232.187, port=3915
Account being GM Flagged:erb2k, Level: 150
Pet being created: Xesekn
[Status] 1640299 New client from ip:65.70.232.187 port:4562
Client linkdead: Akasha
Dropping client: Process=false, ip=65.70.232.187, port=4562
Client linkdead: Cloud
Dropping client: Process=false, ip=192.168.1.1, port=2104
[Status] Zone Shutdown: felwithea (61)

monalin crusader · #2 06-08-2004, 05:44 AM

Try this it looks like your mobs that are on a grid are messing it up. Your database needs to be changed with this.

ALTER TABLE `grid` ADD `zoneid` INT(11) DEFAULT "0" NOT NULL;