World | Error | UpdateManifest Fatal | Shutting down

Comandr · #1 12-17-2025, 04:08 PM

Hi. I'm new to the private server game. Long story short, I was on server version 23.10.3dev when I first started my server on ubuntu server. Things seemed fine. I was able to enable bots, edit various aspects of the server like merchant inventories, etc.

Then due to an unrecoverable issue, I had to fully wipe everything and rebuild the server from scratch with a brand new download. Got it all configured back the way I wanted, and then I was unable to load the world server, and kept running into this error. I don't know if it changes anything, but I noticed I'm not on 23.10.3dev anymore, but the full stable 23.10.3.

World | Info | Init Loading server paths
World | Info | Init ----------------------------------------------------------------------
World | Info | Init server > [/home/eqemu/server]
World | Info | Init logs > [logs]
World | Info | Init maps > [maps]
World | Info | Init lua mods > [mods]
World | Info | Init patches > [assets/patches]
World | Info | Init opcode > [assets/opcodes]
World | Info | Init shared_memory > [shared]
World | Info | operator() quests > [quests]
World | Info | operator() plugins > [quests/plugins]
World | Info | operator() lua_modules > [quests/lua_modules]
World | Info | Init ----------------------------------------------------------------------
World | Info | LoadServerConfig Loading server configuration
World | Info | main CURRENT_VERSION [23.10.3]
World | Info | Connect Unable to resolve [login.projecteq.net] to an IP
World | Info | RegisterLoginservers Added loginserver [login.projecteq.net:5998]
World | Info | RegisterLoginservers Added loginserver [127.0.0.1:5998]
World | Info | RegisterLoginservers Added loginserver [login.eqemulator.net:5998]
World | Info | LoadDatabaseConnections Connecting to MySQL [eqemu@mariadb:3306]
World | Info | Connect Connected to database [default] [peq] @ [mariadb:3306]
World | Info | LoadLogDatabaseSettings Loaded [84] log categories
World | Info | DatabaseLoadRoutines Checking Database Conversions
World | Info | LoadRules Loaded [1,001] rules(s) in rule_set [default] id [1]
World | Info | CheckVersionsUpToDate ----------------------------------------------------------------------
World | Info | CheckVersionsUpToDate Server | database [9328] binary [9328] up to date
World | Info | CheckVersionsUpToDate Bots | database [0] binary [9054] checking updates
World | Info | CheckVersionsUpToDate Config | [server.auto_database_updates] [true]
World | Info | CheckVersionsUpToDate ----------------------------------------------------------------------
World | Info | UpdateManifest [9035] [missing] | [2022_12_04_bot_archery.sql]
World | Info | UpdateManifest [9036] [ok] | [2023_01_19_drop_bot_views.sql]
World | Info | UpdateManifest [9037] [ok] | [2023_01_22_add_name_index.sql]
World | Info | UpdateManifest [9038] [ok] | [2023_02_16_add_caster_range.sql]
World | Info | UpdateManifest [9039] [ok] | [2023_03_31_remove_bot_groups.sql]
World | Info | UpdateManifest [9040] [missing] | [2023_11_16_bot_starting_items.sql]
World | Info | UpdateManifest [9041] [missing] | [2023_12_04_bot_timers.sql]
World | Info | UpdateManifest [9042] [ok] | [2024_01_27_delete_bot_foreign_keys.sql]
World | Info | UpdateManifest [9043] [missing] | [2024_02_18_bot_starting_items_augments.sql]
World | Info | UpdateManifest [9044] [missing] | [2024_04_23_bot_extra_haste.sql]
World | Info | UpdateManifest [9045] [missing] | [2024_08_05_bot_spells_entries_unsigned_spell_id.sq l]
World | Info | UpdateManifest [9046] [missing] | [2024_05_18_bot_settings.sql]
World | Info | UpdateManifest [9047] [ok] | [2024_05_18_bot_update_spell_types.sql]
World | Info | UpdateManifest [9048] [missing] | [2024_05_18_bot_fear_spell_type.sql]
World | Info | UpdateManifest [9049] [ok] | [2024_05_18_correct_bot_spell_entries_types.sql]
World | Info | UpdateManifest [9050] [missing] | [2024_11_26_add_commanded_spelltypes.sql]
World | Info | UpdateManifest [9051] [missing] | [2024_11_26_remove_sk_icb.sql]
World | Info | UpdateManifest [9052] [missing] | [2024_12_15_bot_blocked_buffs.sql]
World | Info | UpdateManifest [9053] [missing] | [2024_12_26_discipline_inserts.sql]
World | Info | UpdateManifest [9054] [missing] | [2024_12_29_discipline_subtypes_inserts.sql]
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | UpdateManifest Automatically backing up database before applying updates
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | DatabaseDump MySQL installed [mysql Ver 15.1 Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper]
World | Info | DatabaseDump Database [peq] Host [mariadb] Username [eqemu]
World | Info | DatabaseDump Backing up database [mysqldump --defaults-extra-file=login.my.cnf peq --allow-keywords --extended-insert --max-allowed-packet=1G --net-buffer-length=32704 --skip-lock-tables > backups/peq-2025-12-17.sql]
World | Info | DatabaseDump This can take a few minutes depending on the size of your database
World | Info | DatabaseDump LOADING... PLEASE WAIT...
World | Info | DatabaseDump Database dump created at [backups/peq-2025-12-17.sql]
World | Info | DatabaseDump Compression requested. Compressing dump [backups/peq-2025-12-17.sql]
World | Info | DatabaseDump Compressed dump created at [backups/peq-2025-12-17.tar.gz]
World | Info | UpdateManifest ----------------------------------------------------------------------
World | Info | UpdateManifest Running database migrations. Please wait...
World | Info | UpdateManifest ----------------------------------------------------------------------
World | MySQL Erro | QueryDatabaseMulti [Table 'peq.bot_data' doesn't exist] (1146) query [ALTER TABLE `bot_data`ADD COLUMN `archery_setting` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0' AFTER `enforce_spell_settings`;]
World | Error | UpdateManifest (#1146) [Table 'peq.bot_data' doesn't exist]
World | Info | UpdateManifest Required database update failed. This could be a problem
World | Info | UpdateManifest Skipping update [9035] [2022_12_04_bot_archery.sql]
World | Info | UpdateManifest [9035] [2022_12_04_bot_archery.sql] [error]
World | Error | UpdateManifest Fatal | Database migration [2022_12_04_bot_archery.sql] failed to run
World | Error | UpdateManifest Fatal | Shutting down
exit status 1

I understand the words on the screen, but I don't know how to resolve the issue. Please help.

ajinaniyan · #2 Today, 08:13 AM

This is happening because your database schema doesn’t match the server binary you’re running. You rebuilt the server using the stable 23.10.3 binaries, but your database is missing required bot tables (like bot_data), so the automatic migrations fail and the world server shuts down.

In short: the server expects bot tables that were never created.

The fix is straightforward: re-import the correct base database that includes bots for your server version, or manually load the bot SQL files. The easiest and safest option is to drop the peq database, recreate it, then import the latest PEQ database dump that includes bots, followed by the bots.sql file, and then start the world server again so migrations can complete cleanly. Mixing dev and stable versions without a matching database will always cause this kind of error.

If the database got partially corrupted from repeated failed migrations, repairing it first with a tool like Stellar Repair for MySQL can help before reimporting, but in your case a clean database rebuild is usually enough.