Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-15-2019, 05:22 PM
gcobb
Fire Beetle
 
Join Date: Jun 2008
Location: NC
Posts: 3
Default "Zone unavailable" after compiling

Hello all, wondering if anyone can help. I just compiled 32-bit binaries for the first time (I had previously used the Windows installer). After compiling, I pasted the binaries into my server directory and started the server using the default t_start_server.bat. Everything seems to launch normally. I can login and connect to server, but when I hit "Enter World" at character select, I get a popup saying "That zone is unavailable" and can't enter world.

It sounds like there must be an issue with my compiled zone.exe, but I'm not sure what it is (the world server window itself indicates 30/30 zones UP, and none of the dialogue boxes contain errors). After looking in the zone.exe logs, I realized there were a few SQL errors I hadn't seen before, apparently having to do with loading faction and spawngroup data. The contents of world and zone logs are below. Anyone seen this before? Note: I can log into server just fine if I revert to the original binaries.

World.exe
Code:
[09-15-2019 :: 16:50:40] [World Server] Checking Database Conversions..
[09-15-2019 :: 16:50:41] [World Server] Loading variables..
[09-15-2019 :: 16:50:41] [World Server] Purging expired data buckets...
[09-15-2019 :: 16:50:41] [World Server] Loading zones..
[09-15-2019 :: 16:50:41] [World Server] Clearing groups..
[09-15-2019 :: 16:50:41] [World Server] Clearing raids..
[09-15-2019 :: 16:50:41] [World Server] Clearing inventory snapshots..
[09-15-2019 :: 16:50:41] [World Server] Loading items..
[09-15-2019 :: 16:50:41] [World Server] Loading skill caps..
[09-15-2019 :: 16:50:41] [World Server] Loading guilds..
[09-15-2019 :: 16:50:41] [World Server] Loaded default rule set 'default'
[09-15-2019 :: 16:50:41] [World Server] Loading EQ time of day..
[09-15-2019 :: 16:50:41] [World Server] Loading launcher list..
[09-15-2019 :: 16:50:41] [World Server] Reboot zone modes OFF
[09-15-2019 :: 16:50:41] [World Server] Deleted 0 stale player corpses from database
[09-15-2019 :: 16:50:41] [World Server] Loading adventures...
[09-15-2019 :: 16:50:41] [World Server] Purging expired instances
[09-15-2019 :: 16:50:41] [World Server] Loading char create info...
[09-15-2019 :: 16:50:41] [World Server] Console (TCP) listener started.
[09-15-2019 :: 16:50:41] [World Server] Server (TCP) listener started.
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 46ab6167-404c-4f8a-a031-7d3e905d41cc at 127.0.0.1:54398
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from afdaa1c0-3e44-4c97-9ab7-37574d7f25ae at 127.0.0.1:54399
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from b91641a6-14c8-4288-a8b5-8423c377258a at 127.0.0.1:54401
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 48cad0d6-961c-4545-adb1-488749d87ec5 at 127.0.0.1:54402
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from e23fa868-7a9a-4dda-95a4-1b79c2407caa at 127.0.0.1:54403
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from c6b5ca3b-a077-4ac7-ad12-9d5a5f8e71f7 at 127.0.0.1:54405
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 21fafb22-bfbf-432a-b592-e03debe0f0f2 at 127.0.0.1:54406
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 9f44c33d-9c7e-4d43-a9cb-4b945c215cfa at 127.0.0.1:54408
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 4afa2c2d-5bad-42cd-8838-2094761ccf4f at 127.0.0.1:54410
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 6228d0be-8959-40a3-914b-e7745e46c76e at 127.0.0.1:54412
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from e096e6ec-60d0-43a2-b02e-6b785c7e31a7 at 127.0.0.1:54414
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from d0bcc187-207f-49d2-be20-2d77c34082b0 at 127.0.0.1:54416
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from db9aba1e-dce9-49fa-a536-ea105d9e6d26 at 127.0.0.1:54417
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from de724e92-dfa0-4857-ab56-3be6c169c02a at 127.0.0.1:54415
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 273742cb-40e7-4462-9820-2aa517f0e44b at 127.0.0.1:54419
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from b3d68cc6-7590-427d-81b0-4c5b76b21835 at 127.0.0.1:54421
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from af7eac3d-1ba5-40b6-8b26-ad6e23bedc4e at 127.0.0.1:54426
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from bb7b41ae-3cc4-4443-8481-1b6a8ed28fd1 at 127.0.0.1:54427
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 248b55aa-37d7-47ea-a43a-8b501bef71d5 at 127.0.0.1:54431
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 44ca46b0-e37f-458d-a3b6-c79fc241506e at 127.0.0.1:54432
[09-15-2019 :: 16:50:43] [World Server] New Zone Server connection from 28fa8a2b-c849-4f51-9792-dd9d88491ca2 at 127.0.0.1:54433
[09-15-2019 :: 16:50:44] [World Server] New Query Server connection from a5e7ca11-33b2-4d5c-b9e8-8d5ccf9669f9 at 127.0.0.1:54434
[09-15-2019 :: 16:50:44] [World Server] New Zone Server connection from ae57ac38-11e9-457b-9b15-2038318c8816 at 127.0.0.1:54435
[09-15-2019 :: 16:50:44] [World Server] New Zone Server connection from b49718f2-afd8-4232-a9d0-52b5dc8f2595 at 127.0.0.1:54436
[09-15-2019 :: 16:50:44] [World Server] New UCS Server connection from 1539efee-473f-4dc3-a467-39a3c0f82c21 at 127.0.0.1:54437
[09-15-2019 :: 16:50:44] [World Server] New Zone Server connection from 6022d0b0-c850-4698-bd8b-e990207be4e3 at 127.0.0.1:54438
[09-15-2019 :: 16:50:44] [World Server] New Zone Server connection from 80516543-7c87-4494-b55a-c31a86ba884f at 127.0.0.1:54439
[09-15-2019 :: 16:50:44] [World Server] New Zone Server connection from b6d1259d-12f7-4bed-a940-7d537c73d180 at 127.0.0.1:54441
[09-15-2019 :: 16:50:44] [World Server] New Zone Server connection from e07394a2-2aad-4d8b-bf2d-c0c5d5857318 at 127.0.0.1:54440
[09-15-2019 :: 16:50:44] [World Server] New Zone Server connection from 15e5d065-a96a-4e16-8798-eb773b183b1b at 127.0.0.1:54442
[09-15-2019 :: 16:50:44] [World Server] New Zone Server connection from 7be659f9-1db0-4538-8e75-7dc0bda71480 at 127.0.0.1:54443
[09-15-2019 :: 16:50:44] [World Server] New Zone Server connection from 31984bad-976f-4a38-ab5c-13301b6af950 at 127.0.0.1:54444
[09-15-2019 :: 16:52:57] [World Server] Account (gcobb) Logging(In) to character select :: LSID: 134790 
[09-15-2019 :: 16:53:09] [World Server] Attempting autobootup of cazicthule (48:0)
[09-15-2019 :: 16:53:17] [World Server] Attempting autobootup of cazicthule (48:0)
[09-15-2019 :: 16:53:21] [World Server] Attempting autobootup of cazicthule (48:0)
[09-15-2019 :: 16:54:06] [World Server] Attempting autobootup of cazicthule (48:0)
[09-15-2019 :: 16:59:18] [World Server] Removed Query Server connection from a5e7ca11-33b2-4d5c-b9e8-8d5ccf9669f9
[09-15-2019 :: 16:59:18] [World Server] Removed Query Server connection from 1539efee-473f-4dc3-a467-39a3c0f82c21
[09-15-2019 :: 16:59:18] [World Server] Removed Zone Server connection from e23fa868-7a9a-4dda-95a4-1b79c2407caa
[09-15-2019 :: 16:59:18] [World Server] Removed Zone Server connection from e096e6ec-60d0-43a2-b02e-6b785c7e31a7
[09-15-2019 :: 16:59:18] [World Server] Removed Zone Server connection from 21fafb22-bfbf-432a-b592-e03debe0f0f2
[09-15-2019 :: 16:59:18] [World Server] Removed Zone Server connection from de724e92-dfa0-4857-ab56-3be6c169c02a
[09-15-2019 :: 16:59:18] [World Server] Removed Zone Server connection from 48cad0d6-961c-4545-adb1-488749d87ec5
[09-15-2019 :: 16:59:18] [World Server] Removed Zone Server connection from b91641a6-14c8-4288-a8b5-8423c377258a
[09-15-2019 :: 16:59:18] [World Server] Removed Zone Server connection from c6b5ca3b-a077-4ac7-ad12-9d5a5f8e71f7
[09-15-2019 :: 16:59:18] [World Server] Removed Zone Server connection from 46ab6167-404c-4f8a-a031-7d3e905d41cc
[09-15-2019 :: 16:59:18] [World Server] Removed Zone Server connection from afdaa1c0-3e44-4c97-9ab7-37574d7f25ae
[09-15-2019 :: 16:59:19] [World Server] Removed Zone Server connection from 6022d0b0-c850-4698-bd8b-e990207be4e3
[09-15-2019 :: 16:59:19] [World Server] Removed Zone Server connection from b49718f2-afd8-4232-a9d0-52b5dc8f2595
[09-15-2019 :: 16:59:19] [World Server] Removed Zone Server connection from 80516543-7c87-4494-b55a-c31a86ba884f
[09-15-2019 :: 16:59:19] [World Server] Removed Zone Server connection from ae57ac38-11e9-457b-9b15-2038318c8816

Zone
Code:
[09-15-2019 :: 16:50:42] [MySQL Error] 1146: Table 'peq.npc_scale_global_base' doesn't exist 
 SELECT type,level,ac,hp,accuracy,slow_mitigation,attack,strength,stamina,dexterity,agility,intelligence,wisdom,charisma,magic_resist,cold_resist,fire_resist,poison_resist,disease_resist,corruption_resist,physical_resist,min_dmg,max_dmg,hp_regen_rate,attack_delay,spell_scale,heal_scale,special_abilities FROM `npc_scale_global_base`
[09-15-2019 :: 16:50:42] [NPC Scaling] Global Base Scaling Data Loaded...
[09-15-2019 :: 16:50:42] [Zone Server] CURRENT_VERSION: 1.1.3
[09-15-2019 :: 16:50:42] [Zone Server] Mapping Incoming Opcodes
[09-15-2019 :: 16:50:42] [Zone Server] Loading Variables
[09-15-2019 :: 16:50:42] [Zone Server] Loading zone names
[09-15-2019 :: 16:50:42] [Zone Server] Loading items
[09-15-2019 :: 16:50:42] [Zone Server] Loading npc faction lists
[09-15-2019 :: 16:50:42] [Zone Server] Loading loot tables
[09-15-2019 :: 16:50:42] [Zone Server] Loading skill caps
[09-15-2019 :: 16:50:42] [Zone Server] Loading spells
[09-15-2019 :: 16:50:42] [Zone Server] Loading base data
[09-15-2019 :: 16:50:42] [Zone Server] Loading guilds
[09-15-2019 :: 16:50:42] [Zone Server] Loading factions
[09-15-2019 :: 16:50:42] [Status] 505 Factions loaded...
[09-15-2019 :: 16:50:42] [MySQL Error] 1146: Table 'peq.faction_base_data' doesn't exist 
 SELECT `client_faction_id`, `min`, `max` FROM `faction_base_data` WHERE `client_faction_id` IN ('1','2','3','4','5','6','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','437','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','480','481','482','483','484','485','486','487','488','489','490','491','492','493','494','496','497','498','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515')
[09-15-2019 :: 16:50:42] [Status] Unable to load Faction Base data...
[09-15-2019 :: 16:50:42] [Status] 2496 Faction Modifiers loaded...
[09-15-2019 :: 16:50:42] [Zone Server] Loading titles
[09-15-2019 :: 16:50:42] [Zone Server] Loading tributes
[09-15-2019 :: 16:50:42] [Zone Server] Loading corpse timers
[09-15-2019 :: 16:50:42] [Zone Server] Loading profanity list
[09-15-2019 :: 16:50:42] [MySQL Error] 1146: Table 'peq.profanity_list' doesn't exist 
 SELECT `word` FROM `profanity_list`
[09-15-2019 :: 16:50:42] [Error] Loading profanity list FAILED!
[09-15-2019 :: 16:50:42] [Zone Server] Loading commands
[09-15-2019 :: 16:50:42] [Zone Server] 276 commands loaded
[09-15-2019 :: 16:50:42] [Zone Server] Loaded default rule set 'default'
[09-15-2019 :: 16:50:42] [Zone Server] Initialized dynamic dictionary entries
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (273, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (274, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (275, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (276, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (277, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (278, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (279, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (280, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (281, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (282, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (283, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (284, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (285, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (286, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (287, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (288, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Error] [TASKS]Activity for non-existent task (289, 0) while loading activities from database
[09-15-2019 :: 16:50:42] [Zone Server] Loading Perl Event Export Settings...
[09-15-2019 :: 16:50:42] [Zone Server] Loading quests
[09-15-2019 :: 16:50:42] [Quests] Tying perl output to eqemu logs
[09-15-2019 :: 16:50:42] [Quests] Creating EQEmuIO=HASH(0xfcb1bb4)
[09-15-2019 :: 16:50:42] [Quests] Creating EQEmuIO=HASH(0xfcc4e4c)
[09-15-2019 :: 16:50:42] [Quests] Loading perlemb plugins.
[09-15-2019 :: 16:50:42] [Quests] Unable to read perl file 'plugin.pl'
[09-15-2019 :: 16:50:42] [Quests] Subroutine Cwd::fastcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[09-15-2019 :: 16:50:42] [Quests] Subroutine Cwd::getcwd redefined at C:/Perl/lib/Cwd.pm line 812.
[09-15-2019 :: 16:50:42] [Quests] Subroutine Cwd::abs_path redefined at C:/Perl/lib/Cwd.pm line 812.
[09-15-2019 :: 16:50:42] [Quests] Subroutine CalcDestFromHeading redefined at ./plugins//path_tools.pl line 221.
[09-15-2019 :: 16:50:42] [Quests] "my" variable $Item1 masks earlier declaration in same scope at ./plugins//quest_handin.pl line 19.
[09-15-2019 :: 16:50:42] [Quests] "my" variable $Item2 masks earlier declaration in same scope at ./plugins//quest_handin.pl line 21.
[09-15-2019 :: 16:50:42] [Quests] "my" variable $Item3 masks earlier declaration in same scope at ./plugins//quest_handin.pl line 23.
[09-15-2019 :: 16:50:42] [Quests] "my" variable $Item4 masks earlier declaration in same scope at ./plugins//quest_handin.pl line 25.
[09-15-2019 :: 16:50:42] [Quests] Subroutine RandomRoam redefined at ./plugins//randomroam.pl line 10.
[09-15-2019 :: 16:50:42] [Quests] Subroutine StraightPath redefined at ./plugins//randomroam.pl line 68.
[09-15-2019 :: 16:50:42] [Quests] Subroutine RandomSwim redefined at ./plugins//randomroam.pl line 161.
[09-15-2019 :: 16:50:42] [Quests] Subroutine CalcDestFromHeading redefined at ./plugins//randomroam.pl line 222.
[09-15-2019 :: 16:50:42] [Quests] Subroutine RandomRange redefined at ./plugins//random_utils.pl line 3.
[09-15-2019 :: 16:50:42] [Quests] Found = in conditional, should be == at ./plugins//rathunt.pl line 45.
[09-15-2019 :: 16:50:42] [Quests] Found = in conditional, should be == at ./plugins//rathunt.pl line 53.
[09-15-2019 :: 16:50:42] [Quests] Found = in conditional, should be == at ./plugins//rathunt.pl line 88.
[09-15-2019 :: 16:50:42] [Quests] Found = in conditional, should be == at ./plugins//rathunt.pl line 96.
[09-15-2019 :: 16:50:42] [Quests] Subroutine moelib_spawn_block redefined at ./plugins//spawn_utils.pl line 2.
[09-15-2019 :: 16:50:42] [Quests] Subroutine moelib_spawn_block_center redefined at ./plugins//spawn_utils.pl line 23.
[09-15-2019 :: 16:50:42] [Quests] Subroutine moelib_spawn_circle redefined at ./plugins//spawn_utils.pl line 45.
[09-15-2019 :: 16:50:42] [Quests] Subroutine GetMaxLoSDistFromHeading redefined at ./plugins//spawn_utils.pl line 71.
[09-15-2019 :: 16:50:42] [Quests] Subroutine FaceBestHeading redefined at ./plugins//spawn_utils.pl line 134.
[09-15-2019 :: 16:50:42] [Quests] Subroutine HeadingToShortestLoS redefined at ./plugins//spawn_utils.pl line 204.
[09-15-2019 :: 16:50:42] [Quests] Subroutine MoveAwayFromWall redefined at ./plugins//spawn_utils.pl line 268.
[09-15-2019 :: 16:50:42] [Quests] Subroutine MoveToFirstBestZ redefined at ./plugins//spawn_utils.pl line 340.
[09-15-2019 :: 16:50:42] [Quests] Subroutine SpawnZone redefined at ./plugins//spawn_utils.pl line 373.
[09-15-2019 :: 16:50:42] [Quests] Subroutine GetReverseHeading redefined at ./plugins//spawn_utils.pl line 456.
[09-15-2019 :: 16:50:42] [Quests] Subroutine ConvertHeadingToDegrees redefined at ./plugins//spawn_utils.pl line 477.
[09-15-2019 :: 16:50:42] [Quests] Subroutine vtell redefined at ./plugins//voicetell.pl line 6.
[09-15-2019 :: 16:50:42] [Quests] Subroutine Autovtell redefined at ./plugins//voicetell.pl line 56.
[09-15-2019 :: 16:50:42] [Zone Server] Entering sleep mode
[09-15-2019 :: 16:50:43] [Zone Server] Websocket Server listener started (0.0.0.0:7000).
[09-15-2019 :: 16:50:43] [Zone Server] Starting EQ Network server on port 7000
[09-15-2019 :: 16:53:10] [Status] Booting cazicthule (48:0)
[09-15-2019 :: 16:53:10] [MySQL Error] 1054: Unknown column 'fast_regen_hp' in 'field list' 
 SELECT ztype, fog_red, fog_green, fog_blue, fog_minclip, fog_maxclip, fog_red2, fog_green2, fog_blue2, fog_minclip2, fog_maxclip2, fog_red3, fog_green3, fog_blue3, fog_minclip3, fog_maxclip3, fog_red4, fog_green4, fog_blue4, fog_minclip4, fog_maxclip4, fog_density, sky, zone_exp_multiplier, safe_x, safe_y, safe_z, underworld, minclip, maxclip, time_type, canbind, cancombat, canlevitate, castoutdoor, hotzone, ruleset, suspendbuffs, map_file_name, short_name, rain_chance1, rain_chance2, rain_chance3, rain_chance4, rain_duration1, rain_duration2, rain_duration3, rain_duration4, snow_chance1, snow_chance2, snow_chance3, snow_chance4, snow_duration1, snow_duration2, snow_duration3, snow_duration4, gravity, fast_regen_hp, fast_regen_mana, fast_regen_endurance, npc_max_aggro_dist, max_movement_update_range FROM zone WHERE zoneidnumber = 48 AND version = 0
[09-15-2019 :: 16:53:10] [Status] Successfully loaded Zone Config.
[09-15-2019 :: 16:53:10] [Status] Attempting to load Map File 'Maps//base/default.map'
[09-15-2019 :: 16:53:10] [Status] Loading spawn conditions...
[09-15-2019 :: 16:53:10] [Status] Loading static zone points...
[09-15-2019 :: 16:53:10] [Status] Loading spawn groups...
[09-15-2019 :: 16:53:10] [MySQL Error] 1054: Unknown column 'condition_value_filter' in 'field list' 
 SELECT DISTINCT spawnentry.spawngroupID, npcid, chance, condition_value_filter, npc_types.spawn_limit AS sl FROM spawnentry, spawn2, npc_types WHERE spawnentry.npcID = npc_types.id AND spawnentry.spawngroupID = spawn2.spawngroupID AND zone = 'cazicthule'
[09-15-2019 :: 16:53:10] [Error] Loading spawn groups failed.
[09-15-2019 :: 16:53:17] [Status] Booting cazicthule (48:0)
[09-15-2019 :: 16:53:17] [MySQL Error] 1054: Unknown column 'fast_regen_hp' in 'field list' 
 SELECT ztype, fog_red, fog_green, fog_blue, fog_minclip, fog_maxclip, fog_red2, fog_green2, fog_blue2, fog_minclip2, fog_maxclip2, fog_red3, fog_green3, fog_blue3, fog_minclip3, fog_maxclip3, fog_red4, fog_green4, fog_blue4, fog_minclip4, fog_maxclip4, fog_density, sky, zone_exp_multiplier, safe_x, safe_y, safe_z, underworld, minclip, maxclip, time_type, canbind, cancombat, canlevitate, castoutdoor, hotzone, ruleset, suspendbuffs, map_file_name, short_name, rain_chance1, rain_chance2, rain_chance3, rain_chance4, rain_duration1, rain_duration2, rain_duration3, rain_duration4, snow_chance1, snow_chance2, snow_chance3, snow_chance4, snow_duration1, snow_duration2, snow_duration3, snow_duration4, gravity, fast_regen_hp, fast_regen_mana, fast_regen_endurance, npc_max_aggro_dist, max_movement_update_range FROM zone WHERE zoneidnumber = 48 AND version = 0
[09-15-2019 :: 16:53:17] [Status] Successfully loaded Zone Config.
[09-15-2019 :: 16:53:17] [Status] Attempting to load Map File 'Maps//base/default.map'
[09-15-2019 :: 16:53:17] [Status] Loading spawn conditions...
[09-15-2019 :: 16:53:17] [Status] Loading static zone points...
[09-15-2019 :: 16:53:17] [Status] Loading spawn groups...
[09-15-2019 :: 16:53:17] [MySQL Error] 1054: Unknown column 'condition_value_filter' in 'field list' 
 SELECT DISTINCT spawnentry.spawngroupID, npcid, chance, condition_value_filter, npc_types.spawn_limit AS sl FROM spawnentry, spawn2, npc_types WHERE spawnentry.npcID = npc_types.id AND spawnentry.spawngroupID = spawn2.spawngroupID AND zone = 'cazicthule'
[09-15-2019 :: 16:53:17] [Error] Loading spawn groups failed.
[09-15-2019 :: 16:53:21] [Status] Booting cazicthule (48:0)
[09-15-2019 :: 16:53:21] [MySQL Error] 1054: Unknown column 'fast_regen_hp' in 'field list' 
 SELECT ztype, fog_red, fog_green, fog_blue, fog_minclip, fog_maxclip, fog_red2, fog_green2, fog_blue2, fog_minclip2, fog_maxclip2, fog_red3, fog_green3, fog_blue3, fog_minclip3, fog_maxclip3, fog_red4, fog_green4, fog_blue4, fog_minclip4, fog_maxclip4, fog_density, sky, zone_exp_multiplier, safe_x, safe_y, safe_z, underworld, minclip, maxclip, time_type, canbind, cancombat, canlevitate, castoutdoor, hotzone, ruleset, suspendbuffs, map_file_name, short_name, rain_chance1, rain_chance2, rain_chance3, rain_chance4, rain_duration1, rain_duration2, rain_duration3, rain_duration4, snow_chance1, snow_chance2, snow_chance3, snow_chance4, snow_duration1, snow_duration2, snow_duration3, snow_duration4, gravity, fast_regen_hp, fast_regen_mana, fast_regen_endurance, npc_max_aggro_dist, max_movement_update_range FROM zone WHERE zoneidnumber = 48 AND version = 0
[09-15-2019 :: 16:53:21] [Status] Successfully loaded Zone Config.
[09-15-2019 :: 16:53:21] [Status] Attempting to load Map File 'Maps//base/default.map'
[09-15-2019 :: 16:53:21] [Status] Loading spawn conditions...
[09-15-2019 :: 16:53:21] [Status] Loading static zone points...
[09-15-2019 :: 16:53:21] [Status] Loading spawn groups...
[09-15-2019 :: 16:53:21] [MySQL Error] 1054: Unknown column 'condition_value_filter' in 'field list' 
 SELECT DISTINCT spawnentry.spawngroupID, npcid, chance, condition_value_filter, npc_types.spawn_limit AS sl FROM spawnentry, spawn2, npc_types WHERE spawnentry.npcID = npc_types.id AND spawnentry.spawngroupID = spawn2.spawngroupID AND zone = 'cazicthule'
[09-15-2019 :: 16:53:21] [Error] Loading spawn groups failed.
[09-15-2019 :: 16:54:06] [Status] Booting cazicthule (48:0)
[09-15-2019 :: 16:54:06] [MySQL Error] 1054: Unknown column 'fast_regen_hp' in 'field list' 
 SELECT ztype, fog_red, fog_green, fog_blue, fog_minclip, fog_maxclip, fog_red2, fog_green2, fog_blue2, fog_minclip2, fog_maxclip2, fog_red3, fog_green3, fog_blue3, fog_minclip3, fog_maxclip3, fog_red4, fog_green4, fog_blue4, fog_minclip4, fog_maxclip4, fog_density, sky, zone_exp_multiplier, safe_x, safe_y, safe_z, underworld, minclip, maxclip, time_type, canbind, cancombat, canlevitate, castoutdoor, hotzone, ruleset, suspendbuffs, map_file_name, short_name, rain_chance1, rain_chance2, rain_chance3, rain_chance4, rain_duration1, rain_duration2, rain_duration3, rain_duration4, snow_chance1, snow_chance2, snow_chance3, snow_chance4, snow_duration1, snow_duration2, snow_duration3, snow_duration4, gravity, fast_regen_hp, fast_regen_mana, fast_regen_endurance, npc_max_aggro_dist, max_movement_update_range FROM zone WHERE zoneidnumber = 48 AND version = 0
[09-15-2019 :: 16:54:06] [Status] Successfully loaded Zone Config.
[09-15-2019 :: 16:54:06] [Status] Attempting to load Map File 'Maps//base/default.map'
[09-15-2019 :: 16:54:06] [Status] Loading spawn conditions...
[09-15-2019 :: 16:54:06] [Status] Loading static zone points...
[09-15-2019 :: 16:54:06] [Status] Loading spawn groups...
[09-15-2019 :: 16:54:06] [MySQL Error] 1054: Unknown column 'condition_value_filter' in 'field list' 
 SELECT DISTINCT spawnentry.spawngroupID, npcid, chance, condition_value_filter, npc_types.spawn_limit AS sl FROM spawnentry, spawn2, npc_types WHERE spawnentry.npcID = npc_types.id AND spawnentry.spawngroupID = spawn2.spawngroupID AND zone = 'cazicthule'
[09-15-2019 :: 16:54:06] [Error] Loading spawn groups failed.
Reply With Quote
  #2  
Old 09-15-2019, 05:48 PM
Thalix's Avatar
Thalix
Sarnak
 
Join Date: Sep 2016
Posts: 91
Default

Your database is outdated. A lot of fields are missing.
Reply With Quote
  #3  
Old 09-15-2019, 05:51 PM
gcobb
Fire Beetle
 
Join Date: Jun 2008
Location: NC
Posts: 3
Default

Ok, makes sense. Think updating DB schema would fix it? Don't think I've done that before and want to make sure there won't be any data loss.
Reply With Quote
  #4  
Old 09-15-2019, 07:03 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

Did you do this binary update offline?
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #5  
Old 09-15-2019, 07:13 PM
gcobb
Fire Beetle
 
Join Date: Jun 2008
Location: NC
Posts: 3
Default

Let me give a little more context. I've been using Akka's repacked version of the server for about 2 years. In an attempt to try out some server code changes, I cloned the current "Server" git and used it to build new binaries. From what I'm hearing, I guess the current server assets aren't exactly compatible with my 2-year-old DB. I'm kind of confused, though--if eqemu_server.pl contains a DB update script, shouldn't my DB schema already have been updated to the latest version?

I appreciate any help you all can offer. I was hoping to find a way to make changes to the server code without reinstalling the server, but I'm starting to suspect that's what I might have to do.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 06:46 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3