|  |
Ascent Guides This section is for WoW emulated server, Ascent guides.
[NO QUESTIONS HERE] |
 | | 
05-23-2009
| | Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep) | | | Join Date: May 2009
Posts: 9
Reputation: 1 | | | 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???
Last edited by pakbaum; 05-23-2009 at 07:31 PM.
|
Donate to remove ads, get your "DONATOR title, and get access to the MMOwned community's elite Shoutbawx.
05-23-2009
|  | Master Sergeant | | | Join Date: Jun 2007 Location: Nevada
Posts: 76
Reputation: 5 Level up: 47%, 266 Points needed |   | | Quote:
Originally Posted by 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??? | 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? .
.
. |
05-24-2009
| | Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep) | | | Join Date: May 2009
Posts: 9
Reputation: 1 | | | 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. |
05-24-2009
| | New User | | | Join Date: Jan 2008
Posts: 25
Reputation: 1 | | | im gettin same thing |
05-26-2009
| | Master Sergeant | | | Join Date: Jun 2007 Location: Nevada
Posts: 76
Reputation: 5 Level up: 47%, 266 Points needed | | | 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! Code:
[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? .
.
.  |
05-26-2009
| | Banned | | | Join Date: Mar 2009
Posts: 252
Reputation: 28 | | | Anyone know if this works? Because I'm reading alot of posts saying that they get [COLOR=Red]Error's.. |
05-26-2009
| | Banned | | | Join Date: Mar 2009
Posts: 252
Reputation: 28 | | | 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: |
05-31-2009
| | Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep) | | | Join Date: May 2009
Posts: 21
Reputation: 3 Level up: 37%, 254 Points needed | | | | guide
i like this guide |
06-03-2009
| | Master Sergeant | | | Join Date: Jun 2007 Location: Nevada
Posts: 76
Reputation: 5 Level up: 47%, 266 Points needed | | | 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?   .
.
.
Last edited by psychobandit; 06-09-2009 at 08:48 PM.
Reason: fixed a typo
|
06-10-2009
| | New User | | | Join Date: May 2009
Posts: 6
Reputation: 1 Level up: 23%, 309 Points needed | | | | Is it possible to make this work with 3.1.3?
If yes, how? ^.^ |
06-10-2009
| | Master Sergeant | | | Join Date: Jun 2007 Location: Nevada
Posts: 76
Reputation: 5 Level up: 47%, 266 Points needed | | | Quote:
Originally Posted by ZloQ 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  .
.
. |
06-12-2009
| | Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep) | | | Join Date: Jun 2009 Location: The place with grass
Posts: 3
Reputation: 1 Level up: 21%, 316 Points needed | | | | hmmm... whenever I try to log in, it says "Unable to validate game version" what can i do to fix that??? |
06-12-2009
|  | New User | | | Join Date: Oct 2008 Location: Sweden
Posts: 45
Reputation: 1 Level up: 3%, 488 Points needed | | | | 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. |
06-12-2009
| | Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep) | | | Join Date: Jun 2009 Location: The place with grass
Posts: 3
Reputation: 1 Level up: 21%, 316 Points needed | | | | ok, i edited the config file but i still get the same error message...
Last edited by Cianide; 06-12-2009 at 05:39 PM.
|
06-12-2009
| | Master Sergeant | | | Join Date: Jun 2007 Location: Nevada
Posts: 76
Reputation: 5 Level up: 47%, 266 Points needed | | | Quote:
Originally Posted by Cianide 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. .
.
. | | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off
| | |
All times are GMT -4. The time now is 05:40 AM.
|
