errors

[jamromhem]

[20100728 07:46:08] LoginServer::ConnectToUpdateServer: 'TCPConnection::Connect(): connect() failed. Error: 10060'
this is the first error on my list..

I have the ports forwarded and the firewall open.

my update server snippet in my loggin.ini looks like this.

Code: Select all

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9103

I am running out of ideas on getting this to work.

The server loads, but with a list of errors *that being the first on the list*

[John Adams]

Thanks for reporting a problem. This service (auto updater) is having some troubles...

Try it again, please. I found a bad IP port config, but think I fixed it.

Also be aware there may be an issue with getting a full DB for new setups. I'm trying to resolve this as well, but what I may end up doing is ditching the auto-updater completely and releasing a SQL file.

You can also download a ServerPack, turn-key system, found in Releases.

[jamromhem]

That did fix that error. the database update erros seem to be the only remaining errors

I attemtped to use the sql release, but I dont think I got a good upload of the database. I will reload it from a release.

Code: Select all

-----------------------------------------
[20100728 12:22:57] Error in updating tables query 'ALTER TABLE `item_stats` CHANGE `value` `value` FLOAT DEFAULT '0' NOT NULL': #1146: Table 'eq2.item_stats' doesn't exist
[20100728 12:22:57] 	Attempting to update database table 'item_stats' ... FAILED!
[20100728 12:23:00] Error in LoadNPCSpells query 'SELECT spell_list_id, spell_id, spell_tier from spawn_npc_spells where spell_list_id > 0': #1146: Table 'eq2.spawn_npc_spells' doesn't exist
[20100728 12:23:00] Error in LoadAppearances query 'SELECT distinct `type` from npc_appearance where length(type) > 0': #1146: Table 'eq2.npc_appearance' doesn't exist
[20100728 12:23:00] Error in LoadAppearances query 'SELECT `type`, spawn_id, signed_value, red, green, blue from npc_appearance where length(type) > 0 order by spawn_id': #1146: Table 'eq2.npc_appearance' doesn't exist
[20100728 12:23:00] Error in LoadNPCAppearanceEquipmentData query 'SELECT spawn_id, slot_id, equip_type, red, green, blue, highlight_red, highlight_green, highlight_blue from npc_appearance_equip order by spawn_id': #1146: Table 'eq2.npc_appearance_equip' doesn't exist
[20100728 12:23:01] Error in LoadLootDrop query 'select id, name, mincoin, maxcoin, maxlootitems, lootdrop_probability, coin_probability from loottable': 
[20100728 12:23:01] Error in LoadItemStats query 'select item_id, type, subtype, value, text from item_stats order by item_id asc': #1146: Table 'eq2.item_stats' doesn't exist
[20100728 12:23:01] Error in LoadItemEffects query 'select item_id, description, percentage, bullet from item_effects order by item_id, id': #1146: Table 'eq2.item_effects' doesn't exist
[20100728 12:23:01] Error in LoadItemLevelOverride query 'select item_id, adventure_class_id, tradeskill_class_id, level from item_levels_override order by item_id asc': #1146: Table 'eq2.item_levels_override' doesn't exist
[20100728 12:23:01] Error Loading Spells, Query: select spells.`id`, `name`, `description`, `type`, `class_skill`, `mastery_skill`, `tier`, `hp_req`, `power_req`, `cast_time`, `recast`, `radius`, `max_aoe_targets`, `req_concentration`, `range`, `duration1`, `duration2`, `resistibility`, `hp_upkeep`, `power_upkeep`, `duration_until_cancel`, `target_type`, `recovery`, `power_req_percent`, `hp_req_percent`, `icon`, `icon2`, `icontype`, `success_message`, `fade_message`, `cast_type`, `lua_script`, `call_frequency`, `interruptable`, `spell_visual`, `effect_message`, `min_range`, `can_effect_raid`, `affect_only_group_members`, `hit_bonus`, `display_spell_tier`, `friendly_spell`, `group_spell`, `spell_book_type` from spells, spell_tiers where spells.id = spell_tiers.spell_id order by `tier`, Error: #1146: Table 'eq2.spell_tiers' doesn't exist