Where Can I Get Database Files?

[rmgreen]

Good evening;


Doing this for the first time. I have the Titanium Edition client installed, with appropriate changes made to the eqhost file to make sure it doesn't want to call home, proper communication seems to be set up so that the install can find my completely local server, and Spire is running - *but* the Zone server will not run. Apparently, the database has an extra field in the "field list", which makes it fail the pre-launch check. All other server aspects check as good to go.

Failed pre-launch = no launch = no game = no initial account. :'(

I have already done a *complete* deletion / reinstall - same result.

If someone can tell me where I can find replacement database data, as well as letting me know just which files to remove/replace and where in the directory structure, it would be *much* appreciated.

Thanks in advance!

- Ronald -

[Archanen1980]

I am having the same exact issue on my end. clean install atleast 15 times all with the same result. installed to a virtualbox machine. Set the configurations inside of spire . When i click pre flight checklist World and login light up green. ZOne and UCS does not. Show up red with zone querry issues.



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,..............................

[blackdragonsdg]

First off you both need to get on discord as you will get help with your problems much faster.
https://discord.com/invite/785p886eCw/login

Database - https://db.projecteq.net/

Binaries and spire - https://spire.akkadius.com/dev/releases

The problem you are encountering is likely related to some recent changes to the source code. Updated binaries may fix the problem. May have to reload database also. Just post it on discord and see what others think.

[Branflake]

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.