World.exe missing database updates

[phentop]

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.

[phentop]

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

>

[Akkadius]

Originally Posted by phentop

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.

Try posting the console output

[Akkadius]

Originally Posted by phentop

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

>

Run option 3 twice and you should be fine.

[phentop]

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

[Cilraaz]

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'?

[phentop]

Server is still locked. eqemu_config is set to default for the locked-unlocked.

[phentop]

Originally Posted by Cilraaz

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'?

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.

[Cilraaz]

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.

[phentop]

Originally Posted by Cilraaz

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.

Where do I look to find my database?

[Cilraaz]

If you don't know the basics of MySQL, why are you attempting to set up a server?

[Uleat]

What guide did you use to set up your server?

[cannon]

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.