EQEmulator Forums - missing some sql tables?

EDIT READ BOTTOM

ive looked at the sql files i have, and these tables are not in them, ive ready the ./world helps with that but it doesnt seem to be?

now this is a longone

now ive inserted the sql files playertables and peqbeta am i missing a file somewhere?

world:
Code:
[ro_herc@u18052092 ~]$ cd EQ

[ro_herc@u18052092 EQ]$ cd eqemu

[ro_herc@u18052092 eqemu]$ cd server

[ro_herc@u18052092 server]$ ./world

[Status] Using database 'eq' at 74.208.173.41:3306



[MYSQL ERR] 1146: Table 'eq.character_corpses' doesn't exist [Query]:

SHOW COLUMNS FROM `character_corpses` LIKE 'data'



Pulling down automatic database upgrade script...



--2015-01-18 14:29:57--  https://raw.githubusercontent.com/EQEmu/Server/master/u                                             tils/scripts/db_update.pl

Resolving raw.githubusercontent.com... 23.235.40.133

Connecting to raw.githubusercontent.com|23.235.40.133|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 14171 (14K) [text/plain]

Saving to: “db_update.pl”



100%[======================================>] 14,171      --.-K/s   in 0.01s



2015-01-18 14:29:57 (1.03 MB/s) - “db_update.pl” saved [14171/14171]



No update necessary

Perl Version is 5.10.1

============================================================

           EQEmu: Automatic Database Upgrade Check

============================================================

        Operating System is: linux

        (Linux) MySQL is in system path

        Path = /usr/bin/mysql

============================================================

        Binary Database Version: (9066)

        Local Database Version: (1000)



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



Missing DB Update 9066 '2014_12_31_npc_types_default_values_update.sql'

        URL:    https://raw.githubusercontent.com/EQEmu/Server/master/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 'eq.vwMercNpcTypes' doesn't exist

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

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

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

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

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

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

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

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

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

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

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

ERROR 1146 (42S02) at line 1: Table 'eq.raid_members' doesn't exist

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

Missing DB Update 9055 '2014_10_30_special_abilities_null.sql'

        URL:    https://raw.githubusercontent.com/EQEmu/Server/master/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 'eq.raid_leaders' doesn't exist

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

ERROR 1146 (42S02) at line 1: Table 'eq.group_leaders' doesn't exist

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

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

ERROR 1146 (42S02) at line 1: Table 'eq.raid_details' doesn't exist

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

ERROR 1146 (42S02) at line 1: Table 'eq.account' doesn't exist

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

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_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

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

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'

ERROR 1146 (42S02) at line 1: Table 'eq.character_buffs' doesn't exist

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

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'

ERROR 1146 (42S02) at line 1: Table 'eq.character_pet_info' doesn't exist

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

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'

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

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

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... (23)

        4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the database)

        5) OPCodes - Download latest opcodes from repository

        0) Exit



> 3

Running Update: 9006 - 2013_05_05_Account_Flags.sql

Running Update: 9007 - 2013_05_05_Item_Tick.sql

Running Update: 9018 - 2014_01_09_PreservePetSize.sql

ERROR 1146 (42S02) at line 1: Table 'eq.character_pet_info' doesn't exist

Running Update: 9027 - 2014_02_20_buff_update.sql

ERROR 1146 (42S02) at line 2: Table 'eq.character_buffs' doesn't exist

ERROR 1054 (42S22) at line 3: Unknown column 'DeathSaveSuccessChance' in 'merc_buffs'

ERROR 1146 (42S02) at line 4: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 6: Table 'eq.character_buffs' doesn't exist

ERROR 1054 (42S22) at line 7: Unknown column 'CasterAARank' in 'merc_buffs'

ERROR 1146 (42S02) at line 8: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 10: Table 'eq.character_buffs' doesn't exist

ERROR 1060 (42S21) at line 11: Duplicate column name 'caston_y'

ERROR 1146 (42S02) at line 12: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 14: Table 'eq.character_buffs' doesn't exist

ERROR 1060 (42S21) at line 15: Duplicate column name 'caston_z'

ERROR 1146 (42S02) at line 16: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 18: Table 'eq.character_buffs' doesn't exist

ERROR 1060 (42S21) at line 19: Duplicate column name 'ExtraDIChance'

ERROR 1146 (42S02) at line 20: Table 'eq.botbuffs' doesn't exist

ERROR 1054 (42S22) at line 22: Unknown column 'not_reflectable' in 'spells_new'

Running Update: 9045 - 2014_08_23_Complete_QueryServ_Table_Structures.sql

Running Update: 9046 - 2014_08_23_player_events_and_player_aa_rate_hourly.sql

Running Update: 9050 - 2014_09_20_ban_messages.sql

ERROR 1146 (42S02) at line 1: Table 'eq.account' doesn't exist

Running Update: 9051 - 2014_10_11_RaidMOTD.sql

ERROR 1146 (42S02) at line 1: Table 'eq.raid_details' doesn't exist

Running Update: 9052 - 2014_10_13_RaidLeadership.sql

Running Update: 9053 - 2014_10_18_group_mentor.sql

ERROR 1146 (42S02) at line 1: Table 'eq.group_leaders' doesn't exist

ERROR 1146 (42S02) at line 2: Table 'eq.group_leaders' doesn't exist

Running Update: 9054 - 2014_10_19_raid_group_mentor.sql

Running Update: 9055 - 2014_10_30_special_abilities_null.sql

Running Update: 9056 - 2014_11_08_RaidMembers.sql

ERROR 1146 (42S02) at line 1: Table 'eq.raid_members' doesn't exist

Running Update: 9057 - 2014_11_13_spells_new_updates.sql

Running Update: 9058 - 2014_11_26_InventoryTableUpdate.sql

ERROR 1146 (42S02) at line 2: Table 'eq.inventory' doesn't exist

Running Update: 9059 - 2014_12_01_mercs_table_update.sql

Running Update: 9060 - 2014_12_09_items_table_update.sql

Running Update: 9061 - 2014_12_13_inventory_table_update.sql

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

Running Update: 9062 - 2014_12_15_multiple_table_updates.sql

ERROR 1146 (42S02) at line 7: Table 'eq.inventory' doesn't exist

ERROR 1146 (42S02) at line 10: Table 'eq.sharedbank' doesn't exist

ERROR 1146 (42S02) at line 13: Table 'eq.object_contents' doesn't exist

ERROR 1146 (42S02) at line 16: Table 'eq.character_corpse_items' doesn't exist

Running Update: 9063 - 2014_12_24_npc_types_update.sql

Running Update: 9064 - 2014_12_24_npc_types_table_update.sql

Running Update: 9065 - 2014_12_26_merc_weaponinfo_table_update.sql

ERROR 1051 (42S02) at line 2: Unknown table 'vwMercNpcTypes'

Running Update: 9066 - 2014_12_31_npc_types_default_values_update.sql

Reading manifest...



DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'

DB up to date with: 9065 - '2014_12_26_merc_weaponinfo_table_update.sql'

DB up to date with: 9064 - '2014_12_24_npc_types_table_update.sql'

DB up to date with: 9063 - '2014_12_24_npc_types_update.sql'

DB up to date with: 9062 - '2014_12_15_multiple_table_updates.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

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

DB up to date with: 9060 - '2014_12_09_items_table_update.sql'

DB up to date with: 9059 - '2014_12_01_mercs_table_update.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

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

DB up to date with: 9057 - '2014_11_13_spells_new_updates.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.raid_members' doesn't exist

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

DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'

DB up to date with: 9054 - '2014_10_19_raid_group_mentor.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.group_leaders' doesn't exist

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

DB up to date with: 9052 - '2014_10_13_RaidLeadership.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.raid_details' doesn't exist

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

ERROR 1146 (42S02) at line 1: Table 'eq.account' doesn't exist

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

DB up to date with: 9048 - '2014_09_09_attack_delay.sql'

DB up to date with: 9046 - '2014_08_23_player_events_and_player_aa_rate_hourly.sql'

DB up to date with: 9045 - '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'

ERROR 1146 (42S02) at line 1: Table 'eq.character_buffs' doesn't exist

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

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'

ERROR 1146 (42S02) at line 1: Table 'eq.character_pet_info' doesn't exist

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

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... (8)

        4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the database)

        5) OPCodes - Download latest opcodes from repository

        0) Exit



> 3

Running Update: 9018 - 2014_01_09_PreservePetSize.sql

ERROR 1146 (42S02) at line 1: Table 'eq.character_pet_info' doesn't exist

Running Update: 9027 - 2014_02_20_buff_update.sql

ERROR 1146 (42S02) at line 2: Table 'eq.character_buffs' doesn't exist

ERROR 1054 (42S22) at line 3: Unknown column 'DeathSaveSuccessChance' in 'merc_buffs'

ERROR 1146 (42S02) at line 4: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 6: Table 'eq.character_buffs' doesn't exist

ERROR 1054 (42S22) at line 7: Unknown column 'CasterAARank' in 'merc_buffs'

ERROR 1146 (42S02) at line 8: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 10: Table 'eq.character_buffs' doesn't exist

ERROR 1060 (42S21) at line 11: Duplicate column name 'caston_y'

ERROR 1146 (42S02) at line 12: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 14: Table 'eq.character_buffs' doesn't exist

ERROR 1060 (42S21) at line 15: Duplicate column name 'caston_z'

ERROR 1146 (42S02) at line 16: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 18: Table 'eq.character_buffs' doesn't exist

ERROR 1060 (42S21) at line 19: Duplicate column name 'ExtraDIChance'

ERROR 1146 (42S02) at line 20: Table 'eq.botbuffs' doesn't exist

ERROR 1054 (42S22) at line 22: Unknown column 'not_reflectable' in 'spells_new'

Running Update: 9050 - 2014_09_20_ban_messages.sql

ERROR 1146 (42S02) at line 1: Table 'eq.account' doesn't exist

Running Update: 9051 - 2014_10_11_RaidMOTD.sql

ERROR 1146 (42S02) at line 1: Table 'eq.raid_details' doesn't exist

Running Update: 9053 - 2014_10_18_group_mentor.sql

ERROR 1146 (42S02) at line 1: Table 'eq.group_leaders' doesn't exist

ERROR 1146 (42S02) at line 2: Table 'eq.group_leaders' doesn't exist

Running Update: 9056 - 2014_11_08_RaidMembers.sql

ERROR 1146 (42S02) at line 1: Table 'eq.raid_members' doesn't exist

Running Update: 9058 - 2014_11_26_InventoryTableUpdate.sql

ERROR 1146 (42S02) at line 2: Table 'eq.inventory' doesn't exist

Running Update: 9061 - 2014_12_13_inventory_table_update.sql

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

Reading manifest...



DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'

DB up to date with: 9065 - '2014_12_26_merc_weaponinfo_table_update.sql'

DB up to date with: 9064 - '2014_12_24_npc_types_table_update.sql'

DB up to date with: 9063 - '2014_12_24_npc_types_update.sql'

DB up to date with: 9062 - '2014_12_15_multiple_table_updates.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

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

DB up to date with: 9060 - '2014_12_09_items_table_update.sql'

DB up to date with: 9059 - '2014_12_01_mercs_table_update.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

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

DB up to date with: 9057 - '2014_11_13_spells_new_updates.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.raid_members' doesn't exist

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

DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'

DB up to date with: 9054 - '2014_10_19_raid_group_mentor.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.group_leaders' doesn't exist

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

DB up to date with: 9052 - '2014_10_13_RaidLeadership.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.raid_details' doesn't exist

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

ERROR 1146 (42S02) at line 1: Table 'eq.account' doesn't exist

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

DB up to date with: 9048 - '2014_09_09_attack_delay.sql'

DB up to date with: 9046 - '2014_08_23_player_events_and_player_aa_rate_hourly.sql'

DB up to date with: 9045 - '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'

ERROR 1146 (42S02) at line 1: Table 'eq.character_buffs' doesn't exist

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

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'

ERROR 1146 (42S02) at line 1: Table 'eq.character_pet_info' doesn't exist

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

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... (8)

        4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the database)

        5) OPCodes - Download latest opcodes from repository

        0) Exit



> 3

Running Update: 9018 - 2014_01_09_PreservePetSize.sql

ERROR 1146 (42S02) at line 1: Table 'eq.character_pet_info' doesn't exist

Running Update: 9027 - 2014_02_20_buff_update.sql

ERROR 1146 (42S02) at line 2: Table 'eq.character_buffs' doesn't exist

ERROR 1054 (42S22) at line 3: Unknown column 'DeathSaveSuccessChance' in 'merc_buffs'

ERROR 1146 (42S02) at line 4: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 6: Table 'eq.character_buffs' doesn't exist

ERROR 1054 (42S22) at line 7: Unknown column 'CasterAARank' in 'merc_buffs'

ERROR 1146 (42S02) at line 8: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 10: Table 'eq.character_buffs' doesn't exist

ERROR 1060 (42S21) at line 11: Duplicate column name 'caston_y'

ERROR 1146 (42S02) at line 12: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 14: Table 'eq.character_buffs' doesn't exist

ERROR 1060 (42S21) at line 15: Duplicate column name 'caston_z'

ERROR 1146 (42S02) at line 16: Table 'eq.botbuffs' doesn't exist

ERROR 1146 (42S02) at line 18: Table 'eq.character_buffs' doesn't exist

ERROR 1060 (42S21) at line 19: Duplicate column name 'ExtraDIChance'

ERROR 1146 (42S02) at line 20: Table 'eq.botbuffs' doesn't exist

ERROR 1054 (42S22) at line 22: Unknown column 'not_reflectable' in 'spells_new'

Running Update: 9050 - 2014_09_20_ban_messages.sql

ERROR 1146 (42S02) at line 1: Table 'eq.account' doesn't exist

Running Update: 9051 - 2014_10_11_RaidMOTD.sql

ERROR 1146 (42S02) at line 1: Table 'eq.raid_details' doesn't exist

Running Update: 9053 - 2014_10_18_group_mentor.sql

ERROR 1146 (42S02) at line 1: Table 'eq.group_leaders' doesn't exist

ERROR 1146 (42S02) at line 2: Table 'eq.group_leaders' doesn't exist

Running Update: 9056 - 2014_11_08_RaidMembers.sql

ERROR 1146 (42S02) at line 1: Table 'eq.raid_members' doesn't exist

Running Update: 9058 - 2014_11_26_InventoryTableUpdate.sql

ERROR 1146 (42S02) at line 2: Table 'eq.inventory' doesn't exist

Running Update: 9061 - 2014_12_13_inventory_table_update.sql

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

Reading manifest...



DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'

DB up to date with: 9065 - '2014_12_26_merc_weaponinfo_table_update.sql'

DB up to date with: 9064 - '2014_12_24_npc_types_table_update.sql'

DB up to date with: 9063 - '2014_12_24_npc_types_update.sql'

DB up to date with: 9062 - '2014_12_15_multiple_table_updates.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

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

DB up to date with: 9060 - '2014_12_09_items_table_update.sql'

DB up to date with: 9059 - '2014_12_01_mercs_table_update.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.inventory' doesn't exist

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

DB up to date with: 9057 - '2014_11_13_spells_new_updates.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.raid_members' doesn't exist

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

DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'

DB up to date with: 9054 - '2014_10_19_raid_group_mentor.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.group_leaders' doesn't exist

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

DB up to date with: 9052 - '2014_10_13_RaidLeadership.sql'

ERROR 1146 (42S02) at line 1: Table 'eq.raid_details' doesn't exist

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

ERROR 1146 (42S02) at line 1: Table 'eq.account' doesn't exist

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

DB up to date with: 9048 - '2014_09_09_attack_delay.sql'

DB up to date with: 9046 - '2014_08_23_player_events_and_player_aa_rate_hourly.sql'

DB up to date with: 9045 - '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'

ERROR 1146 (42S02) at line 1: Table 'eq.character_buffs' doesn't exist

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

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'

ERROR 1146 (42S02) at line 1: Table 'eq.character_pet_info' doesn't exist

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

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... (8)

        4) AAs - Get Latest AA's from PEQ (This deletes AA's already in the database)

        5) OPCodes - Download latest opcodes from repository

        0) Exit



>





[MYSQL ERR] 1146: Table 'eq.group_leaders' doesn't exist [Query]:

DELETE from group_leaders



Unable to clear group leaders: #1146: Table 'eq.group_leaders' doesn't exist



[MYSQL ERR] 1146: Table 'eq.group_id' doesn't exist [Query]:

delete from group_id



Unable to clear groups: #1146: Table 'eq.group_id' doesn't exist



[MYSQL ERR] 1146: Table 'eq.raid_members' doesn't exist [Query]:

delete from raid_members



Unable to clear raids: #1146: Table 'eq.raid_members' doesn't exist



[MYSQL ERR] 1146: Table 'eq.raid_details' doesn't exist [Query]:

delete from raid_details



Unable to clear raid details: #1146: Table 'eq.raid_details' doesn't exist

[Error] Error Loading Items: EQEmu Exception (Shared Memory) in /home/ro_herc/EQ/eqemu/common/memory_mapped_file.cpp at line (112): Could not open the file to find the existing file size.

[Error] Error loading skill caps: EQEmu Exception (Shared Memory) in /home/ro_herc/EQ/eqemu/common/memory_mapped_file.cpp at line (112): Could not open the file to find the existing file size.



[MYSQL ERR] 1146: Table 'eq.guilds' doesn't exist [Query]:

SELECT id, name, leader, minstatus, motd, motd_setter,channel,url FROM guilds





[MYSQL ERR] 1146: Table 'eq.launcher_zones' doesn't exist [Query]:

SELECT zone, port FROM launcher_zones WHERE launcher = 'peq'



[Error] EQLConfig::LoadSettings: #1146: Table 'eq.launcher_zones' doesn't exist



[MYSQL ERR] 1146: Table 'eq.launcher_zones' doesn't exist [Query]:

SELECT zone, port FROM launcher_zones WHERE launcher = 'zone'



[Error] EQLConfig::LoadSettings: #1146: Table 'eq.launcher_zones' doesn't exist



[MYSQL ERR] 1146: Table 'eq.character_corpses' doesn't exist [Query]:

UPDATE `character_corpses` SET `is_buried` = 1 WHERE `is_buried` = 0 AND (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(time_of_death)) > 43200 AND NOT time_of_death = 0





[MYSQL ERR] 1146: Table 'eq.adventure_stats' doesn't exist [Query]:

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;



[Error] Error in AdventureManager:::GetLeaderboardInfo: 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; (#1146: Table 'eq.adventure_stats' doesn't exist)
I fixed that peqbeta_2014-10-11-02:01.tar.gz does not have all the rquired tables, but peqbeta_2014-09-25-02-01.tar.gz does, can login and server looks good everything looks right just one more minor issue with the sql databases.
Quote:
[Status] Found starting location in start_zones

[MYSQL ERR] 1054: Unknown column 'augslot6' in 'field list' [Query]:
SELECT slotid, itemid, charges, color, augslot1, augslot2, augslot3, augslot4, augslot5, augslot6, instnodrop, custom_data, ornamenticon, ornamentidfile, ornament_hero_model FROM inventory INNER JOIN character_data ch ON ch.id = charid WHERE ch.name = 'Spre' AND ch.account_id = 68217 ORDER BY slotid

[Error] GetInventory query 'SELECT slotid, itemid, charges, color, augslot1, augslot2, augslot3, augslot4, augslot5, augslot6, instnodrop, custom_data, ornamenticon, ornamentidfile, ornament_hero_model FROM inventory INNER JOIN character_data ch ON ch.id = charid WHERE ch.name = 'Spre' AND ch.account_id = 68217 ORDER BY slotid' #1054: Unknown column 'augslot6' in 'field list'
[Error] If you got an error related to the 'instnodrop' field, run the following SQL Queries:
alter table inventory add instnodrop tinyint(1) unsigned default 0 not null;

Error loading inventory for Spre

[MYSQL ERR] 1054: Unknown column 'augslot6' in 'field list' [Query]:
SELECT slotid, itemid, charges, color, augslot1, augslot2, augslot3, augslot4, augslot5, augslot6, instnodrop, custom_data, ornamenticon, ornamentidfile, ornament_hero_model FROM inventory INNER JOIN character_data ch ON ch.id = charid WHERE ch.name = 'Spre' AND ch.account_id = 68217 ORDER BY slotid

[Error] GetInventory query 'SELECT slotid, itemid, charges, color, augslot1, augslot2, augslot3, augslot4, augslot5, augslot6, instnodrop, custom_data, ornamenticon, ornamentidfile, ornament_hero_model FROM inventory INNER JOIN character_data ch ON ch.id = charid WHERE ch.name = 'Spre' AND ch.account_id = 68217 ORDER BY slotid' #1054: Unknown column 'augslot6' in 'field list'
[Error] If you got an error related to the 'instnodrop' field, run the following SQL Queries:
alter table inventory add instnodrop tinyint(1) unsigned default 0 not null;

Error loading inventory for Spre
EDIT:

I just fixed it by adding the field to inventory and shared bank