|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
General::General Discussion General discussion about EverQuest(tm), EQEMu, and related topics. Do not post support topics here. |
11-30-2014, 05:03 PM
|
Discordant
|
|
Join Date: Oct 2009
Posts: 312
|
|
Hypopathetically speaking, what's the age limit on a database this will upgrade? I see your in your example pic it starts with updates from 2013, anyone run Zeb/Squeeker/older stuff through it for giggles?
Last edited by Burningsoul; 11-30-2014 at 05:05 PM..
Reason: Clarification and denoobification
|
11-30-2014, 05:08 PM
|
|
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by Burningsoul
Hypopathetically speaking, what's the age limit on a database this will upgrade? I see your in your example pic it starts with updates from 2013, anyone run Zeb/Squeeker/older stuff through it for giggles?
|
Thanks for reminding me, I have the manifest built through all of Github updates. I need to configure the manifest to understand all of the upgrades through SVN.
So technically when I have that done, it should take a super old database all the way up to recent with ease.
Akka's Funhouse for example was just old enough to be a few months ahead of when we started with Git, so I took a 2 year old database and brought it to recent within seconds. Very very nice thing to have.
|
12-09-2014, 10:06 AM
|
Fire Beetle
|
|
Join Date: Jan 2013
Posts: 17
|
|
Just compiled and updated. This worked flawlessly, thank you for adding this feature!
|
01-07-2015, 01:38 AM
|
Hill Giant
|
|
Join Date: May 2003
Location: Tacoma, WA
Posts: 220
|
|
I just wanted to mention that this works GREAT!
For around 20 total hours I tried every guide I could find, every list of steps, to update halls havoc database correctly. Everything I tried would have errors in various sql scripts. Then when it apparently worked, there were things obviously wrong. Things like inventory disappeared completely and all items seemed to be unavailable, yet the items table was full of items. I ended up resurrecting a an old database save from before I started trying to update, and then sourced the data then ran the server.
The automatic updater worked perfectly!
I think there is so much obsolete information out there now, that it is difficult to figure out exactly what to do. This auto-updater is a GREAT feature!
Excellent work, all!
Rick HallsHavoc
|
01-10-2015, 08:50 PM
|
Sarnak
|
|
Join Date: Aug 2009
Location: Somewhere
Posts: 53
|
|
This only works if the database runs on the same host as the world server. Your script grabs host from the config file, but never actually uses the $host variable in your mysql commands.
Since it also auto-downloads db_update.pl I can't even fix the script as my changes get overwritten.
|
01-10-2015, 09:35 PM
|
|
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by iluvseq
This only works if the database runs on the same host as the world server. Your script grabs host from the config file, but never actually uses the $host variable in your mysql commands.
Since it also auto-downloads db_update.pl I can't even fix the script as my changes get overwritten.
|
Run your updates on the world server?
|
01-11-2015, 09:17 AM
|
Sarnak
|
|
Join Date: Aug 2009
Location: Somewhere
Posts: 53
|
|
The world server and the database server are not the same host. You should simply modify the script to add --host="$host" to the various mysql command lines and that would solve the issue.
As a work-around, I've simply set the MYSQL_HOST environment variable prior to running ./world
Even then, the script still doesn't fully update the database (coming from peqbeta_2014-10-11-02:01.sql) as apparently that database is missing some core tables like character_buffs so there are 8 required updates which fail to apply. Not really a problem with the script, per-se, although I'm surprised there isn't a simple empty schema included with the source that one could apply to build an empty, clean and current database so that this whole patch process wouldn't be necessary for a brand new installation. Relying on PEQ to provide the base schema seems silly.
|
01-11-2015, 05:28 PM
|
Hill Giant
|
|
Join Date: May 2003
Location: Tacoma, WA
Posts: 220
|
|
But there are warnings all over the place not to use the October 2014 version of the database. You need to use the September version...
|
01-11-2015, 07:05 PM
|
Sarnak
|
|
Join Date: Aug 2009
Location: Somewhere
Posts: 53
|
|
I have yet to see any of those warnings. Other than the one I posted after I figured it out the hard way.
Regardless, that has nothing to do with the fact that the update_db.pl script parses the configuration file for <host> and then ignores it, only working on localhost unless you set the MYSQL_HOST environment variable.
This is a bug in the script, regardless of which peq db one uses (or even if one doesn't use peq at all!)
|
|
|
|
01-11-2015, 09:16 PM
|
|
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by iluvseq
I have yet to see any of those warnings. Other than the one I posted after I figured it out the hard way.
Regardless, that has nothing to do with the fact that the update_db.pl script parses the configuration file for <host> and then ignores it, only working on localhost unless you set the MYSQL_HOST environment variable.
This is a bug in the script, regardless of which peq db one uses (or even if one doesn't use peq at all!)
|
Wouldn't necessarily call it a bug.
It pulls it down automatically because I've set it that way for a while because at one point the script wasn't capable of checking itself for updates by being passed parameters by the source, could probably change that soon.
Also, why are you using multiple hosts? It's far unecessary unless you actually have load to match the necessity.
98% of the folks who run the script aren't going to need a host option and would simply run it on their database server.
Updated, you're welcome.
https://github.com/EQEmu/Server/comm...a6e1e00cc91214
And
Quote:
Even then, the script still doesn't fully update the database (coming from peqbeta_2014-10-11-02:01.sql) as apparently that database is missing some core tables like character_buffs so there are 8 required updates which fail to apply. Not really a problem with the script, per-se, although I'm surprised there isn't a simple empty schema included with the source that one could apply to build an empty, clean and current database so that this whole patch process wouldn't be necessary for a brand new installation. Relying on PEQ to provide the base schema seems silly.
|
This has to do with PEQ dumps, the schema update does exactly what it needs to do and PEQ missing tables is another issue in itself. I will notify those who oversee those dumps.
|
|
|
|
01-12-2015, 08:49 AM
|
Sarnak
|
|
Join Date: Aug 2009
Location: Somewhere
Posts: 53
|
|
I run on multiple hosts because I have multiple hosts already setup in a variety of roles. My DMZ host (where I run eqemu) doesn't run mysql. I already have it running on an internal host and adding the eqemu database to that makes the most sense for my environment.
|
|
|
|
01-27-2015, 02:28 PM
|
Fire Beetle
|
|
Join Date: Apr 2006
Posts: 5
|
|
This is not working for me and I cant seem to find out what is wrong. It downloads all the database updates but doesn't seem to apply them.
Code:
[World Server] Loading server configuration..
[World Server] CURRENT_VERSION: 1.0.0
[World Server] Added loginserver login.eqemulator.net:5998
[World Server] Connecting to MySQL...
[Status] Starting File Log 'logs/world_4700.log'
[World Server] HTTP world service disabled.
[World Server] Checking Database Conversions..
[Upgrade Script] No script update necessary
Perl Version is 5.12.3
The system cannot find the path specified.
The system cannot find the path specified.
The system cannot find the path specified.
Table 'db_version' does not exists.... Creating...
The system cannot find the path specified.
============================================================
EQEmu: Automatic Upgrade Check
============================================================
(Windows) MySQL is in system path
Path = C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin/mysql
============================================================
Binary Database Version: (9069)
Local Database Version: ()
Retrieving latest database manifest...
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
db_update_manifest.txt
Saved: db_update/db_update_manifest.txt
You have missing database updates, type 1 or 2 to backup your database before ru
nning them as recommended...
Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Check for pending REQUIRED Database updates
Stages updates for automatic upgrade...
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit
> 3
Reading manifest...
The system cannot find the path specified.
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_25_logsys_Mercenaries_category.sql
Saved: db_update/2015_01_25_logsys_Mercenaries_category.sql
The system cannot find the path specified.
Missing DB Update 9068 '2015_01_15_logsys_categories_table.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_15_logsys_categories_table.sql
Saved: db_update/2015_01_15_logsys_categories_table.sql
The system cannot find the path specified.
Missing DB Update 9067 '2015_01_21_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_21_npc_types_update.sql
Saved: db_update/2015_01_21_npc_types_update.sql
The system cannot find the path specified.
DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'
The system cannot find the path specified.
Missing DB Update 9065 '2014_12_26_merc_weaponinfo_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_26_merc_weaponinfo_table_update.sql
Saved: db_update/2014_12_26_merc_weaponinfo_table_update.sql
The system cannot find the path specified.
Missing DB Update 9064 '2014_12_24_npc_types_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_24_npc_types_table_update.sql
Saved: db_update/2014_12_24_npc_types_table_update.sql
The system cannot find the path specified.
Missing DB Update 9063 '2014_12_24_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_24_npc_types_update.sql
Saved: db_update/2014_12_24_npc_types_update.sql
The system cannot find the path specified.
Missing DB Update 9062 '2014_12_15_multiple_table_updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_15_multiple_table_updates.sql
Saved: db_update/2014_12_15_multiple_table_updates.sql
The system cannot find the path specified.
Missing DB Update 9061 '2014_12_13_inventory_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_13_inventory_table_update.sql
Saved: db_update/2014_12_13_inventory_table_update.sql
The system cannot find the path specified.
Missing DB Update 9060 '2014_12_09_items_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_09_items_table_update.sql
Saved: db_update/2014_12_09_items_table_update.sql
The system cannot find the path specified.
Missing DB Update 9059 '2014_12_01_mercs_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_01_mercs_table_update.sql
Saved: db_update/2014_12_01_mercs_table_update.sql
The system cannot find the path specified.
Missing DB Update 9058 '2014_11_26_InventoryTableUpdate.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_26_InventoryTableUpdate.sql
Saved: db_update/2014_11_26_InventoryTableUpdate.sql
The system cannot find the path specified.
Missing DB Update 9057 '2014_11_13_spells_new_updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_13_spells_new_updates.sql
Saved: db_update/2014_11_13_spells_new_updates.sql
The system cannot find the path specified.
Missing DB Update 9056 '2014_11_08_RaidMembers.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_08_RaidMembers.sql
Saved: db_update/2014_11_08_RaidMembers.sql
The system cannot find the path specified.
DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'
The system cannot find the path specified.
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_19_raid_group_mentor.sql
Saved: db_update/2014_10_19_raid_group_mentor.sql
The system cannot find the path specified.
Missing DB Update 9053 '2014_10_18_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_18_group_mentor.sql
Saved: db_update/2014_10_18_group_mentor.sql
The system cannot find the path specified.
Missing DB Update 9052 '2014_10_13_RaidLeadership.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_13_RaidLeadership.sql
Saved: db_update/2014_10_13_RaidLeadership.sql
The system cannot find the path specified.
Missing DB Update 9051 '2014_10_11_RaidMOTD.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_11_RaidMOTD.sql
Saved: db_update/2014_10_11_RaidMOTD.sql
The system cannot find the path specified.
Missing DB Update 9050 '2014_09_20_ban_messages.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_09_20_ban_messages.sql
Saved: db_update/2014_09_20_ban_messages.sql
The system cannot find the path specified.
Missing DB Update 9048 '2014_09_09_attack_delay.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_09_09_attack_delay.sql
Saved: db_update/2014_09_09_attack_delay.sql
The system cannot find the path specified.
Missing DB Update 9046 '2014_08_23_player_events_and_player_aa_rate_hourly.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_23_player_events_and_player_aa_rate_hourly.sql
Saved: db_update/2014_08_23_player_events_and_player_aa_rate_hourly.sql
The system cannot find the path specified.
Missing DB Update 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_23_Complete_QueryServ_Table_Structures.sql
Saved: db_update/2014_08_23_Complete_QueryServ_Table_Structures.sql
The system cannot find the path specified.
Missing DB Update 9044 '2014_08_20_merchantlist_probability.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_20_merchantlist_probability.sql
Saved: db_update/2014_08_20_merchantlist_probability.sql
The system cannot find the path specified.
Missing DB Update 9043 '2014_08_18_spells_new_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_18_spells_new_update.sql
Saved: db_update/2014_08_18_spells_new_update.sql
The system cannot find the path specified.
Missing DB Update 9042 '2014_08_12_NPC_raid_targets.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_12_NPC_raid_targets.sql
Saved: db_update/2014_08_12_NPC_raid_targets.sql
The system cannot find the path specified.
Missing DB Update 9041 '2014_08_02_spells_new.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_02_spells_new.sql
Saved: db_update/2014_08_02_spells_new.sql
The system cannot find the path specified.
Missing DB Update 9040 '2014_07_10_npc_spells.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_07_10_npc_spells.sql
Saved: db_update/2014_07_10_npc_spells.sql
The system cannot find the path specified.
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
The system cannot find the path specified.
Missing DB Update 9035 '2014_04_27_AISpellEffects.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_27_AISpellEffects.sql
Saved: db_update/2014_04_27_AISpellEffects.sql
The system cannot find the path specified.
Missing DB Update 9034 '2014_04_25_spawn_events.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_25_spawn_events.sql
Saved: db_update/2014_04_25_spawn_events.sql
The system cannot find the path specified.
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
The system cannot find the path specified.
Missing DB Update 9031 '2014_04_10_No_Target_With_Hotkey.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_10_No_Target_With_Hotkey.sql
Saved: db_update/2014_04_10_No_Target_With_Hotkey.sql
The system cannot find the path specified.
Missing DB Update 9030 '2014_04_04_PhysicalResist.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_04_PhysicalResist.sql
Saved: db_update/2014_04_04_PhysicalResist.sql
The system cannot find the path specified.
Missing DB Update 9028 '2014_02_26_roambox_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_26_roambox_update.sql
Saved: db_update/2014_02_26_roambox_update.sql
The system cannot find the path specified.
Missing DB Update 9027 '2014_02_20_buff_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_20_buff_update.sql
Saved: db_update/2014_02_20_buff_update.sql
The system cannot find the path specified.
Missing DB Update 9026 '2014_02_13_spells_new_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_13_spells_new_update.sql
Saved: db_update/2014_02_13_spells_new_update.sql
The system cannot find the path specified.
Missing DB Update 9025 '2014_02_13_Rename_instance_lockout_tables.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_13_Rename_instance_lockout_tables.sql
Saved: db_update/2014_02_13_Rename_instance_lockout_tables.sql
The system cannot find the path specified.
Missing DB Update 9022 '2014_01_20_Weather.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_20_Weather.sql
Saved: db_update/2014_01_20_Weather.sql
The system cannot find the path specified.
Missing DB Update 9020 '2014_01_20_Not_Extendable.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_20_Not_Extendable.sql
Saved: db_update/2014_01_20_Not_Extendable.sql
The system cannot find the path specified.
Missing DB Update 9018 '2014_01_09_PreservePetSize.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_09_PreservePetSize.sql
Saved: db_update/2014_01_09_PreservePetSize.sql
The system cannot find the path specified.
Missing DB Update 9017 '2014_01_08_SpellsNewAdditions.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_08_SpellsNewAdditions.sql
Saved: db_update/2014_01_08_SpellsNewAdditions.sql
The system cannot find the path specified.
Missing DB Update 9015 '2013_12_26_MerchantList_Class_Required.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_12_26_MerchantList_Class_Required.sql
Saved: db_update/2013_12_26_MerchantList_Class_Required.sql
The system cannot find the path specified.
Missing DB Update 9014 '2013_11_18_AssistRadius.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_11_18_AssistRadius.sql
Saved: db_update/2013_11_18_AssistRadius.sql
The system cannot find the path specified.
Missing DB Update 9012 '2013_11_07_BaseData.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_11_07_BaseData.sql
Saved: db_update/2013_11_07_BaseData.sql
The system cannot find the path specified.
Missing DB Update 9011 '2013_10_31_Recipe_disabling.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_10_31_Recipe_disabling.sql
Saved: db_update/2013_10_31_Recipe_disabling.sql
The system cannot find the path specified.
Missing DB Update 9009 '2013_10_12_Merc_Special_Abilities.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_10_12_Merc_Special_Abilities.sql
Saved: db_update/2013_10_12_Merc_Special_Abilities.sql
The system cannot find the path specified.
Missing DB Update 9008 '2013_07_11_NPC_Special_Abilities.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_07_11_NPC_Special_Abilities.sql
Saved: db_update/2013_07_11_NPC_Special_Abilities.sql
The system cannot find the path specified.
Missing DB Update 9007 '2013_05_05_Item_Tick.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_05_05_Item_Tick.sql
Saved: db_update/2013_05_05_Item_Tick.sql
The system cannot find the path specified.
Missing DB Update 9006 '2013_05_05_Account_Flags.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_05_05_Account_Flags.sql
Saved: db_update/2013_05_05_Account_Flags.sql
The system cannot find the path specified.
Missing DB Update 9005 '2013_04_08_Salvage.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_04_08_Salvage.sql
Saved: db_update/2013_04_08_Salvage.sql
The system cannot find the path specified.
Missing DB Update 9002 '2013_03_1_Merc_Rules_and_Equipment.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_03_1_Merc_Rules_and_Equipment.sql
Saved: db_update/2013_03_1_Merc_Rules_and_Equipment.sql
The system cannot find the path specified.
Missing DB Update 9001 '2013_02_25_Impr_HT_LT.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_02_25_Impr_HT_LT.sql
Saved: db_update/2013_02_25_Impr_HT_LT.sql
The system cannot find the path specified.
Missing DB Update 9000 '2013_02_18_Merc_Rules_and_Tables.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_02_18_Merc_Rules_and_Tables.sql
Saved: db_update/2013_02_18_Merc_Rules_and_Tables.sql
The system cannot find the path specified.
Missing DB Update 8000 'mercs.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
svn/mercs.sql
Saved: db_update/mercs.sql
Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Run pending REQUIRED updates... (51)
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit
> 3
Running Update: 8000 - mercs.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9000 - 2013_02_18_Merc_Rules_and_Tables.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9001 - 2013_02_25_Impr_HT_LT.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9002 - 2013_03_1_Merc_Rules_and_Equipment.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9005 - 2013_04_08_Salvage.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9006 - 2013_05_05_Account_Flags.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9007 - 2013_05_05_Item_Tick.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9008 - 2013_07_11_NPC_Special_Abilities.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9009 - 2013_10_12_Merc_Special_Abilities.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9011 - 2013_10_31_Recipe_disabling.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9012 - 2013_11_07_BaseData.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9014 - 2013_11_18_AssistRadius.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9015 - 2013_12_26_MerchantList_Class_Required.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9017 - 2014_01_08_SpellsNewAdditions.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9018 - 2014_01_09_PreservePetSize.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9020 - 2014_01_20_Not_Extendable.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9022 - 2014_01_20_Weather.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9025 - 2014_02_13_Rename_instance_lockout_tables.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9026 - 2014_02_13_spells_new_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9027 - 2014_02_20_buff_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9028 - 2014_02_26_roambox_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9030 - 2014_04_04_PhysicalResist.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9031 - 2014_04_10_No_Target_With_Hotkey.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9034 - 2014_04_25_spawn_events.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9035 - 2014_04_27_AISpellEffects.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9040 - 2014_07_10_npc_spells.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9041 - 2014_08_02_spells_new.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9042 - 2014_08_12_NPC_raid_targets.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9043 - 2014_08_18_spells_new_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9044 - 2014_08_20_merchantlist_probability.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9045 - 2014_08_23_Complete_QueryServ_Table_Structures.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9046 - 2014_08_23_player_events_and_player_aa_rate_hourly.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9048 - 2014_09_09_attack_delay.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9050 - 2014_09_20_ban_messages.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9051 - 2014_10_11_RaidMOTD.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9052 - 2014_10_13_RaidLeadership.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9053 - 2014_10_18_group_mentor.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9054 - 2014_10_19_raid_group_mentor.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9056 - 2014_11_08_RaidMembers.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9057 - 2014_11_13_spells_new_updates.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9058 - 2014_11_26_InventoryTableUpdate.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9059 - 2014_12_01_mercs_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9060 - 2014_12_09_items_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9061 - 2014_12_13_inventory_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9062 - 2014_12_15_multiple_table_updates.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9063 - 2014_12_24_npc_types_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9064 - 2014_12_24_npc_types_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9065 - 2014_12_26_merc_weaponinfo_table_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9067 - 2015_01_21_npc_types_update.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9068 - 2015_01_15_logsys_categories_table.sql
The system cannot find the path specified.
The system cannot find the path specified.
Running Update: 9069 - 2015_01_25_logsys_Mercenaries_category.sql
The system cannot find the path specified.
The system cannot find the path specified.
Reading manifest...
The system cannot find the path specified.
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_25_logsys_Mercenaries_category.sql
Saved: db_update/2015_01_25_logsys_Mercenaries_category.sql
The system cannot find the path specified.
Missing DB Update 9068 '2015_01_15_logsys_categories_table.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_15_logsys_categories_table.sql
Saved: db_update/2015_01_15_logsys_categories_table.sql
The system cannot find the path specified.
Missing DB Update 9067 '2015_01_21_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2015_01_21_npc_types_update.sql
Saved: db_update/2015_01_21_npc_types_update.sql
The system cannot find the path specified.
DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'
The system cannot find the path specified.
Missing DB Update 9065 '2014_12_26_merc_weaponinfo_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_26_merc_weaponinfo_table_update.sql
Saved: db_update/2014_12_26_merc_weaponinfo_table_update.sql
The system cannot find the path specified.
Missing DB Update 9064 '2014_12_24_npc_types_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_24_npc_types_table_update.sql
Saved: db_update/2014_12_24_npc_types_table_update.sql
The system cannot find the path specified.
Missing DB Update 9063 '2014_12_24_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_24_npc_types_update.sql
Saved: db_update/2014_12_24_npc_types_update.sql
The system cannot find the path specified.
Missing DB Update 9062 '2014_12_15_multiple_table_updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_15_multiple_table_updates.sql
Saved: db_update/2014_12_15_multiple_table_updates.sql
The system cannot find the path specified.
Missing DB Update 9061 '2014_12_13_inventory_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_13_inventory_table_update.sql
Saved: db_update/2014_12_13_inventory_table_update.sql
The system cannot find the path specified.
Missing DB Update 9060 '2014_12_09_items_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_09_items_table_update.sql
Saved: db_update/2014_12_09_items_table_update.sql
The system cannot find the path specified.
Missing DB Update 9059 '2014_12_01_mercs_table_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_12_01_mercs_table_update.sql
Saved: db_update/2014_12_01_mercs_table_update.sql
The system cannot find the path specified.
Missing DB Update 9058 '2014_11_26_InventoryTableUpdate.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_26_InventoryTableUpdate.sql
Saved: db_update/2014_11_26_InventoryTableUpdate.sql
The system cannot find the path specified.
Missing DB Update 9057 '2014_11_13_spells_new_updates.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_13_spells_new_updates.sql
Saved: db_update/2014_11_13_spells_new_updates.sql
The system cannot find the path specified.
Missing DB Update 9056 '2014_11_08_RaidMembers.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_11_08_RaidMembers.sql
Saved: db_update/2014_11_08_RaidMembers.sql
The system cannot find the path specified.
DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'
The system cannot find the path specified.
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_19_raid_group_mentor.sql
Saved: db_update/2014_10_19_raid_group_mentor.sql
The system cannot find the path specified.
Missing DB Update 9053 '2014_10_18_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_18_group_mentor.sql
Saved: db_update/2014_10_18_group_mentor.sql
The system cannot find the path specified.
Missing DB Update 9052 '2014_10_13_RaidLeadership.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_13_RaidLeadership.sql
Saved: db_update/2014_10_13_RaidLeadership.sql
The system cannot find the path specified.
Missing DB Update 9051 '2014_10_11_RaidMOTD.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_10_11_RaidMOTD.sql
Saved: db_update/2014_10_11_RaidMOTD.sql
The system cannot find the path specified.
Missing DB Update 9050 '2014_09_20_ban_messages.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_09_20_ban_messages.sql
Saved: db_update/2014_09_20_ban_messages.sql
The system cannot find the path specified.
Missing DB Update 9048 '2014_09_09_attack_delay.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_09_09_attack_delay.sql
Saved: db_update/2014_09_09_attack_delay.sql
The system cannot find the path specified.
Missing DB Update 9046 '2014_08_23_player_events_and_player_aa_rate_hourly.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_23_player_events_and_player_aa_rate_hourly.sql
Saved: db_update/2014_08_23_player_events_and_player_aa_rate_hourly.sql
The system cannot find the path specified.
Missing DB Update 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_23_Complete_QueryServ_Table_Structures.sql
Saved: db_update/2014_08_23_Complete_QueryServ_Table_Structures.sql
The system cannot find the path specified.
Missing DB Update 9044 '2014_08_20_merchantlist_probability.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_20_merchantlist_probability.sql
Saved: db_update/2014_08_20_merchantlist_probability.sql
The system cannot find the path specified.
Missing DB Update 9043 '2014_08_18_spells_new_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_18_spells_new_update.sql
Saved: db_update/2014_08_18_spells_new_update.sql
The system cannot find the path specified.
Missing DB Update 9042 '2014_08_12_NPC_raid_targets.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_12_NPC_raid_targets.sql
Saved: db_update/2014_08_12_NPC_raid_targets.sql
The system cannot find the path specified.
Missing DB Update 9041 '2014_08_02_spells_new.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_08_02_spells_new.sql
Saved: db_update/2014_08_02_spells_new.sql
The system cannot find the path specified.
Missing DB Update 9040 '2014_07_10_npc_spells.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_07_10_npc_spells.sql
Saved: db_update/2014_07_10_npc_spells.sql
The system cannot find the path specified.
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
The system cannot find the path specified.
Missing DB Update 9035 '2014_04_27_AISpellEffects.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_27_AISpellEffects.sql
Saved: db_update/2014_04_27_AISpellEffects.sql
The system cannot find the path specified.
Missing DB Update 9034 '2014_04_25_spawn_events.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_25_spawn_events.sql
Saved: db_update/2014_04_25_spawn_events.sql
The system cannot find the path specified.
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
The system cannot find the path specified.
Missing DB Update 9031 '2014_04_10_No_Target_With_Hotkey.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_10_No_Target_With_Hotkey.sql
Saved: db_update/2014_04_10_No_Target_With_Hotkey.sql
The system cannot find the path specified.
Missing DB Update 9030 '2014_04_04_PhysicalResist.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_04_04_PhysicalResist.sql
Saved: db_update/2014_04_04_PhysicalResist.sql
The system cannot find the path specified.
Missing DB Update 9028 '2014_02_26_roambox_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_26_roambox_update.sql
Saved: db_update/2014_02_26_roambox_update.sql
The system cannot find the path specified.
Missing DB Update 9027 '2014_02_20_buff_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_20_buff_update.sql
Saved: db_update/2014_02_20_buff_update.sql
The system cannot find the path specified.
Missing DB Update 9026 '2014_02_13_spells_new_update.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_13_spells_new_update.sql
Saved: db_update/2014_02_13_spells_new_update.sql
The system cannot find the path specified.
Missing DB Update 9025 '2014_02_13_Rename_instance_lockout_tables.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_02_13_Rename_instance_lockout_tables.sql
Saved: db_update/2014_02_13_Rename_instance_lockout_tables.sql
The system cannot find the path specified.
Missing DB Update 9022 '2014_01_20_Weather.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_20_Weather.sql
Saved: db_update/2014_01_20_Weather.sql
The system cannot find the path specified.
Missing DB Update 9020 '2014_01_20_Not_Extendable.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_20_Not_Extendable.sql
Saved: db_update/2014_01_20_Not_Extendable.sql
The system cannot find the path specified.
Missing DB Update 9018 '2014_01_09_PreservePetSize.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_09_PreservePetSize.sql
Saved: db_update/2014_01_09_PreservePetSize.sql
The system cannot find the path specified.
Missing DB Update 9017 '2014_01_08_SpellsNewAdditions.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2014_01_08_SpellsNewAdditions.sql
Saved: db_update/2014_01_08_SpellsNewAdditions.sql
The system cannot find the path specified.
Missing DB Update 9015 '2013_12_26_MerchantList_Class_Required.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_12_26_MerchantList_Class_Required.sql
Saved: db_update/2013_12_26_MerchantList_Class_Required.sql
The system cannot find the path specified.
Missing DB Update 9014 '2013_11_18_AssistRadius.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_11_18_AssistRadius.sql
Saved: db_update/2013_11_18_AssistRadius.sql
The system cannot find the path specified.
Missing DB Update 9012 '2013_11_07_BaseData.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_11_07_BaseData.sql
Saved: db_update/2013_11_07_BaseData.sql
The system cannot find the path specified.
Missing DB Update 9011 '2013_10_31_Recipe_disabling.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_10_31_Recipe_disabling.sql
Saved: db_update/2013_10_31_Recipe_disabling.sql
The system cannot find the path specified.
Missing DB Update 9009 '2013_10_12_Merc_Special_Abilities.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_10_12_Merc_Special_Abilities.sql
Saved: db_update/2013_10_12_Merc_Special_Abilities.sql
The system cannot find the path specified.
Missing DB Update 9008 '2013_07_11_NPC_Special_Abilities.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_07_11_NPC_Special_Abilities.sql
Saved: db_update/2013_07_11_NPC_Special_Abilities.sql
The system cannot find the path specified.
Missing DB Update 9007 '2013_05_05_Item_Tick.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_05_05_Item_Tick.sql
Saved: db_update/2013_05_05_Item_Tick.sql
The system cannot find the path specified.
Missing DB Update 9006 '2013_05_05_Account_Flags.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_05_05_Account_Flags.sql
Saved: db_update/2013_05_05_Account_Flags.sql
The system cannot find the path specified.
Missing DB Update 9005 '2013_04_08_Salvage.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_04_08_Salvage.sql
Saved: db_update/2013_04_08_Salvage.sql
The system cannot find the path specified.
Missing DB Update 9002 '2013_03_1_Merc_Rules_and_Equipment.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_03_1_Merc_Rules_and_Equipment.sql
Saved: db_update/2013_03_1_Merc_Rules_and_Equipment.sql
The system cannot find the path specified.
Missing DB Update 9001 '2013_02_25_Impr_HT_LT.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_02_25_Impr_HT_LT.sql
Saved: db_update/2013_02_25_Impr_HT_LT.sql
The system cannot find the path specified.
Missing DB Update 9000 '2013_02_18_Merc_Rules_and_Tables.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
git/required/2013_02_18_Merc_Rules_and_Tables.sql
Saved: db_update/2013_02_18_Merc_Rules_and_Tables.sql
The system cannot find the path specified.
Missing DB Update 8000 'mercs.sql'
URL: https://raw.githubusercontent.com/EQEmu/Server/master/utils/sql/
svn/mercs.sql
Saved: db_update/mercs.sql
Database Management Menu (Please Select):
1) Backup Database - (Saves to Backups folder)
Ideal to perform before performing updates
2) Backup Database Compressed - (Saves to Backups folder)
Ideal to perform before performing updates
3) Run pending REQUIRED updates... (51)
4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the data
base)
5) OPCodes - Download latest opcodes from repository
0) Exit
>
|
|
|
|
01-27-2015, 02:50 PM
|
Hill Giant
|
|
Join Date: Feb 2013
Posts: 220
|
|
Did you select option 3 at this point?
|
01-27-2015, 03:02 PM
|
Fire Beetle
|
|
Join Date: Apr 2006
Posts: 5
|
|
Yes, I select option 3 and it downloads the updates even if I already have them in the db_update folder. I select option 3 again and I get several "The system cannot find the path specified." errors.
|
01-27-2015, 03:19 PM
|
|
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Little bit more detail please.
What OS?
Have you ran these updates before?
etc.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 12:37 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|