PDA

View Full Version : Anyone Know?


Echoes
11-06-2004, 02:08 PM
Ok got my server up :) can log into it to char select. my woodelf gfaydark can now log in but before said it couldn't and when i log in now it can. but can some one maybe list reasons why i would go ld when connecting to my server? (it also seems that at char select the first one i hit to ent er world, the zone isn't available but the second one is, and would making spawn points for all chars the same place like nexus maybe fix this? [Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=36965
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking linux compiles....
TCP listening on: 67.164.67.38.attbi.com:9000
World server listening on: 67.164.67.38.attbi.com:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
75428 New TCP connection: 127.0.0.1:2601
75428 New TCP connection: 127.0.0.1:2602
75428 New TCP connection: 127.0.0.1:2603
75428 New TCP connection: 127.0.0.1:2604
75428 New TCP connection: 127.0.0.1:2605
New zoneserver: #1 127.0.0.1:2605
New zoneserver: #2 127.0.0.1:2604
New zoneserver: #3 127.0.0.1:2603
New zoneserver: #4 127.0.0.1:2602
New zoneserver: #5 127.0.0.1:2601
Zoneserver SetConnectInfo: 127.0.0.1:2601: 67.164.67.38.attbi.com:8780
Zoneserver SetConnectInfo: 127.0.0.1:2602: 67.164.67.38.attbi.com:8782
Zoneserver SetConnectInfo: 127.0.0.1:2603: 67.164.67.38.attbi.com:8783
Zoneserver SetConnectInfo: 127.0.0.1:2604: 67.164.67.38.attbi.com:8784
Zoneserver SetConnectInfo: 127.0.0.1:2605: 67.164.67.38.attbi.com:8781
217423 New client from ip: 192.168.0.186 port: 2612
Logged in: FirstLogin LS#45180: (username)
Received unknown opcode: 0x02eb size:0 bytes
Read group ID for 'Saetrikeri': 0
0: 2C 30 2C 2E 53 61 65 74 - 72 69 6B 65 72 69 2C 30 | ,0,.Saetrikeri,0
16: 36 37 61 37 39 64 34 00 | 67a79d4.
Attempting autobootup of Qeynos (1) for Saetrikeri
Zoneserver SetZone: 67.164.67.38.attbi.com:8780 Qeynos (1)
Enter world: Saetrikeri: Qeynos (1)
Broadcasting a world time update
Zoneserver SetZone: 67.164.67.38.attbi.com:8780 Qeynos (1)
Received unknown opcode: 0x02eb size:0 bytes
zoneID is NULL in Client::Clearance!!
Zoneserver SetZone: 67.164.67.38.attbi.com:8780 (0)
Zoneserver SetZone: 67.164.67.38.attbi.com:8780 (0)
0: 2C 30 2C 2E 4B 65 6F 6C - 69 6E 2C 30 36 37 61 37 | ,0,.Keolin,067a7
16: 39 64 34 00 | 9d4.
Attempting autobootup of Gfaydark (54) for Keolin
Zoneserver SetZone: 67.164.67.38.attbi.com:8780 Gfaydark (54)
Enter world: Keolin: Gfaydark (54)
Broadcasting a world time update
Zoneserver SetZone: 67.164.67.38.attbi.com:8780 Gfaydark (54)
Received unknown opcode: 0x0376 size:0 bytes
Zoneserver SetZone: 67.164.67.38.attbi.com:8780 (0)
Zoneserver SetZone: 67.164.67.38.attbi.com:8780 (0)
Client disconnected
Removing client from ip:192.168.0.186 port:2612
and check out my zone.exe from boot5zone[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-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] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 5443
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[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 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] command_init(): Warning: Command 'hp' defaulting to access level 0!
[Status] command_init(): Warning: Command 'pf' defaulting to access level 0!
[Status] command_init(): Warning: Command 'bestz' defaulting to access level 0!
[Status] command_init(): Warning: Command 'ginfo' defaulting to access level 0!
[Status] 172 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Map ./Maps/qeynos.map not found.
[Status] Weather should change in 11226 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 1; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for qeynos ...
[Status] Done loading doors for qeynos ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Zone Bootup: Qeynos (1)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [05:29 am]
[Status] Zone Shutdown: qeynos (1)
Map header: 74949 faces, 4817 nodes, 124159 facelists
Loaded map: 224847 vertices, 74949 faces, 0 branch nodes, 0 final nodes
Map BB: (-2693.16 -> 2766.28, -2803.81 -> 2717.22, -98.53 -> 801.81)
Map ./Maps/gfaydark.map loaded.
[Status] Weather should change in 11898 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 54; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for gfaydark ...
[Status] Done loading doors for gfaydark ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Zone Bootup: Gfaydark (54)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [06:00 am]
[Status] 657776 New client from ip:192.168.0.186 port:2621
Read group ID for 'Keolin': 0
Client linkdead: Keolin
Dropping client: Process=false, ip=192.168.0.186, port=2621
[Status] Zone Shutdown: gfaydark (54)

einsteinrs
11-06-2004, 02:13 PM
i think you missed the door table update.
look in downloadsection on main page

Cans
11-06-2004, 02:17 PM
ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" NOT NULL;
ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NULL;

Run that, and it should fix it.

Echoes
11-06-2004, 02:34 PM
fixed that last 1 but says this now when i run the commands said before

mysql> source doors_update.sql;
Query OK, 5249 rows affected (0.37 sec)
Records: 5249 Duplicates: 0 Warnings: 0

Query OK, 5249 rows affected (0.41 sec)
Records: 5249 Duplicates: 0 Warnings: 0

Query OK, 5249 rows affected (0.36 sec)
Records: 5249 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE `doors` CHANGE `liftheight` `door_param` INT(4) DEFAULT "0" N
OT NULL;
ERROR 1054: Unknown column 'liftheight' in 'doors'
mysql> ALTER TABLE `doors` ADD `size` SMALLINT(5) UNSIGNED DEFAULT "100" NOT NUL
L;
ERROR 1060: Duplicate column name 'size'
mysql>

einsteinrs
11-06-2004, 02:41 PM
try to run your server now

Echoes
11-06-2004, 02:44 PM
same errors as before. :(

BobNewheart
11-06-2004, 11:29 PM
I am having the exact same problem here, tried what ya'll said and got the same result as the other guy...

Echoes
11-07-2004, 04:49 AM
Bob, my server now runs and all. ut im having problems connecting tozones like joshyoowuh. i make a character also, and ill go ld.

Echoes
11-07-2004, 05:35 AM
Ok, i tried again to zone into my server. i chose my woodelf bard in gfaydark. and it said zone not available. then i clicked on my froglok paladin in gukta, and the connect screen came up, the one with all the eq pictures on it, then i got booted to server select. this is what world.exe and 1 zone say...World.exeCURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
You may already be a winner... of the darwin award.
TCP listening on: 67.164.67.38.attbi.com:9000
World server listening on: 67.164.67.38.attbi.com:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
92974 New TCP connection: 127.0.0.1:1410
New zoneserver: #1 127.0.0.1:1410
Zoneserver SetConnectInfo: 127.0.0.1:1410: 67.164.67.38.attbi.com:8784
93024 New TCP connection: 127.0.0.1:1411
New zoneserver: #2 127.0.0.1:1411
Zoneserver SetConnectInfo: 127.0.0.1:1411: 67.164.67.38.attbi.com:8780
93114 New TCP connection: 127.0.0.1:1412
93114 New TCP connection: 127.0.0.1:1413
New zoneserver: #3 127.0.0.1:1413
New zoneserver: #4 127.0.0.1:1412
Zoneserver SetConnectInfo: 127.0.0.1:1412: 67.164.67.38.attbi.com:8781
Zoneserver SetConnectInfo: 127.0.0.1:1413: 67.164.67.38.attbi.com:8783
93154 New TCP connection: 127.0.0.1:1414
New zoneserver: #5 127.0.0.1:1414
Zoneserver SetConnectInfo: 127.0.0.1:1414: 67.164.67.38.attbi.com:8782
280223 New client from ip: 192.168.0.186 port: 1438
Logged in: FirstLogin LS#45180: (username)
Received unknown opcode: 0x02eb size:0 bytes
Read group ID for 'Keolin': 0
0: 2C 30 2C 2E 4B 65 6F 6C - 69 6E 2C 30 36 37 61 37 | ,0,.Keolin,067a7
16: 39 64 34 00 | 9d4.
Attempting autobootup of Gfaydark (54) for Keolin
Received unknown opcode: 0x02eb size:0 bytes
Zoneserver SetZone: 67.164.67.38.attbi.com:8782 Gfaydark (54)
Zoneserver SetZone: 67.164.67.38.attbi.com:8782 (0)
Zoneserver SetZone: 67.164.67.38.attbi.com:8782 (0)
0: 2C 30 2C 2E 5A 61 72 75 - 6C 69 73 2C 30 36 37 61 | ,0,.Zarulis,067a
16: 37 39 64 34 00 | 79d4.
Attempting autobootup of gukta (52) for Zarulis
Zoneserver SetZone: 67.164.67.38.attbi.com:8782 gukta (52)
Enter world: Zarulis: gukta (52)
Broadcasting a world time update
Zoneserver SetZone: 67.164.67.38.attbi.com:8782 gukta (52)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:192.168.0.186 port:1438
Zoneserver SetZone: 67.164.67.38.attbi.com:8782 (0)
Zoneserver SetZone: 67.164.67.38.attbi.com:8782 (0)
and 1 zone.exe [Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-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 guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] command_init(): Warning: Command 'hp' defaulting to access level 0!
[Status] command_init(): Warning: Command 'pf' defaulting to access level 0!
[Status] command_init(): Warning: Command 'bestz' defaulting to access level 0!
[Status] command_init(): Warning: Command 'ginfo' defaulting to access level 0!
[Status] 172 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 127.0.0.1:9000
Map header: 74949 faces, 4817 nodes, 124159 facelists
Loaded map: 224847 vertices, 74949 faces, 0 branch nodes, 0 final nodes
Map BB: (-2693.16 -> 2766.28, -2803.81 -> 2717.22, -98.53 -> 801.81)
Map ./Maps/gfaydark.map loaded.
[Status] Weather should change in 11940 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 54; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for gfaydark ...
[Status] Done loading doors for gfaydark ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
Error in LoadTempMerchantData query 'select ml.npcid,ml.slot,ml.itemid,ml.charge
s from merchantlist_temp ml, npc_types nt, spawnentry se, spawn2 s2 where nt.id=
ml.npcid and nt.id=se.npcid and se.spawngroupid=s2.spawngroupid and s2.zone='gfa
ydark' group by ml.npcid,slot order by npcid,slot asc' #1146: Table 'kunark.merc
hantlist_temp' doesn't exist
[Status] Zone Bootup: Gfaydark (54)
[Status] Zone Shutdown: gfaydark (54)
Map ./Maps/gukta.map not found.
[Status] Weather should change in 12398 seconds
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 52; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for gukta ...
[Status] Done loading doors for gukta ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
Error in LoadTempMerchantData query 'select ml.npcid,ml.slot,ml.itemid,ml.charge
s from merchantlist_temp ml, npc_types nt, spawnentry se, spawn2 s2 where nt.id=
ml.npcid and nt.id=se.npcid and se.spawngroupid=s2.spawngroupid and s2.zone='guk
ta' group by ml.npcid,slot order by npcid,slot asc' #1146: Table 'kunark.merchan
tlist_temp' doesn't exist
[Status] Zone Bootup: gukta (52)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [10:39 pm]
[Status] 509122 New client from ip:192.168.0.186 port:1444
Read group ID for 'Zarulis': 0
Client linkdead: Zarulis
Dropping client: Process=false, ip=192.168.0.186, port=1444
[Status] Zone Shutdown: gukta (52)

einsteinrs
11-07-2004, 05:52 AM
try this

CREATE TABLE merchantlist_temp (
npcid int(10) unsigned NOT NULL default '0',
slot tinyint(3) unsigned NOT NULL default '0',
itemid int(10) unsigned NOT NULL default '0',
charges int(10) unsigned NOT NULL default '1',
UNIQUE KEY merchantid (npcid,slot)
) TYPE=MyISAM;

Echoes
11-07-2004, 05:58 AM
i sourced something i think fixed it cuz it sed 'merchantlist_temp' already exists. but would that help me connect to my server? or would dling maps help? or maybe make everyone spawn in 1 zone? lke nexus

Echoes
11-07-2004, 06:50 AM
ok, d/Led the per compile dr.2. i set it up they get this error and all zoneperl.exe's shut down [Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-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 guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[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 'serversidename' defaulting to access
level 0!
[Status] command_init(): Warning: Command 'loc' defaulting to access level 0!
[Status] command_init(): Warning: Command 'flag' defaulting to access level 0!
[Status] command_init(): Warning: Command 'si' defaulting to access level 0!
[Status] command_init(): Warning: Command 'hp' defaulting to access level 0!
[Status] command_init(): Warning: Command 'pf' defaulting to access level 0!
[Status] command_init(): Warning: Command 'bestz' defaulting to access level 0!
[Status] command_init(): Warning: Command 'ginfo' defaulting to access level 0!
[Status] 174 commands loaded
[Status] Loading embedded perl XS
[Error] Starting command queue perl parser.

[Error] Reloading quests for zone...

[Error] Making parser...

[Status] Error initializing perlembed: failed to install eval_file hook
[Status] Fatal error initializing perl: failed to install eval_file hook