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]

Originally Posted by 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.

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]

Originally Posted by 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?

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.