|
|
|
 |
|
|
 |
|
 |
 |
|
 |
 |
|
 |
|
| Support::Linux Servers Support forum for Linux EQEMu users. |
 |
|
 |
01-18-2015, 03:43 PM
|
|
Hill Giant
|
|
Join Date: Sep 2005
Posts: 114
|
|
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
|
 |
|
 |
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 11:26 PM.
|
|
 |
|
 |
|
|
|
 |
|
 |
|
 |
Linear Mode
