[Help!] SQL Error in all items from WoW Vendetta menu

User Tag List

Results 1 to 7 of 7
  1. #1
    webm0nst3r's Avatar Member
    Reputation
    1
    Join Date
    Aug 2008
    Posts
    14
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [Help!] SQL Error in all items from WoW Vendetta

    hello guys i got a problem while i am trying to add a weapon which i had create on WoW Vendetta

    the error i get is this (and it happens in ALL items)

    [Err] 1264 - Out of range value for column 'holy_res' at row 1
    [Err] INSERT INTO item_template (entry, class, subclass, unk0, name, displayid, Quality, Flags, BuyCount, BuyPrice, SellPrice, InventoryType, AllowableClass, AllowableRace, ItemLevel, RequiredLevel, RequiredSkill, RequiredSkillRank, requiredspell, requiredhonorrank, RequiredCityRank, RequiredReputationFaction, RequiredReputationRank, maxcount, stackable, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, RangedModRange, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, PageText, LanguageID, PageMaterial, startquest, lockid, Material, sheath, RandomProperty, RandomSuffix, block, itemset, MaxDurability, area, map, BagFamily, TotemCategory, socketColor_1, socketContent_1, socketColor_2, socketContent_2, socketColor_3, socketContent_3, socketBonus, GemProperties, RequiredDisenchantSkill, ArmorDamageModifier, ScriptName, DisenchantID)
    VALUES (54001,2,7,-1,"Cursed Weapon",45479,6,0,0,20000000,10000,13,-1,-1,80,78,0,0,0,0,0,0,0,1,1,0, 1,200, 3,200, 4,200, 5,200, 6,200, 7,200, 12,200, 12,200, 13,200, 14,200,1000,1500,0,1000,1500,1,1000,1500,2,1000,1500,3,1000,1500,4,200,350,350,3 50,350,650,350,4.0,0,0,17713,1,0,0,0,0,34696,2,0,0,0,0,18060,1,0,0,0,0,33484,1,0 ,0,0,0,35844,1,0,0,0,0,0,"Custom Weapon",0,0,0,0,0,1,3,0,0,200,0,200,0,0,0,0,0,0,1,0,2,0,90,0,0,0,'internalitemha nler',0);
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------



    Any idea what is the problem ?? I am using WoW woTLK repack of Shadow's Dark

    http://www.mmowned.com/forums/emulat...lk-repack.html

    [Help!] SQL Error in all items from WoW Vendetta
  2. #2
    TheZaronz's Avatar Active Member
    Reputation
    97
    Join Date
    Dec 2007
    Posts
    567
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Jesus! THERE is a ****** ******* Emulation section just above this one


    [Err] 1264 - Out of range value for column 'holy_res' at row 1
    -- And there you even got the problem

  3. #3
    webm0nst3r's Avatar Member
    Reputation
    1
    Join Date
    Aug 2008
    Posts
    14
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sorry for that i will be carefull next time

    and how i can solve it ?

  4. #4
    epic_'s Avatar Member
    Reputation
    1
    Join Date
    Jan 2009
    Posts
    6
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    lol.

    you're completely stupid

  5. #5
    webm0nst3r's Avatar Member
    Reputation
    1
    Join Date
    Aug 2008
    Posts
    14
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    it called NEWBIE, and yes, i am learning now i didn't became PRO with my first lesson oO

  6. #6
    Mango Jerry's Avatar Banned
    Reputation
    192
    Join Date
    Jan 2008
    Posts
    1,244
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Everyone starts up as a Beginner.
    Just read alot of Guides.
    Your issue is that WoW Vendetta SQL's dosn't support ArcEmu, and only Ascent.

    @ Epic_:

    Please dont call anybody stupid, as your post will be reported for insulting another person.
    Please read our Rules and follow them.

  7. #7
    TheZaronz's Avatar Active Member
    Reputation
    97
    Join Date
    Dec 2007
    Posts
    567
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Whey! Let's make a drama movie out of this!

Similar Threads

  1. [help] SQL error
    By arthars1 in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 06-09-2008, 07:39 PM
  2. *HELP* Sql Error +rep
    By thegame240 in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 05-07-2008, 03:39 PM
  3. item from WOW EXPANSION! (picture included)
    By FoRbIdDeN in forum Gaming Chat
    Replies: 4
    Last Post: 11-04-2006, 09:16 AM
All times are GMT -5. The time now is 09:46 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search