World.exe missing database updates
I'm able to start my server and see it running on the server list in locked mode.
My world command window shows: Binary Revision / local: (9087 / 1000) You have missing database updates, type 1 or 2 to backup your database before running them as recommended... It lists 1-10, 20, and Q I went through each. and restart the server, but it shows the same message. If I run zone from the command prompt the locked status will go away, but either way I cannot log into the server. It loads to the black screen before the load screen and hangs. The command windows that are open are: eqlaunch (with no script shown) ucs (with script) queryserv (with script) and world (with the option list previously posted) I posted earlier today about a zlib1.dll error, but that seems to be gone. Any help, again, is appreciated. |
[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.1.3 [World Server] Added loginserver login.eqemulator.net:5998 [World Server] Connecting to MySQL... [World Server] HTTP world service disabled. [World Server] Checking Database Conversions.. [Upgrade Script] No script update necessary Perl Version is 5.12.3 ================================================== ========== EQEmu: Automatic Upgrade Check ================================================== ========== (Windows) MySQL is in system path Path = C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin/mysql ================================================== ========== Binary Revision / Local: (9087 / 1000) You have missing database updates, type 1 or 2 to backup your database before ru nning them as recommended... ================================================== ========== #::: EQEmu Update Utility Menu: (eqemu_update.pl) ================================================== ========== 1) [Backup Database] :: (Saves to Backups folder) 2) [Backup Database Compressed] :: (Saves to Backups folder) 3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates 4) [EQEmu DB Bots Schema] Check for Bot REQUIRED database updates... (Must have bots enabled) 5) [OPCodes] :: Download latest opcodes for each EQ Client 6) [Maps] :: Download latest map and water files 7) [Plugins (Perl)] :: Download latest Perl plugins 8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates 9) [LUA Modules] :: Download latest LUA Modules (Required for Lua) 10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This ov erwrites existing data) 20) [Update the updater] Force update this script (Redownload) 0) Exit Enter numbered option and press enter... > |
Quote:
|
Quote:
|
Are a ton of MySQL Errors common? and for it to constantly get new TCP's?
world capture: (its still getting new TCP's) [World Server] Loading server configuration.. [World Server] CURRENT_VERSION: 1.1.3 [World Server] Added loginserver login.eqemulator.net:5998 [World Server] Connecting to MySQL... [Status] Starting File Log 'logs/world_2892.log' [World Server] HTTP world service disabled. [World Server] Checking Database Conversions.. [MySQL Error] 1146: Table 'peq.vwbotcharactermobs' doesn't exist SHOW CREATE VIEW `vwBotCharacterMobs` [MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist SHOW COLUMNS FROM `character_corpses` LIKE 'data' [Upgrade Script] No script update necessary Perl Version is 5.12.3 ================================================== ========== EQEmu: Automatic Upgrade Check ================================================== ========== (Windows) MySQL is in system path Path = C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin/mysql ================================================== ========== Binary Revision / Local: (9087 / 9087) Database up to Date: Continuing World Bootup... ================================================== ========== [World Server] Loading variables.. [MySQL Error] 1146: Table 'peq.variables' doesn't exist SELECT varname, value, unix_timestamp() FROM variables where unix_timestamp(ts) >= 0 [World Server] Loading zones.. [World Server] Clearing groups.. [MySQL Error] 1146: Table 'peq.group_leaders' doesn't exist DELETE from group_leaders Unable to clear group leaders: #1146: Table 'peq.group_leaders' doesn't exist [MySQL Error] 1146: Table 'peq.group_id' doesn't exist DELETE FROM `group_id` [World Server] Clearing raids.. [MySQL Error] 1146: Table 'peq.raid_members' doesn't exist delete from raid_members Unable to clear raids: #1146: Table 'peq.raid_members' doesn't exist [MySQL Error] 1146: Table 'peq.raid_details' doesn't exist delete from raid_details Unable to clear raid details: #1146: Table 'peq.raid_details' doesn't exist [World Server] Clearing inventory snapshots.. [World Server] Loading items.. [World Server] Loading skill caps.. [World Server] Loading guilds.. [MySQL Error] 1146: Table 'peq.guilds' doesn't exist SELECT id, name, leader, minstatus, motd, motd_setter,channel,url FROM guilds [MySQL Error] 1146: Table 'peq.rule_sets' doesn't exist SELECT ruleset_id FROM rule_sets WHERE name='default' [World Server] No rule set configured, using default rules [World Server] Clearing temporary merchant lists.. [MySQL Error] 1146: Table 'peq.merchantlist_temp' doesn't exist DELETE FROM merchantlist_temp [World Server] Loading EQ time of day.. [World Server] Loading launcher list.. [MySQL Error] 1146: Table 'peq.launcher' doesn't exist SELECT name FROM launcher [Error] WorldDatabase::GetLauncherList: #1146: Table 'peq.launcher' doesn't exis t [World Server] Reboot zone modes OFF [MySQL Error] 1146: Table 'peq.character_corpses' doesn't exist UPDATE `character_corpses` SET `is_buried` = 1 WHERE `is_buried` = 0 AND (UNIX_ TIMESTAMP() - UNIX_TIMESTAMP(time_of_death)) > 10800 AND NOT time_of_death = 0 [World Server] Deleted -1 stale player corpses from database [World Server] Loading adventures... [MySQL Error] 1146: Table 'peq.adventure_stats' doesn't exist SELECT ch.name, ch.id, adv_stats.* FROM adventure_stats AS adv_stats LEFT JOIN `character_data` AS ch ON adv_stats.player_id = ch.id; [World Server] Purging expired instances [World Server] Loading char create info... [World Server] Zone (TCP) listener started. [World Server] Client (UDP) listener started. [World Server] New TCP connection from 127.0.0.1:52358 [World Server] New TCP connection from 127.0.0.1:52361 [World Server] New TCP connection from 127.0.0.1:52362 [World Server] New TCP connection from 127.0.0.1:52363 [World Server] New TCP connection from 127.0.0.1:52364 [World Server] New TCP connection from 127.0.0.1:52366 [World Server] New TCP connection from 127.0.0.1:52367 [World Server] New TCP connection from 127.0.0.1:52368 [World Server] New TCP connection from 127.0.0.1:52369 [World Server] New TCP connection from 127.0.0.1:52370 [World Server] New TCP connection from 127.0.0.1:52371 [World Server] New TCP connection from 127.0.0.1:52372 [World Server] New TCP connection from 127.0.0.1:52373 [World Server] New TCP connection from 127.0.0.1:52374 [World Server] New TCP connection from 127.0.0.1:52375 [World Server] New TCP connection from 127.0.0.1:52376 |
The new TCP connections are your zone servers connecting to the world server. The SQL errors are showing multiple tables that don't exist (and should). I'd dump the database and source it again from scratch, then run the updater script again.
Edit: Actually, did you source the SQL into a database named something other than 'peq'? |
Server is still locked. eqemu_config is set to default for the locked-unlocked.
|
Quote:
If it wasn't part of the "How to set up a server" listed on the homepage here. I didn't do it or would know how to. |
None of the basic tables exist in your database. Just based on what you've posted, tables like rule_sets, character_corpses, guilds, and launcher don't exist. Your server won't work properly without a database. Double-check your database name and see what tables exist within the database.
|
Quote:
|
If you don't know the basics of MySQL, why are you attempting to set up a server?
|
What guide did you use to set up your server?
|
I was the same way when I started, don't be discouraged. Try going through this setup.
http://wiki.eqemulator.org/p?Complet...er_Setup_Guide Best place to view your database is through MySql or HeidiSQL. |
| All times are GMT -4. The time now is 10:49 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.