Jump to content
  • Rel21_11_04_warden_dbdocs not working...

    • Status: Completed
      Main Category: Core / Mangos Daemon
      Sub-Category: Code Enhancement
      Version: 21.11 Milestone: Unset Priority: Unset
      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?

    Link to comment
    Share on other sites

    This is now closed for further comments

  • 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