Updater errors

[Severance01]

When I run the ArcEmu DB updater I get several errors.
Any ideas on wtf is going on?

other than this the server works fine. Would be nice to be able to update though.

I copied the entire thing, here it is:

[Importing] Started...
[Importing] ArcEmu World Updates ...
[Importing] 104_rituals_objects.sql
[Importing] 185_quest_rewards.sql
ERROR 1054 (42S22) at line 2: Unknown column 'RequiredMoney' in 'quests'
[Importing] 456_ai_agents.sql
[Importing] 505_worldmap_info.sql
ERROR 1062 (23000) at line 1: Duplicate entry '559' for key 1
ERROR 1062 (23000) at line 2: Duplicate entry '572' for key 1
[Importing] 581_items_extendedcost.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'extended_cost'
[Importing] 616_quests_rewrep.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'RewRepFaction3'
ERROR 1060 (42S21) at line 6: Duplicate column name 'RewRepValue3'
[Importing] 633_creature_spawns_bytes.sql
ERROR 1054 (42S22) at line 1: Unknown column 'bytes' in 'creature_spawns'
ERROR 1060 (42S21) at line 2: Duplicate column name 'bytes1'
ERROR 1054 (42S22) at line 4: Unknown column 'bytes' in 'creature_staticspawns'
ERROR 1060 (42S21) at line 5: Duplicate column name 'bytes1'
[Importing] 672_instance-system.sql
ERROR 1050 (42S01) at line 3: Table 'instance_bosses' already exists
[Importing] 678_ai_threattospell.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'modcoef'
[Importing] 744_spellfixes.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'groupRelation0'
ERROR 1060 (42S21) at line 2: Duplicate column name 'groupRelation1'
ERROR 1060 (42S21) at line 3: Duplicate column name 'groupRelation2'
[Importing] 762_instance_bosses.sql
ERROR 1054 (42S22) at line 1: Unknown column 'spawnid' in 'instance_bosses'
ERROR 1062 (23000) at line 2: Duplicate entry '309-2725' for key 1
[Importing] 834_creature_proto.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'modImmunities'
[Importing] 1174_worldbroadcast.sql
[Importing] 1174_worldbroadcast_localized.sql
[Importing] 1174_worldmap_info_localized.sql
[Importing] 1174_worldstring_tables.sql
[Importing] 1174_worldstring_tables_localized.sql
[Importing] 1497_bugfixes.sql
ERROR 1146 (42S02) at line 39: Table 'squiredb_world.creatureloot' doesn't exist

ERROR 1146 (42S02) at line 85: Table 'squiredb_world.creatureloot' doesn't exist

ERROR 1146 (42S02) at line 131: Table 'squiredb_world.creatureloot' doesn't exis
t
[Importing] 1564_items.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'ScaledStatsDistributionId'
ERROR 1060 (42S21) at line 2: Duplicate column name 'ScaledStatsDistributionFlag
s'
ERROR 1054 (42S22) at line 3: Unknown column 'unk2' in 'items'
[Importing] 1564_removed_spells.sql
[Importing] 1576_wotlk_worldstring_table.sql
[Importing] 1587_quests.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'bonushonor'
[Importing] 1658_playercreateinfo_intros.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'introid'
[Importing] 1694_quests.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'RequiredOneOfQuest'
[Importing] 1707_creature_proto.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'can_ranged'
[Importing] 1729_creature_proto.sql
ERROR 1091 (42000) at line 1: Can't DROP 'equipinfo1'; check that column/key exi
sts
ERROR 1054 (42S22) at line 2: Unknown column 'equipmodel1' in 'creature_proto'
[Importing] 1735_quests.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'RemoveQuests'
[Importing] 1746_spawns.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'mountdisplayid'
ERROR 1091 (42000) at line 6: Can't DROP 'mountdisplayid'; check that column/key
 exists
[Importing] 1797_transport_data.sql
[Importing] 1860_loot.sql
ERROR 1050 (42S01) at line 1: Table 'loot_creatures' already exists
ERROR 1050 (42S01) at line 2: Table 'loot_gameobjects' already exists
ERROR 1050 (42S01) at line 3: Table 'loot_skinning' already exists
ERROR 1050 (42S01) at line 4: Table 'loot_fishing' already exists
ERROR 1050 (42S01) at line 5: Table 'loot_items' already exists
ERROR 1050 (42S01) at line 6: Table 'loot_prospecting' already exists
ERROR 1050 (42S01) at line 7: Table 'loot_disenchanting' already exists
ERROR 1050 (42S01) at line 8: Table 'loot_pickpocketing' already exists
ERROR 1050 (42S01) at line 10: Table 'loot_milling' already exists
[Importing] 1902_trainers.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'RequiredRace'
ERROR 1060 (42S21) at line 2: Duplicate column name 'RequiredReputation'
ERROR 1060 (42S21) at line 3: Duplicate column name 'RequiredReputationValue'
[Importing] 2118_items.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'itemstatscount'
ERROR 1054 (42S22) at line 2: Unknown column 'unk2' in 'items'
[Importing] 2157_worldmap_info.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'minlevel_heroic'
[Importing] 2177_sota_battlemaster_gossip_text.sql
[Importing] 2199_gosandquests.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'Name2'
ERROR 1060 (42S21) at line 2: Duplicate column name 'Name3'
ERROR 1060 (42S21) at line 3: Duplicate column name 'Name4'
ERROR 1060 (42S21) at line 4: Duplicate column name 'Category'
ERROR 1060 (42S21) at line 5: Duplicate column name 'CastBarText'
ERROR 1060 (42S21) at line 6: Duplicate column name 'UnkStr'
ERROR 1060 (42S21) at line 8: Duplicate column name 'detailemotecount'
ERROR 1060 (42S21) at line 9: Duplicate column name 'detailemote1'
ERROR 1060 (42S21) at line 10: Duplicate column name 'detailemote2'
ERROR 1060 (42S21) at line 11: Duplicate column name 'detailemote3'
ERROR 1060 (42S21) at line 12: Duplicate column name 'detailemote4'
ERROR 1060 (42S21) at line 13: Duplicate column name 'detailemotedelay1'
ERROR 1060 (42S21) at line 14: Duplicate column name 'detailemotedelay2'
ERROR 1060 (42S21) at line 15: Duplicate column name 'detailemotedelay3'
ERROR 1060 (42S21) at line 16: Duplicate column name 'detailemotedelay4'
ERROR 1060 (42S21) at line 17: Duplicate column name 'completionemotecnt'
ERROR 1060 (42S21) at line 18: Duplicate column name 'completionemote1'
ERROR 1060 (42S21) at line 19: Duplicate column name 'completionemote2'
ERROR 1060 (42S21) at line 20: Duplicate column name 'completionemote3'
ERROR 1060 (42S21) at line 21: Duplicate column name 'completionemote4'
ERROR 1060 (42S21) at line 22: Duplicate column name 'completionemotedelay1'
ERROR 1060 (42S21) at line 23: Duplicate column name 'completionemotedelay2'
ERROR 1060 (42S21) at line 24: Duplicate column name 'completionemotedelay3'
ERROR 1060 (42S21) at line 25: Duplicate column name 'completionemotedelay4'
ERROR 1060 (42S21) at line 26: Duplicate column name 'completeemote'
ERROR 1060 (42S21) at line 27: Duplicate column name 'incompleteemote'
ERROR 1050 (42S01) at line 29: Table 'vendor_restrictions' already exists
ERROR 1050 (42S01) at line 39: Table 'itemnames' already exists
[Importing] 2227_totems.sql
[Importing] 2243_totemspells.sql
ERROR 1062 (23000) at line 26: Duplicate entry '32775' for key 1
ERROR 1062 (23000) at line 27: Duplicate entry '32776' for key 1
[Importing] 2387_LightWell.sql
ERROR 1136 (21S01) at line 1: Column count doesn't match value count at row 1
ERROR 1136 (21S01) at line 2: Column count doesn't match value count at row 1
ERROR 1136 (21S01) at line 3: Column count doesn't match value count at row 1
ERROR 1136 (21S01) at line 4: Column count doesn't match value count at row 1
ERROR 1136 (21S01) at line 5: Column count doesn't match value count at row 1
ERROR 1136 (21S01) at line 6: Column count doesn't match value count at row 1
[Importing] 2582_quests.sql
ERROR 1060 (42S21) at line 13: Duplicate column name 'ReqEmoteId1'
[Importing] 2612_quests.sql
[Importing] 2649_playercreateinfo.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'taximask'
[Importing] 2682_creature_spawns.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'CanFly'
[Importing] 2750_gameobject_names.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'Size'
[Importing] 2780_spell_proc.sql
[Importing] 2786_items.sql
[Importing] 2801_items.sql
ERROR 1091 (42000) at line 2: Can't DROP 'dmg_min3'; check that column/key exist
s
ERROR 1060 (42S21) at line 14: Duplicate column name 'HolidayId'
ERROR 1054 (42S22) at line 17: Unknown column 'RequiredSkillSubrank' in 'items'
ERROR 1054 (42S22) at line 18: Unknown column 'unk203_1' in 'items'
ERROR 1054 (42S22) at line 19: Unknown column 'unk2' in 'items'
ERROR 1091 (42000) at line 20: Can't DROP 'name2'; check that column/key exists
[Importing] 2806_trainingdummies.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'isTrainingDummy'
[Importing] 2817_recallorientation.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'Orientation'
[Importing] 2828_spawns_phase.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'phase'
ERROR 1060 (42S21) at line 3: Duplicate column name 'phase'
ERROR 1060 (42S21) at line 5: Duplicate column name 'channel_spell'
ERROR 1060 (42S21) at line 6: Duplicate column name 'channel_target_sqlid'
ERROR 1060 (42S21) at line 7: Duplicate column name 'channel_target_sqlid_creatu
re'
ERROR 1060 (42S21) at line 8: Duplicate column name 'standstate'
ERROR 1060 (42S21) at line 9: Duplicate column name 'mountdisplayid'
ERROR 1060 (42S21) at line 10: Duplicate column name 'slot1item'
ERROR 1060 (42S21) at line 11: Duplicate column name 'slot2item'
ERROR 1060 (42S21) at line 12: Duplicate column name 'slot3item'
ERROR 1060 (42S21) at line 13: Duplicate column name 'CanFly'
ERROR 1060 (42S21) at line 14: Duplicate column name 'phase'
ERROR 1060 (42S21) at line 16: Duplicate column name 'phase'
[Importing] 2834_worldstring.sql
[Importing] 2840_guardtype.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'guardtype'
[Importing] 2860_gameobject_overrides.sql
ERROR 1060 (42S21) at line 2: Duplicate column name 'overrides'
ERROR 1060 (42S21) at line 3: Duplicate column name 'overrides'
[Importing] 2860_items.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'QuestItem5'
ERROR 1060 (42S21) at line 5: Duplicate column name 'QuestItem1'
ERROR 1060 (42S21) at line 13: Duplicate column name 'faction'
[Importing] 2860_mail_sending.sql
[Importing] ArcScript_full.sql
ERROR 1054 (42S22) at line 185: Unknown column 'RequiredSkillSubRank' in 'field
list'
[Importing] spellfixes.sql
[Importing] World Updates Finished


[Importing] ArcEmu Character Updates ...
[Importing] 147_pet_untrain_cost.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'reset_time'
[Importing] 261_gm_tickets.sql
ERROR 1091 (42000) at line 1: Can't DROP 'PRIMARY'; check that column/key exists

[Importing] 566_gm_tickets.sql
ERROR 1054 (42S22) at line 1: Unknown column 'type' in 'gm_tickets'
[Importing] 624_guild_leader_rights.sql
[Importing] 711_instance-system.sql
ERROR 1050 (42S01) at line 3: Table 'instanceids' already exists
[Importing] 912_pvp_titles.sql
[Importing] 943_playerpets_spellid.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'spellid'
[Importing] 1033_playersummons.sql
ERROR 1050 (42S01) at line 1: Table 'playersummons' already exists
[Importing] 1497_bugfixes.sql
[Importing] 1564_character_achievements.sql
[Importing] 1564_character_glyphs.sql
[Importing] 1564_removed_spells.sql
[Importing] 1653_achievements.sql
ERROR 1050 (42S01) at line 1: Table 'character_achievement_progress' already exi
sts
[Importing] 1835_playerpets_loyalty.sql
ERROR 1091 (42000) at line 1: Can't DROP 'loyaltypts'; check that column/key exi
sts
[Importing] 1911_playertitles.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'available_pvp_titles1'
[Importing] 1996_character_achievements.sql
The system cannot find the file specified.
[Importing] 2005_guildbank_tabinfo.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'tabInfo'
[Importing] 2084_character_achievement_progress.sql
[Importing] 2310_guilds.sql
[Importing] 2642_characters.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'active_cheats'
[Importing] 2742_guilds.sql
ERROR 1091 (42000) at line 2: Can't DROP 'bankTabCount'; check that column/key e
xists
[Importing] 2828_characters_phase.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'phase'
[Importing] 2834_language.sql
[Importing] 2839_petstate.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'petstate'
[Importing] 2841_itemdurations.sql
[Importing] 2845_refund.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'duration_expireson'
[Importing] 2860_groups.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'raiddifficulty'
[Importing] Character Updates Finished


[Importing] ArcEmu Logon Updates ...
[Importing] 1066_add_banreasons.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'banreason'
[Importing] correction_to_ipbans(allrevs).sql
[Importing] 1842_Account_Flags.sql
[Importing] 2391_accounts_banned.sql
[Importing] Logon Updates Finished
 Update Success.
[Importing] All Updates Finished

Press any key to continue . . .

Edit: Now after running that, I cannot create a new character and when I try to log in on the one I already have I get "login failed"

[Apple Pi]

The updater is trying to apply patches that have already been applied so it gives errors and the reason you cannot login is because you haven't used the latest character DB patches. You cannot rely on the updater tool to be up to date for the latest revisions.

Note the patches are located at /trunk/SQL/Character Updates/