Dbpatcher problems

General support forum. If you require assistance and your problem doesnt fall in any of the other categories, this is the forum for you!

Moderator: Team Members

Forum rules
READ THE FORUM STICKY THREADS BEFORE ASKING FOR HELP!
Most information can be found there, and if not, the posts will help you determine the information required to get assistance from the development team.
Incomplete Help Requests will be locked or deleted.
Post Reply
belfedia
Posts: 5
Joined: Mon Jan 11, 2010 5:07 pm
EQ2Emu Server: Froggy French Server
Characters: Belfedia

Dbpatcher problems

Post by belfedia » 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 :(

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
Where i can found manual sql update since 0.6.5 for make it ?
Thanks for help :)
Froggy French Server (EQ1 & EQ2)
Top
belfedia
Posts: 5
Joined: Mon Jan 11, 2010 5:07 pm
EQ2Emu Server: Froggy French Server
Characters: Belfedia

Re: Dbpatcher problems

Post by belfedia » Sat Jan 21, 2012 2:08 am

No more !

I have just loginserver.ini error (lol)
updateserveraddress=update.eq2emulator.net
in place of updateserveraddress=updates.eq2emulator.net

Sorry for this useless post :/
Froggy French Server (EQ1 & EQ2)
Top
User avatar
John Adams
Retired
Posts: 9684
Joined: Thu Jul 26, 2007 6:27 am
EQ2Emu Server: EQ2Emulator Test Center
Characters: John
Location: Arizona
Contact:
Contact John Adams

Re: Dbpatcher problems

Post by John Adams » Sat Jan 21, 2012 2:47 am

Thanks for posting, Belfedia. One of our oldest and dearest members :) Thanks for keeping the Frogs happy, too! :mrgreen:
Top
belfedia
Posts: 5
Joined: Mon Jan 11, 2010 5:07 pm
EQ2Emu Server: Froggy French Server
Characters: Belfedia

Re: Dbpatcher problems

Post by belfedia » Sun Jan 22, 2012 1:15 am

I just "Lack of time" but i keep an eye on eq2emulator :)
Froggy French Server (EQ1 & EQ2)
Top
Post Reply

Return to “General Support”

Who is online

Users browsing this forum: No registered users and 1 guest