r2182 build problem

[diatanato]

max item id is 20000. i see 27788, 27931, 28069 ... what is the problem

fixed in http://code.google.com/p/onetimexi/source/detail?r=2191

[kjLotus]

I had the same problem on the old-school server, I ran the delete and it's loading. See below:

Code: Select all

select * FROM item_mods WHERE itemId NOT IN (SELECT itemid FROM item_basic);

gets me:

Code: Select all

"itemId"	"modId"	"value"
"10552"	"73"	"2"
"10281"	"369"	"2"
"10282"	"369"	"1"
"10288"	"369"	"1"
"10467"	"369"	"1"
"10492"	"369"	"1"
"10564"	"369"	"1"
"11876"	"369"	"1"
"27788"	"369"	"2"
"27791"	"369"	"2"
"27792"	"369"	"2"
"27797"	"369"	"2"
"10468"	"370"	"3"
"10491"	"370"	"2"
"11875"	"370"	"1"
"27788"	"370"	"2"
"27931"	"370"	"2"
"28069"	"370"	"1"

So there are mods for items that dont exist!

that would still work (there's a check for NULL) but dia found out what it was, the max id.

if anyone is curious, it's because zedingo used the list on ffxiah to find all items with refresh and included abyssea stuff (i told him to because many of the scripts i deleted were for 75+ items, and i didn't want to lose them)

(ex: 27791 is marduk's jubbah+1, lvl 99 body armor)

[metronet]

Fantastic. Thanks for the quick fix guys!

I can confirm the fix is working great, at least on Linux, cheers!

Code: Select all

mysql> select * FROM item_mods WHERE itemId NOT IN (SELECT itemid FROM item_basic);
+--------+-------+-------+
| itemId | modId | value |
+--------+-------+-------+
|  10552 |    73 |     2 |
|  10281 |   369 |     2 |
|  10282 |   369 |     1 |
|  10288 |   369 |     1 |
|  10467 |   369 |     1 |
|  10492 |   369 |     1 |
|  10564 |   369 |     1 |
|  11876 |   369 |     1 |
|  10468 |   370 |     3 |
|  10491 |   370 |     2 |
|  11875 |   370 |     1 |
+--------+-------+-------+
11 rows in set (0.04 sec)