Jump to content

  • Rel21_11_04_warden_dbdocs not working...

    Xenithar

    By Xenithar

      • Status: Completed
      Main Category: Core / Mangos Daemon
      Sub-Category: Code Enhancement
      Version: 21.11 Milestone: Unset Priority: Unset
      Implemented Version: Unset
     Share

    I am trying to apply Rel21_11_04_warden_dbdocs.sql to my database. The first issue is one of those invisible characters at the start of the SQL file. After removing it the update runs, but fails. However, there are no errors, it simply fails every time. I do not see a logic issue, but cannot figure it out.

     Share
    Go to bugs

    User Feedback

    Recommended Comments

    Xenithar

    I figured out the problem. The file will not execute the delete statement because an index is not used. This is a "feature" for MySQL and has been for a while. I discovered this by taking just the raw SQL and attempting to run it as an individual query. After disabling the safe updates option, the script ran fine.

    We need to start specifying indexes for delete statements or this could happen again. Should we update the patch?

    Link to comment
    Share on other sites


    Guest
    This is now closed for further comments

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use