Did an update, Zone Server stopped did Schema change????

Freejack · #1 03-02-2023, 04:17 PM

I am using the docker version and did the update, had an issue did the fix for it and now it is working except it is telling me the zone servers are not up due to a schema issue with missing tables now. was working before the update......

Here is a log of what I get.....

[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[SELECT id, event_name, event_enabled, retention_days, discord_webhook_id FROM player_event_log_settings]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [GM Command] (1)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (1,'GM Command',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Zoning] (2)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (2,'Zoning',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [AA Gain] (3)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (3,'AA Gain',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [AA Purchase] (4)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (4,'AA Purchase',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Forage Success] (5)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (5,'Forage Success',0,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Forage Failure] (6)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (6,'Forage Failure',0,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Fish Success] (7)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (7,'Fish Success',0,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Fish Failure] (

[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (8,'Fish Failure',0,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Item Destroy] (9)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (9,'Item Destroy',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Went Online] (10)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (10,'Went Online',0,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Went Offline] (11)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (11,'Went Offline',0,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Level Gain] (12)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (12,'Level Gain',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Level Loss] (13)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (13,'Level Loss',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Loot Item] (14)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (14,'Loot Item',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Merchant Purchase] (15)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (15,'Merchant Purchase',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Merchant Sell] (16)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (16,'Merchant Sell',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Groundspawn Pickup] (21)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (21,'Groundspawn Pickup',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [NPC Handin] (22)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (22,'NPC Handin',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Skill Up] (23)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (23,'Skill Up',0,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Task Accept] (24)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (24,'Task Accept',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Task Update] (25)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (25,'Task Update',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Task Complete] (26)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (26,'Task Complete',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Trade] (27)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (27,'Trade',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Say] (29)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (29,'Say',0,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Rez Accepted] (30)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (30,'Rez Accepted',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Death] (31)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (31,'Death',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Combine Failure] (32)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (32,'Combine Failure',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Combine Success] (33)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (33,'Combine Success',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Dropped Item] (34)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (34,'Dropped Item',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Split Money] (35)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (35,'Split Money',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Trader Purchase] (3

[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (38,'Trader Purchase',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Trader Sell] (39)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (39,'Trader Sell',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Discover Item] (42)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (42,'Discover Item',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Possible Hack] (43)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (43,'Possible Hack',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Killed NPC] (44)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (44,'Killed NPC',0,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Killed Named NPC] (45)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (45,'Killed Named NPC',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Killed Raid NPC] (46)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (46,'Killed Raid NPC',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] [New] PlayerEvent [Item Creation] (47)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1146] [Table 'peq.player_event_log_settings' doesn't exist]
[INSERT INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id) VALUES (47,'Item Creation',1,7,0)]
[03-02-2023 14:44:10] [Zone] [Info] CURRENT_VERSION [22.4.4-dev]
[03-02-2023 14:44:10] [Zone] [Info] Mapped [598] client opcode handlers
[03-02-2023 14:44:10] [Zone] [Info] Loaded [6] variable(s)
[03-02-2023 14:44:10] [Zone] [QueryErr] [1054] [Unknown column 'max_level' in 'field list']
[SELECT short_name, id, file_name, long_name, map_file_name, safe_x, safe_y, safe_z, safe_heading, graveyard_id, min_level, max_level, min_status, zoneidnumber, version, timezone, maxclients, ruleset, note, underworld, minclip, maxclip, fog_minclip, fog_maxclip, fog_blue, fog_red, fog_green, sky, ztype, zone_exp_multiplier, walkspeed, time_type, fog_red1, fog_green1, fog_blue1, fog_minclip1, fog_maxclip1, 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, flag_needed, canbind, cancombat, canlevitate, castoutdoor, hotzone, insttype, shutdowndelay, peqzone, expansion, bypass_expansion_check, suspendbuffs, 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, type, skylock, fast_regen_hp, fast_regen_mana, fast_regen_endurance, npc_max_aggro_dist, max_movement_update_range, min_expansion, max_expansion, content_flags, content_flags_disabled, underworld_teleport_index, lava_damage, min_lava_damage FROM zone]
[03-02-2023 14:44:10] [Zone] [Info] Loaded [0] zones
[03-02-2023 14:44:10] [Zone] [Error] Failed to load zones data, check your schema for possible errors