Dbpatcher problems
Posted: Sat Jan 21, 2012 2:00 am
Hello,
I'm on debian linux, with mysql5, dualcore and 2g ram.
I try to update my server to 0.7.1 from 0.6.5
I success to compile new core 0.7.1 from svn but
I have some sql problems with dbpatcher
Where i can found manual sql update since 0.6.5 for make it ?
Thanks for help
I'm on debian linux, with mysql5, dualcore and 2g ram.
I try to update my server to 0.7.1 from 0.6.5
I success to compile new core 0.7.1 from svn but
I have some sql problems with dbpatcher
Code: Select all
===[ New log 'logs/2012-01-21_eq2world_22013.log' started ]===
09:45:42 I DB: Using database 'eq2' at 127.0.0.1
09:45:42 W Misc: Unable to parse the file 'log_config.xml' or it does not exist. Default values will be used
09:45:42 I World: Initializing EQ2Emu Server...
09:45:42 I World: Randomizing World...
09:45:42 I INI: ./LoginServer.ini read.
09:45:42 I Patcher: Connecting to update server...
09:45:42 E Patcher: LoginServer::ConnectToUpdateServer: Resolving IP address: 'Unable to get the host name. Error: Connection timed out'
09:45:42 I World: Loading System Data...
09:45:42 D World: Loading opcodes...
09:45:42 D DBCore: Query Successful, 19 rows returned
09:45:42 D DBCore: Query Successful, 486 rows returned
09:45:42 D DBCore: Query Successful, 486 rows returned
09:45:42 D DBCore: Query Successful, 486 rows returned
09:45:42 D DBCore: Query Successful, 486 rows returned
09:45:42 D DBCore: Query Successful, 486 rows returned
09:45:42 D DBCore: Query Successful, 486 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 487 rows returned
09:45:42 D DBCore: Query Successful, 200 rows returned
09:45:42 D World: Loading structs...
09:45:43 D DBCore: Query Successful, 1 rows returned
09:45:43 D Commands: Loading Commands...
09:45:43 D DBCore: Query Successful, 353 rows returned
09:45:43 D World: Loaded 472 Commands
09:45:43 D DBCore: Query Successful, 48 rows returned
09:45:43 D World: Loaded 48 Subcommands
09:45:43 D Factions: Loading Factions...
09:45:43 D DBCore: Query Successful, 205 rows returned
09:45:43 D Factions: Loaded 205 Factions
09:45:43 D Factions: Loading faction alliances...
09:45:43 D DBCore: Query Successful, 12 rows returned
09:45:43 D Faction: Loaded 12 Alliances: 1 friendly, 11 hostile
09:45:43 D Skills: Loading Skills...
09:45:43 D DBCore: Query Successful, 129 rows returned
09:45:43 D Skills: Loaded 129 Skills
09:45:43 D World: Loading global variables list...
09:45:43 D DBCore: Query Successful, 20 rows returned
09:45:43 D World: Loading visual states list...
09:45:43 D DBCore: Query Successful, 12304 rows returned
09:45:43 D Init: Loaded 12304 visual states
09:45:43 D DBCore: Query Successful, 126 rows returned
09:45:43 D Init: Loaded 126 emote states
09:45:43 D World: Setting World Time to 0/1/3844 0:40...
09:45:43 D World: Loading Vitality Information...
09:45:43 D World: Loading Server Statistics...
09:45:43 D DBCore: Query Successful, 22 rows returned
09:45:43 D World: Setting Server Start Time to now...
09:45:43 D World: Resetting Accepted Connections to 0...
09:45:43 D World: Resetting Active Zones to 0...
09:45:43 D World: Resetting characters online flags...
09:45:43 D DBCore: Query returned no results in RunQuery!
UPDATE characters SET is_online = 0;
09:45:43 D Rules: Loading Rule Sets...
09:45:43 E DBCore: #1146: Table 'eq2.rulesets' doesn't exist
09:45:43 D DBCore: Query returned no results in RunQuery!
SELECT `ruleset_id`,`ruleset_name`
FROM `rulesets`
WHERE `ruleset_active`>0
09:45:43 D Rules: Loaded 0 Rule Sets
09:45:43 D DBCore: Query Successful, 0 rows returned
09:45:43 D World: Loading EQ2 time of day...
09:45:43 I World: Loaded System Data (took 1 seconds)
09:45:43 I Spawns: Loading System Spawns...
09:45:43 D Commands: Loading Entity Commands...
09:45:43 D DBCore: Query Successful, 531 rows returned
09:45:43 D Spawns: Loaded 531 entity commands.
09:45:43 D NPCs: Loading NPC(s)...
09:45:43 E DBCore: #1054: Unknown column 'alignment' in 'field list'
09:45:43 D DBCore: Query returned no results in RunQuery!
SELECT spawn_id, name, min_level, max_level, enc_level, race, model_type, class_, gender, command_primary, command_secondary, show_name, min_group_size, max_group_size, hair_type_id, facial_hair_type_id, wing_type_id, chest_type_id, legs_type_id, soga_hair_type_id, soga_facial_hair_type_id, attackable, show_level, targetable, show_command_icon, display_hand_icon, hp, power, size, collision_radius, action_state, visual_state, mood_state, initial_state, activity_status, faction_id, sub_title, merchant_id, merchant_type, size_offset, attack_type, ai_strategy+0, spell_list_id, secondary_spell_list_id, skill_list_id, secondary_skill_list_id, equipment_list_id, str, sta, wis, intel, agi, heat, cold, magic, mental, divine, disease, poison, aggro_radius, cast_percentage, randomize, soga_model_type, heroic_flag, alignment FROM spawn, spawn_npcs WHERE spawn.id = spawn_npcs.spawn_id
09:45:43 D NPCs: Loaded 0 NPC(s).
09:45:43 D DBCore: Query Successful, 0 rows returned
09:45:43 D NPCs: Loaded 0 NPC Spell(s).
09:45:43 D DBCore: Query Successful, 0 rows returned
09:45:43 D NPCs: Loaded 0 NPC Skill(s).
09:45:43 D DBCore: Query Successful, 0 rows returned
09:45:43 D NPCs: Loaded 0 NPC Equipment Piece(s).
09:45:43 D DBCore: Query Successful, 34 rows returned
09:45:43 D DBCore: Query Successful, 59782 rows returned
09:45:43 D NPCs: Loaded 0 NPC Appearance(s).
09:45:43 D DBCore: Query Successful, 11495 rows returned
09:45:43 D NPCs: Loaded 0 NPC Equipment Appearance(s).
09:45:43 D Objects: Loading Object(s)...
09:45:43 D DBCore: Query Successful, 644 rows returned
09:45:43 D Objects: Loaded 644 Objects.
09:45:43 D Signs: Loading Sign(s)...
09:45:43 D DBCore: Query Successful, 581 rows returned
09:45:43 D Signs: Loaded 581 Signs.
09:45:43 D Widgets: Loading Widget(s)...
09:45:43 D DBCore: Query Successful, 356 rows returned
09:45:43 D Widgets: Loaded 356 Widgets.
09:45:43 D GSpawns: Loading Groundspawn(s)...
09:45:43 E DBCore: #1054: Unknown column 'groundspawn_id' in 'field list'
09:45:43 D DBCore: Query returned no results in RunQuery!
SELECT spawn_id, name, race, model_type, command_primary, command_secondary, targetable, size, show_name, visual_state, attackable, show_level, show_command_icon, display_hand_icon, faction_id, collision_radius, number_harvests, num_attempts_per_harvest, groundspawn_id, collection_skill, size_offset FROM spawn, spawn_ground where spawn.id = spawn_ground.spawn_id
09:45:43 D GSpawns: Loaded 0 GroundSpawns.
09:45:43 D GSpawns: Loading GroundSpawn Entries...
09:45:43 E DBCore: #1146: Table 'eq2.groundspawns' doesn't exist
09:45:43 D DBCore: Query returned no results in RunQuery!
SELECT groundspawn_id, min_skill_level, min_adventure_level, bonus_table, harvest1, harvest3, harvest5, harvest_imbue, harvest_rare, harvest10, harvest_coin FROM groundspawns WHERE enabled = 1;
09:45:43 D GSpawns: Loaded 0 GroundSpawn Entries.
09:45:43 E DBCore: #1054: Unknown column 'groundspawn_id' in 'field list'
09:45:43 D DBCore: Query returned no results in RunQuery!
SELECT groundspawn_id, item_id, is_rare, grid_id FROM groundspawn_items;
09:45:43 D GSpawns: Loaded 0 GroundSpawn Items.
09:45:43 I Spawns: Loaded System Spawns (took 0 seconds)
09:45:43 D Loot: Loading loot data..
09:45:43 D DBCore: Query Successful, 2 rows returned
09:45:43 D Loot: Loading LootTables...
09:45:43 D Loot: Loaded 2 loot tables.
09:45:43 D DBCore: Query Successful, 2 rows returned
09:45:43 D Loot: Loading LootDrops...
09:45:43 D Loot: Loaded 2 loot drops.
09:45:43 D DBCore: Query Successful, 1673 rows returned
09:45:43 D Loot: Assigning loot table(s) to spawn(s)...
09:45:43 D Loot: Loaded 1673 spawn loot lists.
09:45:43 D World: Loading Transporter Information..
09:45:43 D DBCore: Query Successful, 25 rows returned
09:45:43 D World: Loaded 25 Transporters
09:45:43 I Items: Loading Items...
09:45:43 E DBCore: #1054: Unknown column 'display_charges' in 'field list'
09:45:43 D DBCore: Query returned no results in RunQuery!
SELECT id, name, icon, count, tier, weight, description, show_name, attuneable, artifact, lore, temporary, notrade, novalue, nozone, nodestroy, crafted, good_only, evil_only, skill_id_req, skill_id_req2, skill_min, skill_max, slots, sell_price, stack_count, collectable, offers_quest_id, part_of_quest_id, recommended_level, adventure_default_level, max_charges, display_charges, tradeskill_default_level, adventure_classes, tradeskill_classes, lua_script, usable, item_type, soe_id FROM items
09:45:43 D Items: Loaded 0 Normal Items
09:45:43 E DBCore: #1054: Unknown column 'display_slot_optional' in 'field list'
09:45:43 D DBCore: Query returned no results in RunQuery!
SELECT item_id, cast, recovery, duration, recast, display_slot_optional, display_cast_time, display_bauble_type, effect_radius, max_aoe_targets, display_until_cancelled FROM item_details_bauble
09:45:43 D Items: Loaded 0 Baubles
09:45:43 D DBCore: Query Successful, 314 rows returned
09:45:43 E Items: Error loading `item_details_bag`, ID: 220000
09:45:43 E Items: Error loading `item_details_bag`, ID: 220001
09:45:43 E Items: Error loading `item_details_bag`, ID: 220002
09:45:43 E Items: Error loading `item_details_bag`, ID: 220003
09:45:43 E Items: Error loading `item_details_bag`, ID: 220004
Thanks for help
