View Single Post
  #8  
Old 09-07-2015, 02:26 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

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.

Last edited by Akkadius; 09-07-2015 at 02:44 PM..
Reply With Quote