Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Linux Servers
Reload this Page Errors starting up server after restoring database on a new server

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

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2022, 11:43 AM
joedit
Fire Beetle
  
Join Date: Feb 2021
Posts: 19
Default Errors starting up server after restoring database on a new server
Hi all, I am trying to restore a backup from an older server (built Aug 2021) onto a newly built server, and I encountered some errors during startup. The new server with the restored database seems to work fine (so far). I suspect there are new codes in the recent server build? Any suggestions on how to resolve it?

I tried updating the database and server assets (using eqemu_server.pl) on the old server before backing up the database, but restoring it on the newly built server still returned with the errors. Any thoughts? Or do I just ignore the errors? BTW the server is installed on ubuntu 18.04 server.

Thanks in advance.

Code:
name@1804_test:/home/eqemu/server$ sudo ./server_start_with_login.sh
[sudo] password for name:
[SharedMemory] [Info] Shared Memory Loader Program
[SharedMemory] [Info] Connecting to database
[SharedMemory] [Info] [MySQL] Connection [default] database [eqemu] at [127.0.0.1]:[3306]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[SELECT log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id FROM logsys_categories WHERE TRUE ORDER BY log_category_id]
[SharedMemory] [Info] Automatically adding new log category [AA]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (1,'AA',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [AI]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (2,'AI',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Aggro]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (3,'Aggro',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Attack]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (4,'Attack',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Packet :: Client -> Server]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (5,'Packet :: Client -> Server',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Combat]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (6,'Combat',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Commands]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (7,'Commands',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Crash]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (8,'Crash',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Debug]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (9,'Debug',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Doors]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (10,'Doors',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Error]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (11,'Error',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Guilds]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (12,'Guilds',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Inventory]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (13,'Inventory',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Launcher]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (14,'Launcher',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Netcode]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (15,'Netcode',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Normal]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (16,'Normal',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Object]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (17,'Object',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Pathing]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (18,'Pathing',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [QS Server]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (19,'QS Server',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Quests]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (20,'Quests',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Rules]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (21,'Rules',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Skills]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (22,'Skills',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Spawns]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (23,'Spawns',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Spells]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (24,'Spells',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Status]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (25,'Status',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [TCP Connection]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (26,'TCP Connection',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Tasks]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (27,'Tasks',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Tradeskills]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (28,'Tradeskills',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Trading]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (29,'Trading',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Tribute]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (30,'Tribute',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [UCS Server]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (31,'UCS Server',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [WebInterface Server]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (32,'WebInterface Server',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [World Server]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (33,'World Server',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Zone Server]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (34,'Zone Server',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [MySQL Error]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (35,'MySQL Error',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [MySQL Query]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (36,'MySQL Query',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Mercenaries]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (37,'Mercenaries',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Quest Debug]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (38,'Quest Debug',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Packet :: Server -> Client]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (39,'Packet :: Server -> Client',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Packet :: Client -> Server Unhandled]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (40,'Packet :: Client -> Server Unhandled',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Packet :: Server -> Client (Dump)]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (41,'Packet :: Server -> Client (Dump)',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Packet :: Client -> Server (Dump)]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (42,'Packet :: Client -> Server (Dump)',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Login Server]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (43,'Login Server',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Client Login]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (44,'Client Login',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Headless Client]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (45,'Headless Client',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [HP Update]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (46,'HP Update',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [FixZ]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (47,'FixZ',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Food]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (48,'Food',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Traps]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (49,'Traps',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [NPC Roam Box]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (50,'NPC Roam Box',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [NPC Scaling]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (51,'NPC Scaling',0,0,1,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Mob Appearance]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (52,'Mob Appearance',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Info]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (53,'Info',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Warning]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (54,'Warning',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Critical]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (55,'Critical',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Emergency]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (56,'Emergency',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Alert]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (57,'Alert',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Notice]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (58,'Notice',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [AI Scan Close]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (59,'AI Scan Close',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [AI Yell For Help]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (60,'AI Yell For Help',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [AI Cast Beneficial Close]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (61,'AI Cast Beneficial Close',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [AOE Cast]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (62,'AOE Cast',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Entity Management]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (63,'Entity Management',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Flee]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (64,'Flee',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Aura]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (65,'Aura',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [HotReload]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (66,'HotReload',1,0,1,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Merchants]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (67,'Merchants',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [ZonePoints]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (68,'ZonePoints',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Loot]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (69,'Loot',0,0,1,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Expeditions]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (70,'Expeditions',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [DynamicZones]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (71,'DynamicZones',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Scheduler]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (72,'Scheduler',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Cheat]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (73,'Cheat',1,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [ClientList]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (74,'ClientList',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [DialogueWindow]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (75,'DialogueWindow',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [HTTP]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (76,'HTTP',1,0,1,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Saylink]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (77,'Saylink',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [ChecksumVerification]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (78,'ChecksumVerification',1,0,1,0,0)]
[SharedMemory] [Info] Automatically adding new log category [CombatRecord]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (79,'CombatRecord',0,0,1,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Hate]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (80,'Hate',0,0,0,0,0)]
[SharedMemory] [Info] Automatically adding new log category [Discord]
[SharedMemory] [MySQL Error] [1054] [Unknown column 'log_to_discord' in 'field list']
[INSERT INTO logsys_categories (log_category_id, log_category_description, log_to_console, log_to_file, log_to_gmsay, log_to_discord, discord_webhook_id)  VALUES (81,'Discord',1,0,0,0,0)]
[SharedMemory] [Info] Loaded [0] log categories
[SharedMemory] [Info] Loaded default rule set 'default'
[SharedMemory] [Info] Initialized dynamic dictionary entries
[SharedMemory] [Info] Current expansion is [-1] (All Expansions)
[SharedMemory] [Info] Loaded content flag [peq_halloween] [Disabled]
[SharedMemory] [Info] Current expansion is [-1] (All Expansions)
[SharedMemory] [Info] Loading items
[SharedMemory] [Info] Loading factions
[SharedMemory] [Info] Loading loot
[SharedMemory] [Info] Loading skill caps
[SharedMemory] [Info] Loading spells
[SharedMemory] [Info] Loading base data
Server started - use server_status.sh to check server status
name@1804_test:/home/eqemu/server$
Akka's Linux Server Launcher
Loginserver set to run...
Zones to launch: 30
name@1804_test:/home/eqemu/server$
Reply With Quote
  #2  
Old 08-16-2022, 02:02 PM
Huppy's Avatar
Huppy
Demi-God
  
Join Date: Oct 2010
Posts: 1,332
Default
Quote:
Originally Posted by joedit View Post
I tried updating the database and server assets (using eqemu_server.pl) on the old server before backing up the database, but restoring it on the newly built server still returned with the errors.
Sometimes that update script is not so reliable. Just recently, I had to backdate the db_version (on a fresh 9196 peqdb), so it would check for more missing updates/tables/columns. Sometimes, I've had to manually install the updates individually. If you copy and paste the following into an sql query, it will get rid of that error.


Code:
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for logsys_categories
-- ----------------------------
DROP TABLE IF EXISTS `logsys_categories`;
CREATE TABLE `logsys_categories`  (
  `log_category_id` int(11) NOT NULL,
  `log_category_description` varchar(150) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `log_to_console` smallint(11) NULL DEFAULT 0,
  `log_to_file` smallint(11) NULL DEFAULT 0,
  `log_to_gmsay` smallint(11) NULL DEFAULT 0,
  `log_to_discord` smallint(11) NULL DEFAULT 0,
  `discord_webhook_id` int(11) NULL DEFAULT 0,
  PRIMARY KEY (`log_category_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of logsys_categories
-- ----------------------------
INSERT INTO `logsys_categories` VALUES (1, 'AA', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (2, 'AI', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (3, 'Aggro', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (4, 'Attack', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (5, 'Packet :: Client -> Server', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (6, 'Combat', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (7, 'Commands', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (8, 'Crash', 0, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (9, 'Debug', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (10, 'Doors', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (11, 'Error', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (12, 'Guilds', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (13, 'Inventory', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (14, 'Launcher', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (15, 'Netcode', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (16, 'Normal', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (17, 'Object', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (18, 'Pathing', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (19, 'QS Server', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (20, 'Quests', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (21, 'Rules', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (22, 'Skills', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (23, 'Spawns', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (24, 'Spells', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (25, 'Status', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (26, 'TCP Connection', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (27, 'Tasks', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (28, 'Tradeskills', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (29, 'Trading', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (30, 'Tribute', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (31, 'UCS Server', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (32, 'WebInterface Server', 0, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (33, 'World Server', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (34, 'Zone Server', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (35, 'MySQL Error', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (36, 'MySQL Query', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (37, 'Mercenaries', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (38, 'Quest Debug', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (39, 'Packet :: Server -> Client', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (40, 'Packet :: Client -> Server Unhandled', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (41, 'Packet :: Server -> Client (Dump)', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (42, 'Packet :: Client -> Server (Dump)', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (43, 'Login Server', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (44, 'Client Login', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (45, 'Headless Client', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (46, 'HP Update', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (47, 'FixZ', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (48, 'Food', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (49, 'Traps', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (50, 'NPC Roam Box', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (51, 'NPC Scaling', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (52, 'Mob Appearance', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (53, 'Info', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (54, 'Warning', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (55, 'Critical', 0, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (56, 'Emergency', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (57, 'Alert', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (58, 'Notice', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (59, 'AI Scan Close', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (60, 'AI Yell For Help', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (61, 'AI Cast Beneficial Close', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (62, 'AOE Cast', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (63, 'Entity Management', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (64, 'Flee', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (65, 'Aura', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (66, 'HotReload', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (67, 'Merchants', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (68, 'ZonePoints', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (69, 'Loot', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (70, 'Expeditions', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (71, 'DynamicZones', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (72, 'Group', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (73, 'Cheat', 0, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (74, 'ClientList', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (75, 'DialogueWindow', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (76, 'HTTP', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (77, 'Saylink', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (78, 'ChecksumVerification', 1, 1, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (79, 'CombatRecord', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (80, 'Hate', 0, 0, 0, 0, 0);
INSERT INTO `logsys_categories` VALUES (81, 'Discord', 0, 0, 0, 0, 0);

SET FOREIGN_KEY_CHECKS = 1;
__________________
Hanging out at Antonica.World
Reply With Quote
  #3  
Old 08-16-2022, 03:44 PM
joedit
Fire Beetle
  
Join Date: Feb 2021
Posts: 19
Default
Thank You Huppy! The code worked!

Quote:
Sometimes that update script is not so reliable. Just recently, I had to backdate the db_version (on a fresh 9196 peqdb), so it would check for more missing updates/tables/columns. Sometimes, I've had to manually install the updates individually. If you copy and paste the following into an sql query, it will get rid of that error.
So I guess I was doing the right steps, just that the codes might not have been updated correctly/fully. Thanks again for the tips. Unfortunately I was never a DB guy, hopefully I won't run into similar issues again....

On a side note, I installed the server, and subsequently restored an old database on Ubuntu 22.04 LTS, and it seems to be running fine for the time being. It has only been running for an hour or so, so it is still too early to decide, but it seems fine.

Thanks again.
Reply With Quote
  #4  
Old 09-09-2022, 05:25 PM
Hyyr
Fire Beetle
  
Join Date: Feb 2021
Location: North Carolina
Posts: 25
Default
Thank you, Huppy! I had the same exact issue, and running your script fixed the errors.
Reply With Quote
Reply

Tags
backup, linux, restore

« 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 11:46 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