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

[patrick0]

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

[MentaL]

[IMOS]

STORE_STATIIC_TAB1

is not done properly in refshoptab/group

[lo1997xd]

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

[nukertube]

Heeelp we

[IMOS]

"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.

[moroccanace]

"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 ...

[shawky]

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

[romio10]

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

[nukertube]

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

[arabianfox]

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:

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