World.exe update

[AdrianD]

Today I will learn `logsys_categories`.

Thanks for the link sir!

[Drazel]

I started over with my server build and peq database build and took the time to write down the couple of errors I got.

Up until part 6 d of the wiki, I have resolved all my problems that I had from previous threads. I had to add the database information to eqemu_config.xml before this part would work.

When I ran world.exe the first time choosing option 3, I got the following Errors:

ERROR 1146 (42502) at line 1: Table 'peq.logsys_categories' doesn't exist
Than the missing DB update number
URL to retrieive it
The saved update.

It did this error for these updates: 9075, 9074, 9070, 9069

2015_02_02_logsys_packet_logs_with_dump.sql
2015_02_01_logsys_packet_logs.sql
2015_01_28_quest_debug_log_category.sql
2015_01_25_logsys_Mercenaries_category.sql


ERROR 1146 (42502) at line 1: Table 'peq.vwmercnpctypes' doesn't exist
Than the missing DB update number
URL to retrieive it
The saved update.

It did this error for this update: 9065

2014_12_26_merc_weaponinfo_table_update.sql


When I ran world.exe the second time choosing option 3, I got the following Errors:

ERROR 1051 (42502) at line 2: Unknown table 'peq.vwmercnpctypes'
ERROR 1054 (42522) at line 5: Unknown column 'd_melee_texture1' in 'merc_weaponinfo'
ERROR 1054 (42522) at line 6: Unknown column 'd_melee_texture2' in 'merc_weaponinfo'

Than when I press 0 and exit at one point it says:

Loading items..
Error: Could not load item data. But ignoring
Loading skill caps..
Error: Could not load skill cap data. But ignoring

than the exit hangs and I have to control-c to get to finish exiting.

Maybe when I ran shared_memory.exe it fixed the two errors I got on exiting world.exe.

The world.exe added the files that got errors to the db_update folder, but I am not sure if it made the correct database entries.

[Akkadius]

Option 3 needs to be ran twice, one to stage the updates and two to apply the updates.

Getting schema errors through the applying process can be completely normal. In your case I don't know enough about what it is you're doing to really know.

The update process should be seamless, regardless of which point you are in your database schema.

Based on some of your updates however, it looks like it is missing the logsys_categories table altogether:

It did this error for these updates: 9075, 9074, 9070, 9069

2015_02_02_logsys_packet_logs_with_dump.sql
2015_02_01_logsys_packet_logs.sql
2015_01_28_quest_debug_log_category.sql
2015_01_25_logsys_Mercenaries_category.sql

Which also tells me it missed this update from the manifest 9068:

https://github.com/EQEmu/Server/blob...e_manifest.txt

What you can do is manually go to your 'db_version' table, set your version to 9000, run the world.exe update again and it SHOULD pick up everything you need in the proper order regardless.

Let me know what happens afterwards.

[Drazel]

I ran option three twice. My server worked and I have even been able to play the game no problem so far. I will see if I can figure out how to change the db_version in the database.

On another note, I had a hardware issue that caused me to do a third install and build of the server. On further notice I missed an error that I believe had been there previously but where it fell in the sequence was missed by me. It went as follows.

It gave this error when I started world.exe after creating the database new before I selected any options:

ERROR 1146 (42502) at line 1: Table 'peq.db_version' doesn't exist.

This message occurred before the others listed in the post detailing my errors when I ran option 3 twice. It happened when I started world.exe for the first time.