[Epic Guide] Setting Up and Running an ArcEmu Server from Scratch!

[pakbaum]

Fixed THAT problem too!

Hopefully this will be the last one to fix...

All items in the game seem to be broken...they display this:

(Item Name, this is correct)
(Slot, also correct)
Duration: 1158050442 days
"-1"

That's what armor does.

Food and everything else has a random enchantment on it, sometimes things like "Use: 1000 Frost damage on target". No item works at all, and weapons deal 2-0 damage....

What's wrong???

[psychobandit]

Fixed THAT problem too!

Hopefully this will be the last one to fix...

All items in the game seem to be broken...they display this:

(Item Name, this is correct)
(Slot, also correct)
Duration: 1158050442 days
"-1"

That's what armor does.

Food and everything else has a random enchantment on it, sometimes things like "Use: 1000 Frost damage on target". No item works at all, and weapons deal 2-0 damage....

What's wrong???

Ya, I was just poking around my server last night (1st time I actually went into it, lol) & I noticed the same thing, never seen that problem before....and mine is so freakin laggy that I didn't spend too much time trying to track the problem down so moonblade0421? any idea what that is?
.
.
.

[pakbaum]

Also, and I think I'm getting to the source of the problem, when I edit spells or names or ANYTHING but the items in Navicat, I can see the changes in everything.

However, any changes made to items is not shown at all in-game. I cannot re-name, change effects or value, nothing.

[zimbabwe07]

im gettin same thing

[psychobandit]

well, I am wondering if it has something to do with either a recent update, OR maybe because WhyDB changed to the new address & rev 8. Since I really haven't done anything with my server yet, I decided to wipe the character, logon, & world DB's and, following the 1st page install instructions, re-did them all. When I run the "ArcEmu DB Updater.bat", this is what happens!

[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
ERROR 1054 (42S22) at line 1: Unknown column 'cooldown' in 'ai_agents'
ERROR 1054 (42S22) at line 2: Unknown column 'targettype' in 'ai_agents'
[Importing] 505_worldmap_info.sql
ERROR 1062 (23000) at line 1: Duplicate entry '559' for key 'PRIMARY'
ERROR 1062 (23000) at line 2: Duplicate entry '572' for key 'PRIMARY'
[Importing] 581_items_extendedcost.sql
ERROR 1060 (42S21) at line 1: Duplicate column name 'extended_cost'
ERROR 1146 (42S02) at line 4: Table 'world.items_extendedcost' doesn't exist
[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 '409-7346' for key 'PRIMARY'
[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 'world.creatureloot' doesn't exist
ERROR 1146 (42S02) at line 85: Table 'world.creatureloot' doesn't exist
ERROR 1146 (42S02) at line 131: Table 'world.creatureloot' doesn't exist
[Importing] 1564_items.sql
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
[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 1048 (23000) at line 2: Column 'mountdisplayid' cannot be null
ERROR 1048 (23000) at line 3: Column 'slot1item' cannot be null
ERROR 1048 (23000) at line 4: Column 'slot2item' cannot be null
ERROR 1048 (23000) at line 5: Column 'slot3item' cannot be null
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
[Importing] 2387_LightWell.sql
[Importing] 2582_quests.sql
[Importing] 2612_quests.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
ERROR 1060 (42S21) at line 1: Duplicate column name 'glyphs'
[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
[Importing] 2084_character_achievement_progress.sql
[Importing] 2310_guilds.sql
[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 . . .

Now, I didn't read every line of errors in there, but I am thinking if some of the code lines are in the wrong place, it could very well be causing the problems we are all having. So, Moonblade? any idea what's going on here?
.
.
.

[rawflstomp]

Anyone know if this works? Because I'm reading alot of posts saying that they get [COLOR=Red]Error's..

[rawflstomp]

Anyone know if this works because alot of people are saying they're getting Error's....

sorry about the double post!!! It wouldn't show my other post sorry D:

[Rayuski]

i like this guide

[psychobandit]

Well, at this point my server is useless....I have tried a few different ways to load the DB but SOMETHING is wrong in the DB itself./ I don't know if WhyDB updated to 3.1.0 or what but it's not working. I can't even get in, it auto disconnects every time I try. Since we are not getting answers here, I think I'm just gonna have to try & find a different DB.

**edit** I will also note that before WhyDB moved to the new URL, I had the server running & had made toons and walked around & such. The only problem I saw was horrid lag

**edit #2** Well, I have been poking around the net a bit and....well...maybe it is NOT the DB that is the problem. I just went to Arcemu's wiki & tried the main page & found out it has been hacked! So, I am sure a bunch of the compile parts have been fubar'd. And if you are like me, you update the SVN pretty often so THAT is probably why I am having problems, as well as all of you who have tried to set-up recently. It was Hacked by "spectre", I believe he is one of the many a-holes from Wowlegacy who just can't seem to leave other WoW sites alone. (sigh)


**edit #3** O.K. guys, they have Arc back under control, I updated everything today (Thursday) and rebuilt all of it & I DID get into & create a toon in my server, ran around a bit so you all should be able to get yours working now. BUT, there is still something wrong, every attack on any mob is a miss every single time! now THAT seems like a DB problem...but at least we can get in? :rimshot: :rofl:
.
.
.

[ZloQ]

Is it possible to make this work with 3.1.3?

If yes, how? ^.^

[psychobandit]

Is it possible to make this work with 3.1.3?

If yes, how? ^.^

I can't give you a definite yes or no for the DB, but I don't believe ArcEMU is up to 3.1.3 yet, so no until they update. At last check, they were talking about 3.1.3 but were still recovering from the hack attack

Also, a bunch of us are still having problems with the set-up of 3.0.9, and are patiently waiting for any answers to our questions :confused:
.
.
.

[Cianide]

hmmm... whenever I try to log in, it says "Unable to validate game version" what can i do to fix that???

[berrz]

Make sure you got the right version. You got a low/higher patch that your server supports.
Also check your logonserver config file and check your build. Set it to 1111->9999 for 3.1.3.

[Cianide]

ok, i edited the config file but i still get the same error message...

[psychobandit]

ok, i edited the config file but i still get the same error message...

1st let's make sure you are doing the config correctly.
The part that berrz is talking about should look like this when you are done:

<Client MinBuild = "1111"
MaxBuild = "9999">

The next question I would have is, which version of the game are you trying to run? Technically, that should run all versions, but 3.0.9 seems to run best within this set-up.
.
.
.