Close

User Tag List

Results 1 to 2 of 2
  1. #1

    Join Date
    May 2017
    Location
    PA, USA
    Posts
    87
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    DBError.log Clean-up (GUILow messages) v7.0.2

    Cleans up the thousands of GUILow error messages in t

    Code:
    -- --------------------------------------------------------------------------------------------------------------------
    -- Repack version:               7.0.2
    -- DBError.log Clean-up
    -- Fixes the GUILow errors.
    -- --------------------------------------------------------------------------------------------------------------------
    DELETE FROM `linked_respawn` WHERE `guid` NOT IN (SELECT DISTINCT `guid` FROM `creature`) AND `linkedGuid` NOT IN (SELECT DISTINCT `guid` FROM `creature`)  AND `linkType` = 0;
    "If it ain't broke, you're not trying hard enough."

  2. #2

    Join Date
    May 2017
    Location
    PA, USA
    Posts
    87
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    While the above post eliminated the entries in the 'linked_respawn` table where both the controlling creature and the one linked to it are not valid guid's in the `creature` table it still leaves hundreds where only the `guid` value is incorrect. The `linkedGuid` is invalid.

    The trouble I am having is matching these valid guid values to the correct linkedGuid values. They do not simply corristond to an id in the creature_template but specfic spawns which is why it is using the guid value in the creature table.

    The follow will simply remove these since they are not being used anyway and generating errors in the DBError.log file but I am wondering is there a way to fix this so it works like it should instead of just deleting? Thoughts?

    Code:
    DELETE FROM `linked_respawn` where `linkType` = 0 AND `linkedguid` not in (select distinct `guid` from creature)
    "If it ain't broke, you're not trying hard enough."

Visitors found this page by searching for:

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

Posting Permissions

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