Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Linux Servers
Reload this Page Did an update, Zone Server stopped did Schema change????

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

Reply
 
Thread Tools Display Modes
  #1  
Old 03-02-2023, 04:17 PM
Freejack
Sarnak
  
Join Date: Jan 2022
Location: In the woods
Posts: 66
Default 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] (
[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
__________________
Freejacks EQ World
Just a place to adventure and do the things I did not do before and that was a long time ago.
Reply With Quote
  #2  
Old 03-06-2023, 06:39 AM
Freejack
Sarnak
  
Join Date: Jan 2022
Location: In the woods
Posts: 66
Default
Does anyone know of a fix?
__________________
Freejacks EQ World
Just a place to adventure and do the things I did not do before and that was a long time ago.
Reply With Quote
  #3  
Old 03-08-2023, 02:47 PM
Freejack
Sarnak
  
Join Date: Jan 2022
Location: In the woods
Posts: 66
Default
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
__________________
Freejacks EQ World
Just a place to adventure and do the things I did not do before and that was a long time ago.
Reply With Quote
  #4  
Old 03-09-2023, 05:37 AM
Freejack
Sarnak
  
Join Date: Jan 2022
Location: In the woods
Posts: 66
Default
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.
__________________
Freejacks EQ World
Just a place to adventure and do the things I did not do before and that was a long time ago.
Reply With Quote
  #5  
Old 03-09-2023, 11:42 AM
manawenuz's Avatar
manawenuz
Fire Beetle
  
Join Date: Oct 2021
Posts: 3
Default
Quote:
Originally Posted by Freejack View Post
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
__________________
-*-*-*-*-*-*-*-*-*-*-*-*-*-*
Aman - Home of the Valar: https://amaneq.com/home

The Firiona Vie Project: https://fvproject.com/index.php/Main_Page
Reply With Quote
  #6  
Old 03-10-2023, 06:30 PM
Freejack
Sarnak
  
Join Date: Jan 2022
Location: In the woods
Posts: 66
Default
Quote:
Originally Posted by manawenuz View Post
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.
__________________
Freejacks EQ World
Just a place to adventure and do the things I did not do before and that was a long time ago.
Reply With Quote
Reply

« Previous Thread | Next Thread »

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 01:32 PM.

EQEmulator - Archive - Top

 

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