Zone crashing - pls-2-help

[moydock]

Getting this error when trying to login. Any ideas?
[06.04. - 18:27:47] Starting Log: logs/eqemu_error_zone_1780.log
[06.04. - 18:27:47] Error in GetZoneCFG query SELECT ztype,fog_red,fog_green,fog_blue,fog_minclip,fog_m axclip,fog_red2,fog_green2,fog_blue2,fog_minclip2, fog_maxclip2,fog_red3,fog_green3,fog_blue3,fog_min clip3,fog_maxclip3,fog_red4,fog_green4,fog_blue4,f og_minclip4,fog_maxclip4,sky,zone_exp_multiplier,s afe_x,safe_y,safe_z,underworld,minclip,maxclip,tim e_type,canbind,cancombat from zone where zoneidnumber=84: #1054: Unknown column 'cancombat' in 'field list'
[06.04. - 18:27:47] Error in GetZoneCFG query SELECT ztype,fog_red,fog_green,fog_blue,fog_minclip,fog_m axclip,fog_red2,fog_green2,fog_blue2,fog_minclip2, fog_maxclip2,fog_red3,fog_green3,fog_blue3,fog_min clip3,fog_maxclip3,fog_red4,fog_green4,fog_blue4,f og_minclip4,fog_maxclip4,sky,zone_exp_multiplier,s afe_x,safe_y,safe_z,underworld,minclip,maxclip,tim e_type,canbind,cancombat from zone where zoneidnumber=0: #1054: Unknown column 'cancombat' in 'field list'

[techguy84]

Looks like you may have a corrupted database. Try to resource it in. Is this a fresh server setup or something that has existed and worked fine before?

If it is a "used to be" working server, what have you changed? Any updates made to the database. Changes in component versions, ect...

Also, did you compile the emu from source if its a new server, if so did you have any errors. Try a binary file if this may apply to you.

It trully looks like option 1, as it seems there may be a botch table or possible some language error, syntax possibly.

[Darkonig]

It is not really corrupted database, it is simply an old version of the database. You have to bring the database current by applying required SQL changes from the change logs that occurred after the time your database was released until the version of the emulator you are using. There are several posts on the boards on how to determine which those are.

[moydock]

Looks like you may have a corrupted database. Try to resource it in. Is this a fresh server setup or something that has existed and worked fine before?

If it is a "used to be" working server, what have you changed? Any updates made to the database. Changes in component versions, ect...

Also, did you compile the emu from source if its a new server, if so did you have any errors. Try a binary file if this may apply to you.

It trully looks like option 1, as it seems there may be a botch table or possible some language error, syntax possibly.
Hey Tech, i talked to you a couple days back over e-mails. Your probably right about the corrupt database but I also would like to try sourcing zonecfg.sql since i missed that part when updating my DB. If I could just find it... lol. Where do they keep all the .sql files? Searching hasn't gotten me anywhere.

[Angelox]

I wouldn't say corrupt either - you have an older version of a database and you are running a recent eqemu.
Where did you get your database?

[moydock]

I wouldn't say corrupt either - you have an older version of a database and you are running a recent eqemu.
Where did you get your database?
I made it from scratch 8 months ago or so. You guys were right, just had to run the sql file. Got passed that error now i've got a new problem... Zone still crashes but i'm not seeing any problems in my logs lemme post them:

---------------------------------------------
[06.05. - 19:35:58] Starting Log: logs/eqemu_debug_world_0968.log
[06.05. - 19:35:58] [WORLD__INIT] Loading server configuration..
[06.05. - 19:35:58] [WORLD__INIT] Log settings loaded from log.ini
[06.05. - 19:35:58] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0
[06.05. - 19:35:58] [WORLD__INIT] Connecting to MySQL...
[06.05. - 19:35:58] [WORLD__INIT] HTTP world service disabled.
[06.05. - 19:35:58] [WORLD__INIT] Loading variables..
[06.05. - 19:35:58] [WORLD__INIT] Loading zones..
[06.05. - 19:35:58] [WORLD__INIT] Clearing groups..
[06.05. - 19:35:58] [WORLD__INIT] Clearing temporary merchant lists..
[06.05. - 19:35:58] [WORLD__INIT] Loading items..
[06.05. - 19:35:58] [WORLD__INIT] Loading guilds..
[06.05. - 19:35:59] [RULES__CHANGE] Loading rule set 'default' (2)
[06.05. - 19:35:59] [WORLD__INIT] Loaded default rule set 'default'
[06.05. - 19:35:59] [WORLD__INIT] Loading EQ time of day..
[06.05. - 19:35:59] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[06.05. - 19:35:59] [WORLD__INIT] Loading launcher list..
[06.05. - 19:35:59] [WORLD__INIT] Reboot zone modes OFF
[06.05. - 19:35:59] [WORLD__INIT] Deleted 0 stale player corpses from database
[06.05. - 19:35:59] [WORLD__INIT] Deleted 0 stale player backups from database
[06.05. - 19:35:59] [WORLD__INIT] Zone (TCP) listener started.
[06.05. - 19:35:59] [WORLD__INIT] Client (UDP) listener started.
[06.05. - 19:35:59] [NET__IDENTIFY] Registered patch 6.2
[06.05. - 19:35:59] [NET__IDENTIFY] Registered patch Titanium
[06.05. - 19:35:59] [NET__IDENTIFY] Registered patch Live
[06.05. - 19:35:59] [WORLD__LS] Connecting to login server...
[06.05. - 19:35:59] [WORLD__LS] Connected to Loginserver: eqemulator.net:5998
[06.05. - 19:35:59] [WORLD__LS] Loginserver provided 65.175.159.49 as world address
[06.05. - 19:36:00] [WORLD__ZONE] New TCP connection from 127.0.0.1:2023
[06.05. - 19:36:00] [WORLD__CONSOLE] New zoneserver #1 from 127.0.0.1:2023
[06.05. - 19:36:00] [WORLD__ZONE] [1] Zone started with name . by launcher NONE
[06.05. - 19:36:00] [WORLD__ZONE] [1] Auto zone port configuration. Telling zone to use port 7000
[06.05. - 19:36:01] [WORLD__ZONE] New TCP connection from 127.0.0.1:2025
[06.05. - 19:36:01] [WORLD__CONSOLE] New zoneserver #2 from 127.0.0.1:2025
[06.05. - 19:36:01] [WORLD__ZONE] [2] Zone started with name . by launcher NONE
[06.05. - 19:36:01] [WORLD__ZONE] [2] Auto zone port configuration. Telling zone to use port 7001
[06.05. - 19:36:26] [WORLD__CLIENT] New connection from 192.168.1.105:49333
[06.05. - 19:36:26] [NET__IDENT_TRACE] 192.168.1.105:49333: First opcode 0x4dd0 did not match expected 0x2792
[06.05. - 19:36:26] [NET__IDENT_TRACE] 192.168.1.105:49333: Tried patch 6.2_world, and it did not match.
[06.05. - 19:36:26] [NET__IDENT_TRACE] 192.168.1.105:49333: First opcode 0x4dd0 did not match expected 0x2ec9
[06.05. - 19:36:26] [NET__IDENT_TRACE] 192.168.1.105:49333: Tried patch 6.2_zone, and it did not match.
[06.05. - 19:36:26] [NET__IDENT_TRACE] 192.168.1.105:49333: First opcode matched 0x4dd0 and length matched 464
[06.05. - 19:36:26] [NET__IDENTIFY] Identified stream 192.168.1.105:49333 with signature Titanium_world
[06.05. - 19:36:26] [WORLD__CLIENT] New client from 192.168.1.105:49333
[06.05. - 19:36:26] [WORLD__CLIENT] gredesh: Logged in. Mode=(CharSel)
[06.05. - 19:36:26] [WORLD__CLIENT] gredesh: LS Account #70526
[06.05. - 19:37:35] [WORLD__CLIENT] New connection from 192.168.1.105:49335
[06.05. - 19:37:35] [NET__IDENT_TRACE] 192.168.1.105:49335: First opcode 0x4dd0 did not match expected 0x2792
[06.05. - 19:37:35] [NET__IDENT_TRACE] 192.168.1.105:49335: Tried patch 6.2_world, and it did not match.
[06.05. - 19:37:35] [NET__IDENT_TRACE] 192.168.1.105:49335: First opcode 0x4dd0 did not match expected 0x2ec9
[06.05. - 19:37:35] [NET__IDENT_TRACE] 192.168.1.105:49335: Tried patch 6.2_zone, and it did not match.
[06.05. - 19:37:35] [NET__IDENT_TRACE] 192.168.1.105:49335: First opcode matched 0x4dd0 and length matched 464
[06.05. - 19:37:35] [NET__IDENTIFY] Identified stream 192.168.1.105:49335 with signature Titanium_world
[06.05. - 19:37:35] [WORLD__CLIENT] New client from 192.168.1.105:49335
[06.05. - 19:37:35] [WORLD__CLIENT] gredesh: Logged in. Mode=(CharSel)
[06.05. - 19:37:35] [WORLD__CLIENT] gredesh: LS Account #70526
[06.05. - 19:38:19] [WORLD__CLIENT] gredesh: Attempting autobootup of firiona (84)
[06.05. - 19:38:20] [WORLD__ZONE] [2] Setting to 'firiona' (84)
[06.05. - 19:38:20] [WORLD__CLIENT] gredesh: Entering zone firiona (84)
[06.05. - 19:38:20] [WORLD__ZONE] [2] [firiona] Setting to 'firiona' (84)
[06.05. - 19:38:20] [WORLD__CLIENT] gredesh: Sending client to zone firiona (84) at 192.168.1.106:7001
[06.05. - 19:38:20] [WORLD__CLIENT] gredesh: Client disconnected (not active in process)
[06.05. - 19:38:47] [WORLD__ZONELIST] Removing zoneserver #2 at :7001

[moydock]

[06.05. - 19:36:00] Starting Log: logs/eqemu_debug_zone_3952.log
[06.05. - 19:36:00] [ZONE__INIT] Loading server configuration..
[06.05. - 19:36:00] [ZONE__INIT] Log settings loaded from log.ini
[06.05. - 19:36:00] [ZONE__INIT] Connecting to MySQL...
[06.05. - 19:36:00] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
[06.05. - 19:36:00] [ZONE__INIT] Log settings loaded from ./log.ini
[06.05. - 19:36:00] [ZONE__INIT] Mapping Incoming Opcodes
[06.05. - 19:36:00] [ZONE__INIT] Loading Variables
[06.05. - 19:36:00] [ZONE__INIT] Loading zone names
[06.05. - 19:36:00] [ZONE__INIT] Loading items
[06.05. - 19:36:00] [ZONE__INIT] Loading npc faction lists
[06.05. - 19:36:00] [ZONE__INIT] Loading loot tables
[06.05. - 19:36:00] [ZONE__INIT] Loading skill caps
[06.05. - 19:36:00] [ZONE__INIT] Loading guilds
[06.05. - 19:36:00] [ZONE__INIT] Loading factions
[06.05. - 19:36:00] [ZONE__INIT] Loading titles
[06.05. - 19:36:00] [ZONE__INIT] Loading AA effects
[06.05. - 19:36:00] [ZONE__INIT] Loading swarm spells
[06.05. - 19:36:00] [ZONE__INIT] Loading tributes
[06.05. - 19:36:00] [ZONE__INIT] Loading corpse timers
[06.05. - 19:36:00] [ZONE__INIT] Loading commands
[06.05. - 19:36:00] command_init(): - Command 'aggro' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'ai' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'appearance' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'attack' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'ban' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'bestz' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'cast' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'castspell' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'charbackup' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'chat' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'copychar' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'corpse' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'crashtest' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'damage' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'datarate' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'date' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'dbspawn2' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'delacct' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'delpetition' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'depop' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'depopzone' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'doanim' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'emote' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'equipitem' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'finditem' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'findnpctype' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'findspell' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'fixmob' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'flag' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'flagedit' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'flags' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'flymode' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'fov' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'freeze' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'gassign' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'gender' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'ginfo' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'gm' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'gmspeed' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'goto' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'guild' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'guilds' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'haste' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'heal' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'hideme' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'hp' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'interrupt' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'invul' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'invulnerable' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'iteminfo' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'itemsearch' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'kick' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'kill' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'lastname' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'level' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'listnpcs' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'listpetition' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'loc' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'lock' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'log' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'los' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'makepet' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'mana' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'manaburn' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'manastat' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'memspell' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'motd' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'movechar' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'name' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'npccast' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'npcedit' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'npcemote' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'npcloot' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'npcsay' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'npcshout' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'npcspecialattk' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'npcstats' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'npctypespawn' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'nukebuffs' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'nukeitem' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'peekinv' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'permaclass' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'permagender' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'permarace' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'petitioninfo' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'pf' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'pvp' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'qglobal' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'race' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'reloadpl' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'reloadqst' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'reloadquest' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'reloadstatic' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'reloadzonepoints' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'reloadzps' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'repop' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'save' set to access level 0.
[06.05. - 19:36:00] command_init(): - Command 'scribespells' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'search' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'sendzonespawns' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'serverinfo' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'serversidename' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'setaapts' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'setaaxp' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'setadventurepoints' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'setallskill' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'setitemstatus' set to access level 200.

[moydock]

[06.05. - 19:36:00] command_init(): - Command 'setlanguage' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'setpass' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'setskill' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'setskillall' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'setxp' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'showbuffs' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'showpetspell' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'showskills' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'showstats' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'shutdown' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'size' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'spawn' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'spawnfix' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'spawnstatus' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'spellinfo' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'spfind' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'spoff' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'spon' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'stun' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'summon' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'summonitem' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'synctod' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'texture' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'time' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'timezone' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'title' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'unfreeze' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'unlock' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'uptime' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'version' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'viewmessage' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'viewmessages' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'viewnpctype' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'viewpetition' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'weather' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'worldshutdown' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zclip' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zcolor' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zheader' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zone' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zonebootup' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zonelock' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zoneshutdown' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zonestatus' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zsafecoords' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zsave' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zsky' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zstats' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zunderworld' set to access level 200.
[06.05. - 19:36:00] command_init(): - Command 'zuwcoords' set to access level 200.
[06.05. - 19:36:00] [ZONE__INIT] 193 commands loaded
[06.05. - 19:36:00] [RULES__CHANGE] Loading rule set 'default' (2)
[06.05. - 19:36:00] [ZONE__INIT] Loaded default rule set 'default'
[06.05. - 19:36:00] [ZONE__INIT] Loading embedded perl XS
[06.05. - 19:36:00] [ZONE__INIT] Loading quests
[06.05. - 19:36:00] [ZONE__INIT] Entering sleep mode
[06.05. - 19:36:00] [NET__IDENTIFY] Registered patch 6.2
[06.05. - 19:36:00] [NET__IDENTIFY] Registered patch Titanium
[06.05. - 19:36:00] [NET__IDENTIFY] Registered patch Live
[06.05. - 19:36:00] [NET__WORLD] Connected to World: localhost:9000
[06.05. - 19:36:00] [ZONE__WORLD] World indicated port 7000 for this zone.
[06.05. - 19:36:00] [ZONE__INIT] Starting EQ Network server on port 7000

[moydock]

---------------------------------------------
[06.05. - 19:36:01] Starting Log: logs/eqemu_debug_zone_4048.log
[06.05. - 19:36:01] [ZONE__INIT] Loading server configuration..
[06.05. - 19:36:01] [ZONE__INIT] Log settings loaded from log.ini
[06.05. - 19:36:01] [ZONE__INIT] Connecting to MySQL...
[06.05. - 19:36:01] [ZONE__INIT] CURRENT_ZONE_VERSION: EQEMu 0.7.0
[06.05. - 19:36:01] [ZONE__INIT] Log settings loaded from ./log.ini
[06.05. - 19:36:01] [ZONE__INIT] Mapping Incoming Opcodes
[06.05. - 19:36:01] [ZONE__INIT] Loading Variables
[06.05. - 19:36:01] [ZONE__INIT] Loading zone names
[06.05. - 19:36:01] [ZONE__INIT] Loading items
[06.05. - 19:36:01] [ZONE__INIT] Loading npc faction lists
[06.05. - 19:36:01] [ZONE__INIT] Loading loot tables
[06.05. - 19:36:01] [ZONE__INIT] Loading skill caps
[06.05. - 19:36:01] [ZONE__INIT] Loading guilds
[06.05. - 19:36:01] [ZONE__INIT] Loading factions
[06.05. - 19:36:01] [ZONE__INIT] Loading titles
[06.05. - 19:36:01] [ZONE__INIT] Loading AA effects
[06.05. - 19:36:01] [ZONE__INIT] Loading swarm spells
[06.05. - 19:36:01] [ZONE__INIT] Loading tributes
[06.05. - 19:36:01] [ZONE__INIT] Loading corpse timers
[06.05. - 19:36:01] [ZONE__INIT] Loading commands
[06.05. - 19:36:01] command_init(): - Command 'aggro' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'ai' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'appearance' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'attack' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'ban' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'bestz' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'cast' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'castspell' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'charbackup' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'chat' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'copychar' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'corpse' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'crashtest' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'damage' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'datarate' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'date' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'dbspawn2' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'delacct' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'delpetition' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'depop' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'depopzone' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'doanim' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'emote' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'equipitem' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'finditem' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'findnpctype' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'findspell' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'fixmob' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'flag' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'flagedit' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'flags' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'flymode' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'fov' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'freeze' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'gassign' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'gender' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'ginfo' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'gm' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'gmspeed' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'goto' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'guild' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'guilds' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'haste' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'heal' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'hideme' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'hp' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'interrupt' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'invul' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'invulnerable' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'iteminfo' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'itemsearch' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'kick' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'kill' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'lastname' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'level' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'listnpcs' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'listpetition' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'loc' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'lock' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'log' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'los' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'makepet' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'mana' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'manaburn' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'manastat' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'memspell' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'motd' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'movechar' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'name' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'npccast' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'npcedit' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'npcemote' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'npcloot' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'npcsay' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'npcshout' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'npcspecialattk' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'npcstats' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'npctypespawn' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'nukebuffs' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'nukeitem' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'peekinv' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'permaclass' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'permagender' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'permarace' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'petitioninfo' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'pf' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'pvp' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'qglobal' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'race' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'reloadpl' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'reloadqst' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'reloadquest' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'reloadstatic' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'reloadzonepoints' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'reloadzps' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'repop' set to access level 200.

[moydock]

[06.05. - 19:36:01] command_init(): - Command 'save' set to access level 0.
[06.05. - 19:36:01] command_init(): - Command 'scribespells' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'search' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'sendzonespawns' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'serverinfo' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'serversidename' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setaapts' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setaaxp' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setadventurepoints' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setallskill' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setitemstatus' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setlanguage' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setpass' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setskill' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setskillall' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'setxp' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'showbuffs' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'showpetspell' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'showskills' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'showstats' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'shutdown' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'size' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'spawn' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'spawnfix' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'spawnstatus' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'spellinfo' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'spfind' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'spoff' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'spon' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'stun' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'summon' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'summonitem' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'synctod' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'texture' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'time' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'timezone' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'title' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'unfreeze' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'unlock' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'uptime' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'version' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'viewmessage' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'viewmessages' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'viewnpctype' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'viewpetition' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'weather' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'worldshutdown' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zclip' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zcolor' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zheader' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zone' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zonebootup' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zonelock' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zoneshutdown' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zonestatus' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zsafecoords' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zsave' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zsky' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zstats' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zunderworld' set to access level 200.
[06.05. - 19:36:01] command_init(): - Command 'zuwcoords' set to access level 200.
[06.05. - 19:36:01] [ZONE__INIT] 193 commands loaded
[06.05. - 19:36:01] [RULES__CHANGE] Loading rule set 'default' (2)
[06.05. - 19:36:01] [ZONE__INIT] Loaded default rule set 'default'
[06.05. - 19:36:01] [ZONE__INIT] Loading embedded perl XS
[06.05. - 19:36:01] [ZONE__INIT] Loading quests
[06.05. - 19:36:01] [ZONE__INIT] Entering sleep mode
[06.05. - 19:36:01] [NET__IDENTIFY] Registered patch 6.2
[06.05. - 19:36:01] [NET__IDENTIFY] Registered patch Titanium
[06.05. - 19:36:01] [NET__IDENTIFY] Registered patch Live
[06.05. - 19:36:01] [NET__WORLD] Connected to World: localhost:9000
[06.05. - 19:36:01] [ZONE__WORLD] World indicated port 7001 for this zone.
[06.05. - 19:36:01] [ZONE__INIT] Starting EQ Network server on port 7001
[06.05. - 19:38:19] The next weather check for zone: firiona will be in 13214 seconds.
[06.05. - 19:38:20] Zone: firiona has weather of type 1.
[06.05. - 19:38:20] Zone: firiona(84) has weather type = 1. The weather timer has been enabled.
[06.05. - 19:38:20] [WORLD__CLIENT] New connection from 192.168.1.105:49338
[06.05. - 19:38:21] [NET__IDENT_TRACE] 192.168.1.105:49338: First opcode 0x7752 did not match expected 0x2792
[06.05. - 19:38:21] [NET__IDENT_TRACE] 192.168.1.105:49338: Tried patch 6.2_world, and it did not match.
[06.05. - 19:38:21] [NET__IDENT_TRACE] 192.168.1.105:49338: First opcode 0x7213 did not match expected 0x2ec9
[06.05. - 19:38:21] [NET__IDENT_TRACE] 192.168.1.105:49338: Tried patch 6.2_zone, and it did not match.
[06.05. - 19:38:21] [NET__IDENT_TRACE] 192.168.1.105:49338: First opcode 0x7752 did not match expected 0x4dd0
[06.05. - 19:38:21] [NET__IDENT_TRACE] 192.168.1.105:49338: Tried patch Titanium_world, and it did not match.
[06.05. - 19:38:21] [NET__IDENT_TRACE] 192.168.1.105:49338: First opcode matched 0x7213 and length matched 68
[06.05. - 19:38:21] [NET__IDENTIFY] Identified stream 192.168.1.105:49338 with signature Titanium_zone
[06.05. - 19:38:21] [WORLD__CLIENT] New client from 192.168.1.105:49338

---------------------------------------------
[06.05. - 19:36:00] Starting Log: logs/eqemu_quest_zone_3952.log
[06.05. - 19:36:00] Tying perl output to eqemu logs
[06.05. - 19:36:00] Creating EQEmuIO=HASH(0x1034bf8)
[06.05. - 19:36:00] Creating EQEmuIO=HASH(0x1034f40)
[06.05. - 19:36:00] Loading perlemb plugins.
[06.05. - 19:36:00] Loading perl commands...
[06.05. - 19:38:51] Terminating on signal SIGHUP(1)

---------------------------------------------
[06.05. - 19:36:01] Starting Log: logs/eqemu_quest_zone_4048.log
[06.05. - 19:36:01] Tying perl output to eqemu logs
[06.05. - 19:36:01] Creating EQEmuIO=HASH(0xe34bf8)
[06.05. - 19:36:01] Creating EQEmuIO=HASH(0xe34f40)
[06.05. - 19:36:01] Loading perlemb plugins.
[06.05. - 19:36:01] Loading perl commands...

---------------------------------------------
[06.05. - 19:35:58] Starting Log: logs/eqemu_world_0968.log
[06.05. - 19:35:58] Using database 'eq' at localhost:3306
[06.05. - 19:35:58] EMuShareMem loaded
[06.05. - 19:35:58] Loading items from database: count=317

---------------------------------------------
[06.05. - 19:36:00] Starting Log: logs/eqemu_zone_3952.log
[06.05. - 19:36:00] Using database 'eq' at localhost:3306
[06.05. - 19:36:00] EMuShareMem loaded
[06.05. - 19:36:00] Loading NPC Faction Lists from database...
[06.05. - 19:36:00] Loading Loot tables from database...
[06.05. - 19:36:00] Loading skill caps from database...

---------------------------------------------
[06.05. - 19:36:01] Starting Log: logs/eqemu_zone_4048.log
[06.05. - 19:36:01] Using database 'eq' at localhost:3306
[06.05. - 19:36:01] EMuShareMem loaded
[06.05. - 19:38:19] Booting firiona
[06.05. - 19:38:19] Loading spawn conditions...
[06.05. - 19:38:19] Loading static zone points...
[06.05. - 19:38:19] Loading spawn groups...
[06.05. - 19:38:20] Loading spawn2 points...
[06.05. - 19:38:20] Loading player corpses...
[06.05. - 19:38:20] Loading traps...
[06.05. - 19:38:20] Loading ground spawns...
[06.05. - 19:38:20] Loading Ground Spawns from DB...
[06.05. - 19:38:20] Loading World Objects from DB...
[06.05. - 19:38:20] Loading Objects from DB...
[06.05. - 19:38:20] Loading doors for firiona ...
[06.05. - 19:38:20] Loading Doors from database...
[06.05. - 19:38:20] Loading AA information...
[06.05. - 19:38:20] Loading Merchant Lists...
[06.05. - 19:38:20] Loading Temporary Merchant Lists...
[06.05. - 19:38:20] Successfully loaded Zone Config.
[06.05. - 19:38:20] Loading timezone data...
[06.05. - 19:38:20] Init Finished: ZoneID = 84, Time Offset = 0
---------------------------------------------
[06.05. - 19:38:20] Starting Log: logs/eqemu_zone_4048.log
[06.05. - 19:38:20] ---- Zone server firiona, listening on port:7001 ----
[06.05. - 19:38:20] Zone Bootup: firiona (84)

[Angelox]

You still haven't said what database you are using, where you got it from?

[moydock]

I said it was custom, I think it was originally peq though, but i deleted most everything.

[Angelox]

I don't see any errors on what you posted, what happens when your zone crashes? is it when you try to log in?
There's many reasons for this to happen, you could just have a bad sql line sourced in. Did you go to GeorgeS's site (http://66.159.225.58/eqemu/eq.html) , download his "EQEMU SQL For Compatibility to .985" and run it against your database?

[moydock]

I did not. I will try that.

Zone crashes as i'm logging in, char gets in but then d/c's b/c the zone has crashed.

Thanks for the help i'll let ya know.

[moydock]

sourced it, no change. :(

[Angelox]

There's another thing I just remembered; if you're using a Linux server or compiling from source, don't forget to updated the *.conf files from the source/utils. These have been recently changed. On windows server, you usually you just download it all and over-write.

[moydock]

There's another thing I just remembered; if you're using a Linux server or compiling from source, don't forget to updated the *.conf files from the source/utils. These have been recently changed. On windows server, you usually you just download it all and over-write.
Yeah i'm on windows.

[Angelox]

can't think of anything else atm. If you want to compress/post it somewhere, you can PM me the download link and I'll download/look at it, see if I can spot any thing.

[moydock]

I only downloaded the win32 thing, not the source one. Do i need to do something with that?

[Angelox]

No, the executables look to be working ok, your problem is in the database

[moydock]

could it be i don't have any quests in my quest folder?

[Darkonig]

With the error messages reported, the problem is your database does not match what the emulator code is looking for. It is that simple. Since you made your database from scratch as you say, in order to insure that it has the correct tables and that they have the correct format, try getting a working database and verify that it works with your emulator. Then make appropriate table changes to your custom database.

I believe Angelox has a database available that will work. Give that a try.

[moydock]

Sorry guys i'm a tard... I forgot to put the new spells_en/us in. Works now :P Thanks for the help guys.

[techguy84]

EDIT: NEVERMIND - MISSED THE LAST POST DOH!!

As far as it being corrupted, I wasnt for sure. I didnt see any older databases that were missing some stuff. When I come in the PEQ CVS and Angelox's was what I used and they had all the goodies I needed to make it work out of the hole. Call me spoiled hehe