Jump to content
  • Rel21_11_04_warden_dbdocs not working...


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

    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.



    User Feedback

    Recommended Comments

    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?

    Share this comment


    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...