Zarenda Mal.1364:

Hi, I discovered that there are a number of ingredients that have item_id values that are not present in the items list. For some background, I pulled the recipe list and for each of those pulled the details. For each ingredient I created an entry in an ingredients table that is little more than a join table consisting of the recipe_id, the item_id and the count. Here is the output from a little program I whipped up to find out the details:

Total records in “ingredients” with item_ids that are missing in “items”: 298
8576: Missing in 2
12151: Missing in 3
12271: Missing in 7
12324: Missing in 8
13006: Missing in 9
13007: Missing in 9
13008: Missing in 9
13009: Missing in 9
13010: Missing in 11
19664: Missing in 5
19665: Missing in 2
19666: Missing in 2
19667: Missing in 3
19668: Missing in 1
19669: Missing in 2
19670: Missing in 2
19671: Missing in 3
19717: Missing in 20
19790: Missing in 56
19791: Missing in 75
19794: Missing in 59
19924: Missing in 1

Obviously that means that there are 298 ingredient entries that are missing a matching entry in items.

The recipe entries that correspond to this list are:
22
70
71
72
73
74
75
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
199
232
233
234
235
236
237
238
279
280
281
282
283
287
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
554
555
556
557
558
562
568
573
574
575
576
577
842
843
844
845
1031
1036
1040
1043
1044
1045
1046
1047
1048
1049
1050
1073
1074
1076
1079
1080
1081
1085
1086
1087
1088
1091
1092
1093
1094
1095
1096
1097
1098
1099
1125
1151
1154
1156
1157
1158
1159
1160
1161
1372
1373
1374
1375
1376
1377
1378
1379
1380
1381
1382
1383
1384
1385
1386
1424
1425
1426
1427
1428
1430
1433
1435
1436
1437
1438
1439
1440
1442
1445
1447
1712
1713
1714
1715
1897
1904
1906
1908
1910
1911
1912
1914
1933
1938
1940
1941
1943
1945
1948
1949
1950
1951
1953
1954
1955
1956
1957
1958
1959
1960
2040
2041
2042
2044
2047
2048
2212
2213
2214
2215
2216
2217
2218
2219
2220
2221
2222
2223
2224
2225
2226
2277
2278
2279
2281
2284
2285
2289
2290
2291
2293
2296
2297
2564
2565
2752
2758
2759
2760
2783
2787
2789
2790
2791
2792
2793
2794
2795
2796
2797
2798
2800
2802
2804
2805
2806
2808
2810
2840
2854
2862
2911
2915
2916
2922
3023
3028
3036
3043
3044
3052
3076
3081
3086
3096
3105
3117
3164
3165
3166
3723
3724
3725
3726
3727
4317
4418
4419
4420
4421
5291
5292
5293
5294
5295
5296
5297
6276
6277
6278
6279
6280
6281
6282
6283
6316
6324
6470
6507
6509
6725
6726
6727
6749
6750
7009
7012
7013
7018
7021
7022
7031
7032
7034
7224

DarkSpirit.7046:

Good find!

Item id 12151, for example, is Packet[s] of Baking Powder.

You can check it against gw2spidy since their TP api uses the same item id.

http://www.gw2spidy.com/item/12151

But

https://api.guildwars2.com/v1/item_details.json?item_id=12151

..gives an error, so this item is missing from their items api.

DarkSpirit.7046:

I wonder if they are keeping track of the bugs reported in this forum. I don’t see a reported bugs thread sticked.

Zarenda Mal.1364:

I downloaded the entire database to have it offline. Instead of building a online web program I am building some desktop stuff that uses these files directly. I still need to further evaluate the data to fully design the tables, since it is more of a tree than a set of relational database tables. But there is significant value in having a desktop app.

Cliff Spradlin.3512:

Hi, I discovered that there are a number of ingredients that have item_id values that are not present in the items list.

You’re right — good catch. We’ll fix this in a future update. Thanks for the bug report!

DarkSpirit.7046:

Thanks for looking into the issues Cliff!

Vennyhedgie.5369:

Not really related to ids but guild sword and greatsword have their icons swapped, if you look at the hilts you can see it clearly