Where Can I Get Database Files?

Branflake · #4 03-17-2025, 10:22 PM

I am having the same problem.

Zone | QueryErr | QueryDatabase MySQL Error (1054) [Unknown column 'etl_enabled' in 'field list'] Query [SELECT id, event_name, event_enabled, retention_days, discord_webhook_id, etl_enabled FROM player_event_log_settings] Zone | QueryErr | QueryDatabase MySQL Error (1054) [Unknown column 'etl_enabled' in 'field list'] Query [REPLACE INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id, etl_enabled) VALUES (1,'GM Command',1,7,0,0),(2,'Zoning',1,7,0,0),(3,'AA Gain',1,7,0,0),(4,'AA Purchase',1,7,0,0),(5,'Forage Success',0,7,0,0),(6,'Forage Failure',0,7,0,0),(7,'Fish Success',0,7,0,0),(8,'Fish Failure',0,7,0,0),(9,'Item Destroy',1,7,0,0),(10,'Went Online',0,7,0,0),(11,'Went Offline',0,7,0,0),(12,'Level Gain',1,7,0,0),(13,'Level Loss',1,7,0,0),(14,'Loot Item',1,7,0,0),(15,'Merchant Purchase',1,7,0,0),(16,'Merchant Sell',1,7,0,0),(21,'Groundspawn Pickup',1,7,0,0),(22,'NPC Handin',1,7,0,0),(23,'Skill Up',0,7,0,0),(24,'Task Accept',1,7,0,0),(25,'Task Update',1,7,0,0),(26,'Task Complete',1,7,0,0),(27,'Trade',1,7,0,0),(29,'Say', 0,7,0,0),(30,'Rez Accepted',1,7,0,0),(31,'Death',1,7,0,0),(32,'Combi ne Failure',1,7,0,0),(33,'Combine Success',1,7,0,0),(34,'Dropped Item',1,7,0,0),(35,'Split Money',1,7,0,0),(38,'Trader Purchase',1,7,0,0),(39,'Trader Sell',1,7,0,0),(42,'Discover Item',1,7,0,0),(43,'Possible Hack',1,7,0,0),(44,'Killed NPC',0,7,0,0),(45,'Killed Named NPC',1,7,0,0),(46,'Killed Raid NPC',1,7,0,0),(47,'Item Creation',1,7,0,0),(48,'Guild Tribute Donate Item',1,7,0,0),(49,'Guild Tribute Donate Platinum',1,7,0,0),(50,'Parcel Item Sent',1,7,0,0),(51,'Parcel Item Retrieved',1,7,0,0),(52,'Parcel Prune Routine',1,7,0,0),(53,'Barter Transaction',1,7,0,0),(54,'Player Speech',0,7,0,0),(55,'Evolve Item Update',1,7,0,0),(56,'Guild Bank Item Deposit',1,7,0,0),(57,'Guild Bank Item Withdrawal',1,7,0,0),(58,'Guild Bank Move From Deposit Area to Bank Area',1,7,0,0)]

also UCS is failing preflight checks

UCS | QueryErr | QueryDatabase MySQL Error (1054) [Unknown column 'etl_enabled' in 'field list'] Query [SELECT id, event_name, event_enabled, retention_days, discord_webhook_id, etl_enabled FROM player_event_log_settings] UCS | QueryErr | QueryDatabase MySQL Error (1054) [Unknown column 'etl_enabled' in 'field list'] Query [REPLACE INTO player_event_log_settings (id, event_name, event_enabled, retention_days, discord_webhook_id, etl_enabled) VALUES (1,'GM Command',1,7,0,0),(2,'Zoning',1,7,0,0),(3,'AA Gain',1,7,0,0),(4,'AA Purchase',1,7,0,0),(5,'Forage Success',0,7,0,0),(6,'Forage Failure',0,7,0,0),(7,'Fish Success',0,7,0,0),(8,'Fish Failure',0,7,0,0),(9,'Item Destroy',1,7,0,0),(10,'Went Online',0,7,0,0),(11,'Went Offline',0,7,0,0),(12,'Level Gain',1,7,0,0),(13,'Level Loss',1,7,0,0),(14,'Loot Item',1,7,0,0),(15,'Merchant Purchase',1,7,0,0),(16,'Merchant Sell',1,7,0,0),(21,'Groundspawn Pickup',1,7,0,0),(22,'NPC Handin',1,7,0,0),(23,'Skill Up',0,7,0,0),(24,'Task Accept',1,7,0,0),(25,'Task Update',1,7,0,0),(26,'Task Complete',1,7,0,0),(27,'Trade',1,7,0,0),(29,'Say', 0,7,0,0),(30,'Rez Accepted',1,7,0,0),(31,'Death',1,7,0,0),(32,'Combi ne Failure',1,7,0,0),(33,'Combine Success',1,7,0,0),(34,'Dropped Item',1,7,0,0),(35,'Split Money',1,7,0,0),(38,'Trader Purchase',1,7,0,0),(39,'Trader Sell',1,7,0,0),(42,'Discover Item',1,7,0,0),(43,'Possible Hack',1,7,0,0),(44,'Killed NPC',0,7,0,0),(45,'Killed Named NPC',1,7,0,0),(46,'Killed Raid NPC',1,7,0,0),(47,'Item Creation',1,7,0,0),(48,'Guild Tribute Donate Item',1,7,0,0),(49,'Guild Tribute Donate Platinum',1,7,0,0),(50,'Parcel Item Sent',1,7,0,0),(51,'Parcel Item Retrieved',1,7,0,0),(52,'Parcel Prune Routine',1,7,0,0),(53,'Barter Transaction',1,7,0,0),(54,'Player Speech',0,7,0,0),(55,'Evolve Item Update',1,7,0,0),(56,'Guild Bank Item Deposit',1,7,0,0),(57,'Guild Bank Item Withdrawal',1,7,0,0),(58,'Guild Bank Move From Deposit Area to Bank Area',1,7,0,0)]

Apparently this hasn't been addressed, yet.

I logged into discord, asked for access to full members list, got nothing in several hours.

How do one update the Database?

I was able to update the binaries easy enough just copy past, but going through heidi "run sql file," not getting anything except errors.