UPDATED: Approved Akka's Repack Update 8-26-2015

[epilz]

is it prompting you for updates?

[Jahosphat]

this is what i get.....


Reading manifest...

Missing DB Update 9077 '2015_02_12_zone_gravity.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_02_12_zone_gravity.sql
Saved: db_update/2015_02_12_zone_gravity.sql
Missing DB Update 9076 '2015_02_04_average_coin.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_02_04_average_coin.sql
Saved: db_update/2015_02_04_average_coin.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9075 '2015_02_02_logsys_packet_logs_with_dump.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_02_02_logsys_packet_logs_with_dump.sql
Saved: db_update/2015_02_02_logsys_packet_logs_with_dump.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9074 '2015_02_01_logsys_packet_logs.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_02_01_logsys_packet_logs.sql
Saved: db_update/2015_02_01_logsys_packet_logs.sql
Missing DB Update 9073 '2015_01_31_character_item_recast.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_31_character_item_recast.sql
Saved: db_update/2015_01_31_character_item_recast.sql
Missing DB Update 9072 '2015_01_30_merc_attack_delay.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_30_merc_attack_delay.sql
Saved: db_update/2015_01_30_merc_attack_delay.sql
Missing DB Update 9071 '2015_01_29_merc_stats_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_29_merc_stats_table_update.sql
Saved: db_update/2015_01_29_merc_stats_table_update.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9070 '2015_01_28_quest_debug_log_category.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_28_quest_debug_log_category.sql
Saved: db_update/2015_01_28_quest_debug_log_category.sql
ERROR 1146 (42S02) at line 1: Table 'peq.logsys_categories' doesn't exist
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_25_logsys_Mercenaries_category.sql
Saved: db_update/2015_01_25_logsys_Mercenaries_category.sql
Missing DB Update 9068 '2015_01_15_logsys_categories_table.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2015_01_15_logsys_categories_table.sql
Saved: db_update/2015_01_15_logsys_categories_table.sql
DB up to date with: 9067 - '2015_01_21_npc_types_update.sql'
Missing DB Update 9066 '2014_12_31_npc_types_default_values_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_31_npc_types_default_values_update.sql
Saved: db_update/2014_12_31_npc_types_default_values_update.sql
ERROR 1146 (42S02) at line 1: Table 'peq.vwmercnpctypes' doesn't exist
Missing DB Update 9065 '2014_12_26_merc_weaponinfo_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_26_merc_weaponinfo_table_update.sql
Saved: db_update/2014_12_26_merc_weaponinfo_table_update.sql
Missing DB Update 9064 '2014_12_24_npc_types_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_24_npc_types_table_update.sql
Saved: db_update/2014_12_24_npc_types_table_update.sql
Missing DB Update 9063 '2014_12_24_npc_types_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_24_npc_types_update.sql
Saved: db_update/2014_12_24_npc_types_update.sql
Missing DB Update 9062 '2014_12_15_multiple_table_updates.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_15_multiple_table_updates.sql
Saved: db_update/2014_12_15_multiple_table_updates.sql
Missing DB Update 9061 '2014_12_13_inventory_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_13_inventory_table_update.sql
Saved: db_update/2014_12_13_inventory_table_update.sql
Missing DB Update 9060 '2014_12_09_items_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_09_items_table_update.sql
Saved: db_update/2014_12_09_items_table_update.sql
Missing DB Update 9059 '2014_12_01_mercs_table_update.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_12_01_mercs_table_update.sql
Saved: db_update/2014_12_01_mercs_table_update.sql
Missing DB Update 9058 '2014_11_26_InventoryTableUpdate.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_11_26_InventoryTableUpdate.sql
Saved: db_update/2014_11_26_InventoryTableUpdate.sql
Missing DB Update 9057 '2014_11_13_spells_new_updates.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_11_13_spells_new_updates.sql
Saved: db_update/2014_11_13_spells_new_updates.sql
Missing DB Update 9056 '2014_11_08_RaidMembers.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_11_08_RaidMembers.sql
Saved: db_update/2014_11_08_RaidMembers.sql
Missing DB Update 9055 '2014_10_30_special_abilities_null.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_30_special_abilities_null.sql
Saved: db_update/2014_10_30_special_abilities_null.sql
ERROR 1146 (42S02) at line 1: Table 'peq.raid_leaders' doesn't exist
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_19_raid_group_mentor.sql
Saved: db_update/2014_10_19_raid_group_mentor.sql
Missing DB Update 9053 '2014_10_18_group_mentor.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_18_group_mentor.sql
Saved: db_update/2014_10_18_group_mentor.sql
Missing DB Update 9052 '2014_10_13_RaidLeadership.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_13_RaidLeadership.sql
Saved: db_update/2014_10_13_RaidLeadership.sql
Missing DB Update 9051 '2014_10_11_RaidMOTD.sql'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_10_11_RaidMOTD.sql
Saved: db_update/2014_10_11_RaidMOTD.sql
DB up to date with: 9050 - '2014_09_20_ban_messages.sql'
DB up to date with: 9048 - '2014_09_09_attack_delay.sql'
Missing DB Update 9046 '2014_08_23_player_events_and_player_aa_rate_hourl y.sql'

URL: https://raw.githubusercontent.com/EQ...ter/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

Missing DB Update 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sq l'
URL: https://raw.githubusercontent.com/EQ...ter/utils/sql/
git/required/2014_08_23_Complete_QueryServ_Table_Structures.sql
Saved: db_update/2014_08_23_Complete_QueryServ_Table_Structures.sql
DB up to date with: 9044 - '2014_08_20_merchantlist_probability.sql'
DB up to date with: 9043 - '2014_08_18_spells_new_update.sql'
DB up to date with: 9042 - '2014_08_12_NPC_raid_targets.sql'
DB up to date with: 9041 - '2014_08_02_spells_new.sql'
DB up to date with: 9040 - '2014_07_10_npc_spells.sql'
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
DB up to date with: 9035 - '2014_04_27_AISpellEffects.sql'
DB up to date with: 9034 - '2014_04_25_spawn_events.sql'
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
DB up to date with: 9031 - '2014_04_10_No_Target_With_Hotkey.sql'
DB up to date with: 9030 - '2014_04_04_PhysicalResist.sql'
DB up to date with: 9028 - '2014_02_26_roambox_update.sql'
DB up to date with: 9027 - '2014_02_20_buff_update.sql'
DB up to date with: 9026 - '2014_02_13_spells_new_update.sql'
DB up to date with: 9025 - '2014_02_13_Rename_instance_lockout_tables.sql'
DB up to date with: 9022 - '2014_01_20_Weather.sql'
DB up to date with: 9020 - '2014_01_20_Not_Extendable.sql'
DB up to date with: 9018 - '2014_01_09_PreservePetSize.sql'
DB up to date with: 9017 - '2014_01_08_SpellsNewAdditions.sql'
DB up to date with: 9015 - '2013_12_26_MerchantList_Class_Required.sql'
DB up to date with: 9014 - '2013_11_18_AssistRadius.sql'
DB up to date with: 9012 - '2013_11_07_BaseData.sql'
DB up to date with: 9011 - '2013_10_31_Recipe_disabling.sql'
DB up to date with: 9009 - '2013_10_12_Merc_Special_Abilities.sql'
DB up to date with: 9008 - '2013_07_11_NPC_Special_Abilities.sql'
DB up to date with: 9007 - '2013_05_05_Item_Tick.sql'
DB up to date with: 9006 - '2013_05_05_Account_Flags.sql'
DB up to date with: 9005 - '2013_04_08_Salvage.sql'
DB up to date with: 9002 - '2013_03_1_Merc_Rules_and_Equipment.sql'
DB up to date with: 9001 - '2013_02_25_Impr_HT_LT.sql'
DB up to date with: 9000 - '2013_02_18_Merc_Rules_and_Tables.sql'
DB up to date with: 8000 - '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... (2
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

[Akkadius]

Run 3 again as it instructs exactly in the first post

[Jahosphat]

same thing.. world.exe and is seeing a missing..

Also just went back and deleted everything rebooted, reinstalled the original pack..everything to the T... same results... maybe it's just not meant to be..

Keep getting this when running server.bat

Retrieving latest database manifest...
URL: https://raw.githubusercontent.com/EQ...ter/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...

[mikepitts25]

Did you figure it out? I am wondering if you maybe forgot to update your system Path variable to include the location of the MariaDB/bin folder.

[SoltanHeatwave]

I am having the same problem. I did a path statement in the command prompt and directed it to a file. As you can see Maria DB is in the path statement, but I still get the MariaDB is not recognized. When I copied my path statement, I broke it up for better viewing. It is one long string when it is checked in the environment variables, and when it was sent to the path.txt file I created. I also added the MariaDB 10.0\Data directory manually to the path. I did not have to enter it when I checked the environment variables and selected the path. It was already listed.

Path.txt edited (broken up) for a bit of clarity.

PATH=C:\Windows\system32;C:\Windows\System32\Wbem; C:\Windows\System32\WindowsPowerShell\v1.0\;

C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\MariaDB 10.0;C:\Program Files\MariaDB 10.0\bin;C:\Program Files\MariaDB 10.0\Data;

C:\PERL\site\bin;C:\PERL\bin\;C:\Windows\SysWOW64\ ;C:\Windows;C:\Windows\SysWOW64\Wbem;C:\Windows\Sy sWOW64\WindowsPowerShell\v1.0;

C:\Program Files (x86)\AdminStudio\2014\Common;C:\Program Files\TortoiseGit\bin;C:\Program Files\TortoiseSVN\bin

End of Path.txt file.

When I select option 3 "get updates" this happens.

Missing DB Update 9056 '2014_11_08_RaidMembers.sql'
o URL: (https://raw.githubusercontent.com/EQ...aidMembers.sql)
o Saved: (db_update/2014_11_08_RaidMembers.sql)
'"C:\Program Files\MariaDB 10.0/mysql"' is not recognized as an internal or external command, operable program or batch file.

DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'
'"C:\Program Files\MariaDB 10.0/mysql"' is not recognized as an internal or external command, operable program or batch file.

Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
o URL: (https://raw.githubusercontent.com/EQ...oup_mentor.sql)
o Saved: (db_update/2014_10_19_raid_group_mentor.sql)
'"C:\Program Files\MariaDB 10.0/mysql"' is not recognized as an internal or external command, operable program or batch file.

This continues with all the updates. I don't want to list them all, because it would just clutter everything up.

Just for added info This machine is an Oracle corp Vbox 64 bit Windows 7 Pro machine, set up for 8 gigs ram.

[vsab]

Try making the \bin entry first, sounds like it matched the first instance it saw mentioning mariadb.

C:\Program Files\MariaDB 10.0\bin;C:\Program Files\MariaDB 10.0;C:\Program Files\MariaDB 10.0\Data

To be honest, I didn't think the others are needed, pretty sure my instance only has the \bin dir listed.

C:\Program Files\MariaDB 10.0\bin;

[SoltanHeatwave]

Thanks Vsab, that worked. I changed the bin to the first path it saw, and deleted my Data path. It has been a while since I worked in DOS. If there are other people having this problem maybe they also need to change their path. Thank you again vsab.

[deez2255]

Hello i have downloaded your repack! and when i try to launch the game. my launch window comes up blank and at the top it just says 0:sleeping. can anyone help?

[Uleat]

Have you tried logging into the server?

[Ozium]

did the update and now have error, client can connect but not load char (zone not ready)

[Akkadius]

Originally Posted by Ozium

did the update and now have error, client can connect but not load char (zone not ready)

Run shared memory before running the server

[Ozium]

Originally Posted by Akkadius

Run shared memory before running the server

thanks, running shared mem as admin got past the error, didn't need to do that pre-patch.


had to set zone.exe to admin also for zone to load, has a few errors though. and get zone not rdy when try to go somewhere elce or log in 2nd account and try to load char



edit: overwriting the plugins dir from backup didn't help, manual running of second zone.exe does allow me to port around

[Uleat]

Did you try re-running shared_memory.exe and then starting up your server?


EDIT: I think Akkadius is stalking me... <.< >.>

[Ozium]

update: can't edit so ... just un-installed and started all over, working ok now.