ERROR 1054 Unknown column
Just tried adding bots to my server and getting these messages on server start. Have not tested them but figured id get this resolved before I go any further with them.
Any ideas on how to resolve this? Code:
[Status] Loading items... |
Update: Did a complete reinstall with deleting the eqemu folder. Restored my DB back and checked all was OK. Then ran check_db_update and re-ran the bot installer. Get the same errors after server start.
Guess I will continue without bots until I know more on how to fix this. :-) |
You're using stable binaries, I take it?
Download the unstable binaries, then update your dll files. |
Yes, I'm running the standard code for Linux. I don't really see a way to this through the menu as this is only a Windows option. Thanks for looking at this though and I can wait until the changes gets into the stable code and then try it.
|
I think linux builds fresh each time for the installer...
Not sure how the linux flavor gets its updates - anyone else? |
Unknown column (death_marquee)
It's been a while since this thread has been updated but in case it is still an issue, here is what I did to fix it when I updated the server code from a fairly old install and it was failing to run with the same error you were getting.
You can run this query on your db: alter table `bot_owner_options` ADD COLUMN `death_marquee` SMALLINT(3) UNSIGNED NULL DEFAULT '0'; and that fixed it for me and I was able to get to character select and log in. Something is causing death_marquee added by 2018_10_09_bots_owner_options.sql to be droped from the table when updating the db. While digging, I saw there are a bunch of db and bot db updates that don't get applied (9022 and 9025) while I see the table structure is identical to the changes they apply so I guess there is some issue with the check_db_updates and check_bot_db_updates code that identifies which patches are applied but I'll check on that at a later time as it's not causing identifiable issues on the server atm. If it's still not working for you, drop the [Database] output from a server_start_dev.sh and I'll see if I can spot what is causing issues for you. |
Update 9026 changes the table altogether: https://github.com/EQEmu/Server/blob...ons_rework.sql
I was adding more and more owner options and got tired of all of the hassle associated with the old way of bookkeeping. I made a change to the requirement criteria recently that 'should' avert that problem in future updating: https://github.com/EQEmu/Server/comm...eb5d06f12c4dd5 Let me know if it doesn't, please :) Note: The fix for this particular issue is to run this query: Code:
UPDATE `db_version` SET `bots_version` = '9026'; |
All times are GMT -4. The time now is 03:21 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.