5.4.8 Updates not working

[JohnTrave]

5.4.8 Updates working just at 99,999%

Both "merged" and "spellareaupdate" kept giving me problems, mostly duplicated entries and such.
So I decided to run every single query one by one, in order.
Still got the same errors.

So I started searching and looking the rows, before even running the query, to see if their values were ok or not. And I found out that some some queries were processed, while some others did not. WTF???



UPDATE: I finally manage to run everything. Well, almost everything.

1) some names seems to must be truncated, because the string length was set to 50. These are names like "spell_area_spoils_of_pandaria_staff_of_resonating_water", "spell_area_garrosh_hellscream_embodied_aura_hope" and things like these... Obv I don't think this is a problem, thank God somebody invented IDs and pointers to address these exact situations.

2) some inserting operations in areatrigger_template where blocked. I'm talking about these:

INSERT INTO areatrigger_template (spell_id, eff_index, entry, TYPE, scale_x, scale_y, flags, move_curve_id, scale_curve_id, morph_curve_id, facing_curve_id, data0, data1, data2, data3, data4, data5, data6, data7, scriptname) VALUES
(134758, 1, 3817, 1, 1, 1, 2048, 0, 0, 0, 0, 2, 2, 2, 2, 2, 2, NULL, NULL, ''),
(136421, 1, 3942, 1, 1, 1, 2048, 0, 0, 0, 0, 2, 2, 2, 2, 2, 2, NULL, NULL, ''),
(136451, 1, 3946, 1, 1, 1, 2048, 0, 0, 0, 0, 2, 2, 2, 2, 2, 2, NULL, NULL, ''),
(139499, 0, 4134, 1, 1, 1, 2048, 0, 0, 0, 0, 20, 5, 6.75, 6.75, 5, 20, NULL, NULL, ''),
(139535, 0, 4135, 1, 1, 1, 2048, 0, 0, 0, 0, 17.5, 5, 12, 12, 5, 17.5, NULL, NULL, ''),
(139191, 0, 4116, 1, 1, 1, 2052, 0, 0, 0, 0, 2, 7.5, 2, 2, 7.5, 2, NULL, NULL, '');​

It seems that data6 and data7 are INT and so can't accept a NULL, so what I should write instead of NULL? Maybe 0 ? Or may be the best option is just to tick "Can be NULL" (I'm using Heidi in ita, dont know how it's written in english) ?

 

[felarrond]

I'm also getting duplicate errors when running the sql updates in heidi.

 

[JohnTrave]

Another thing I totally don't understand is why the server keeps using .dbc and .db2 files, instead of SQL... I spent hours putting these updates, and not a single one worked.
I know because I edited both .db2 and SQL for some items' stack size, and only the ones of .db2 where used by the server.
DBC.EnforceItemAttributes is set to 0, so how is this possible? Tried changing it a few times, but nothing changed.

And also... why I have to be in a constant .gm mode to see ANY npc/enemy/ally? Is this something that was made on purpose?

 

[JohnTrave]

I'm also getting duplicate errors when running the sql updates in heidi.

This should mean you already have those values. I wrote "should" because you can't really be sure, and so you have to just copy some queries and not the whole script, to see which work flawlessly and which don't.

Maybe the one/ones who wrote that "merge all updates in a one-in-all package" preferred to just copy/paste all the scripts instead of properly update the scripts who were editing values created just two rows before. My two cents.