EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)
-   -   Did an update, Zone Server stopped did Schema change???? (https://www.eqemulator.org/forums/showthread.php?t=43822)

Freejack 03-02-2023 04:17 PM
Did an update, Zone Server stopped did Schema change????
 
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] (8)
[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] (38)
[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

Freejack 03-06-2023 06:39 AM
Does anyone know of a fix?

Freejack 03-08-2023 02:47 PM
Ok got this all fixed up and working again, I am not the greatest at sql queries but I can figure out data.

I now have a spam issue in the chat windows of TYou have been charged a mercenary upkeep cost of 3 plat, and 1 gold and your mercenary upkeep cost timer has been reset to . and that is all I get over and over.....

Any ideas how to fix this one since it stems from my original issue of which I fixed with updating all the assets of maps and db updates.

Also getting a unknown column 'faction_amount' in 'field list" any idea how to fix this one too.

[03-08-2023 12:42:15] [Zone] [QueryErr] [1054] [Unknown column 'faction_amount' in 'field list']
[SELECT id, name, lastname, level, race, `class`, bodytype, hp, mana, gender, texture, helmtexture, heros

Freejack 03-09-2023 05:37 AM
Ok did a wipe and fresh install, all the NPC's just vanished during this entire situation.

Appears that it is the Mercs that caused this. I did the updates for the server using the script to pull db updates and that is where it all went wonky.

I did fresh install and enabled bots as normal and was about to do Mercs when I saw the script and saw the tables. The tables of which were in question . So Bots will be in and Mercs are out. Doesn't seem to be anyone actually maintaining Mercs and Bots actually works well enough.

Anyone have this issue you now know the cause.

manawenuz 03-09-2023 11:42 AM
Quote:
Originally Posted by Freejack (Post 268856)
Ok did a wipe and fresh install, all the NPC's just vanished during this entire situation.

Appears that it is the Mercs that caused this. I did the updates for the server using the script to pull db updates and that is where it all went wonky.

I did fresh install and enabled bots as normal and was about to do Mercs when I saw the script and saw the tables. The tables of which were in question . So Bots will be in and Mercs are out. Doesn't seem to be anyone actually maintaining Mercs and Bots actually works well enough.

Anyone have this issue you now know the cause.
Mercs definitely do work, but as you stated, they get much less use than bots these days. Just a heads up that if you have any future issues you may want to consider posting to the Eqemu discord. You'll likely get a lot more help there: https://discord.gg/QqqZcWWzwG

Freejack 03-10-2023 06:30 PM
Quote:
Originally Posted by manawenuz (Post 268858)
Mercs definitely do work, but as you stated, they get much less use than bots these days. Just a heads up that if you have any future issues you may want to consider posting to the Eqemu discord. You'll likely get a lot more help there: https://discord.gg/QqqZcWWzwG
Yes Mercs do work but something changed in the schema that made it break things. I like Mercs but sadly you only get one.


All times are GMT -4. The time now is 07:38 AM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.