!!! failed to build reference data from this [_REFSHOP] table

Results 1 to 10 of 10
  1. #1
    Apprentice patrick0 is offline
    MemberRank
    Feb 2012 Join Date
    5Posts

    !!! failed to build reference data from this [_REFSHOP] table

    please help me:S i add npc with static assistance but, when i add item to npc take error.. help me please:( Sorry for poor english

    i use this codes
    RefShopGoods
    1 15 STORE_STATIIC_TAB1 PACKAGE_ITEM_CH_SHIELD_10_A 5 -1 xxx -1 xxx -1 xxx -1 xxx
    Refpackageitem

    1 15 NULL PACKAGE_ITEM_CH_SHIELD_10_A 0 EXPAND_TERM_ALL SN_ITEM_CH_SHIELD_10_A SN_ITEM_CH_SHIELD_10_A_TT_DESC item\china\weapon\shield_10.ddj -1 xxx -1 xxx -1 xxx -1 xxx
    Refscrapofpackageitem

    1 15 PACKAGE_ITEM_CH_SHIELD_10_A ITEM_CH_SHIELD_10_A 0 0 46 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx NULL
    Refpricepolictyitem

    1 15 PACKAGE_ITEM_CH_SHIELD_10_A 1 0 1000000 -1 xxx -1 xxx -1 xxx -1 xxx
    And error this
    UploadPic.org - Picture Viewer - uploadpic.org

    UploadPic.org - Picture Viewer - uploadpic.org


  2. #2
    Valued Member IMOS is offline
    MemberRank
    Dec 2007 Join Date
    125Posts

    Re: !!! failed to build reference data from this [_REFSHOP] table

    STORE_STATIIC_TAB1

    is not done properly in refshoptab/group

  3. #3
    Enthusiast lo1997xd is offline
    MemberRank
    Feb 2012 Join Date
    31Posts

    Re: !!! failed to build reference data from this [_REFSHOP] table

    i sure i did everything correctly this error crazy me static please help us

  4. #4
    Banned nukertube is offline
    BannedRank
    Oct 2011 Join Date
    BrazilLocation
    224Posts

    Re: !!! failed to build reference data from this [_REFSHOP] table

    Heeelp we

  5. #5
    Valued Member IMOS is offline
    MemberRank
    Dec 2007 Join Date
    125Posts

    Re: !!! failed to build reference data from this [_REFSHOP] table

    "failed to build reference data from this [_REFSHOP] table" is returned when one of the SlotIndex for a specific shop is non unique. Make sure they are not repeated.

  6. #6
    Enthusiast moroccanace is offline
    MemberRank
    May 2012 Join Date
    39Posts

    Re: !!! failed to build reference data from this [_REFSHOP] table

    Quote Originally Posted by IMOS View Post
    "failed to build reference data from this [_REFSHOP] table" is returned when one of the SlotIndex for a specific shop is non unique. Make sure they are not repeated.
    i have same problem and my slot index is unique what else can cause this ...

  7. #7
    Apprentice shawky is offline
    MemberRank
    Jan 2012 Join Date
    19Posts

    Re: !!! failed to build reference data from this [_REFSHOP] table

    refpackage check it you have a duplicated ID's change it and it will work for sure

  8. #8
    Account Upgraded | Title Enabled! romio10 is offline
    MemberRank
    Jan 2012 Join Date
    310Posts

    Re: !!! failed to build reference data from this [_REFSHOP] table

    Hello remove refshop and add this

    1 15 1 mall_consume -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 2 store_ch_smith -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 3 store_ch_armor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 4 store_ch_accessory -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 5 store_ch_potion -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 6 store_ch_potion2 -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 7 store_ch_potion3 -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 8 store_ch_stable -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 9 store_ch_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 10 store_ch_trader -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 11 store_ch_hunter -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 12 store_wc_smith -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 13 store_wc_armor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 14 store_wc_accessory -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 15 store_wc_potion -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 16 store_wc_stable -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 17 store_wc_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 18 store_wc_trader -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 19 store_wc_hunter -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 20 store_kt_smith -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 21 store_kt_armor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 22 store_kt_accessory -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 23 store_kt_potion -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 24 store_kt_stable -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 25 store_kt_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 26 store_kt_trader -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 27 store_kt_hunter -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 28 store_td_thief_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 29 store_td_thief -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 30 mall_avatar -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 31 store_rm_potion -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 32 mall_pet -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 33 store_ch_special2 -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 34 store_wc_special2 -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 35 store_tk_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 36 store_rm_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 37 store_am_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 38 mall_premium -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 39 mall_archemy -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 40 store_ch_guild -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 41 store_wc_guild -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 42 store_kt_guild -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 43 store_eu_guild -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 44 store_kt_armor_silsamo -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 45 store_ca_guild -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 46 store_eu_smith -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 47 store_eu_armor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 48 store_eu_accessory -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 49 store_eu_potion -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 50 store_eu_stable -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 51 store_eu_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 52 store_eu_trader -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 53 store_eu_hunter -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 54 store_ca_smith -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 55 store_ca_armor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 56 store_ca_accessory -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 57 store_ca_potion -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 58 store_ca_stable -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 59 store_ca_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 60 store_ca_trader -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 61 store_ca_hunter -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 62 store_ch_official -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 63 store_wc_official -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 64 store_kt_official -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 65 store_eu_official -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 66 store_ca_official -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 67 store_ja_battleaide -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 68 store_dw_battleaide -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 69 store_ht_battleaide -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 70 store_ct_battleaide -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 71 store_sk_battleaide -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 72 store_bj_battleaide -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 73 store_hm_battleaide -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 74 store_er_battleaide -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 75 store_ch_honor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 76 store_wc_honor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 77 store_kt_honor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 78 store_eu_honor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 79 store_ca_honor -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 80 store_ch_honor2 -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 81 store_wc_honor2 -1 xxx -1 xxx -1 xxx -1 xxx
    0 15 82 store_test -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 83 store_sd_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 84 store_ve_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 85 store_de_special -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 86 store_sd_set -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 87 store_sd_accessory -1 xxx -1 xxx -1 xxx -1 xxx
    1 15 88 store_battle_arena -1 xxx -1 xxx -1 xxx -1 xxx

    good luck

  9. #9
    Banned nukertube is offline
    BannedRank
    Oct 2011 Join Date
    BrazilLocation
    224Posts

    Re: !!! failed to build reference data from this [_REFSHOP] table

    man
    simply

    check the ultimate Id from RefPackageitem
    and Ultimate id from Refscrapofpackageitem


    and ( + 1 )

    ex> Refpackage item ultimate Id is 84643
    use 84644 ...
    and done

  10. #10
    __F0X__ arabianfox is offline
    MemberRank
    Nov 2011 Join Date
    292Posts

    Re: !!! failed to build reference data from this [_REFSHOP] table

    Instead of searching the maximum ID every time you want add things to DB and put ID manually just make ID generates automatically as it should be as mentioned here by me before:


    Quote Originally Posted by arabianfox View Post
    From SQL main menu choose Tools >> Options and go to Designers and remove check from "Prevent saving changes that require table re-creation as shown here:



    Then go to table Refpackageitem table Right click and choose Design



    Then Right click on ID and choose "set primary key"



    Then scroll down at column properties you will find "Identity specification" property >> choose "is identity" and choose "yes" as you can see here



    This will make ID auto number and SQL will generate a unique number each time you try to add a new items to the table.

    Do the same to table Refscrapofpackageitem but don't set primary key >> just make [INDEX] column identity to YES

    now to add new item leave ID empty (NULL) and SQL will generate a new number (unique number) and this for [INDEX] at refscraofpackageitem too >> then copy this numbers to your media text files.

    Thank you



Advertisement