We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

Answered Something went wrong while trying to remove the locks!

    • 36192 ☆ A M B ☆
    • 55 Posts
    Rafi Reply #1, 14 years ago
    Hello Friends,

    For a while now whenever I try to use the Tools > Remove Locks command I receive the message:

    Something went wrong while trying to remove the locks!

    Naturally I looked for the source of this and found that this message was generated by the file /manager/processors/remove_locks.processor.php and edited it to dump the sql in addition to throwing this message.

    When I execute the sql directly on the DB it executes successfully. Any ideas why the php would fail when using the "Remove Locks" feature in the manager?

    Evo 1.0.6 (current release)
    Apache 2.2.14 (Ubuntu)
    PHP 5.3.2-1
    MySQL 5.1.63

    This question has been answered by tonkatrucker. See the first response.

    • discuss.answer
      • 36192 ☆ A M B ☆
      • 55 Posts
      Rafi Reply #2, 14 years ago
      Ok, I've figured out what was happening. This goes out to all those who may have run into this problem.

      Your database user must have privileges to DROP tables to be able to execute TRUNCATE statements.

      https://dev.mysql.com/doc/refman/5.5/en/privileges-provided.html

      Case closed.

      [ed. note: tonkatrucker last edited this post 14 years ago.]