5.4.8 Updates not working
Close

User Tag List

Results 1 to 4 of 4
  1. #1
    JohnTrave's Avatar
    Join Date
    Oct 2019
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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_h ope" 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) ?
    Last edited by JohnTrave; 10-23-2019 at 12:26 PM.

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Posts
    Many
     

  3. #2
    felarrond's Avatar
    Join Date
    Oct 2019
    Posts
    57
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm also getting duplicate errors when running the sql updates in heidi.

  4. #3
    JohnTrave's Avatar
    Join Date
    Oct 2019
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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?

  5. #4
    JohnTrave's Avatar
    Join Date
    Oct 2019
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by felarrond View Post
    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.

Visitors found this page by searching for:

Nobody landed on this page from a search engine, yet!
SEO Blog

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •