Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    1

    Unanswered: SQLSTATE[HY000]: General error: 1025 Error on rename of

    Hi,

    I'm getting this error:

    Code:
    SQLSTATE[HY000]: General error: 1025 Error on rename of './salt/ghost' to './salt/#sql2-4ab-630b' (errno: 152). Failing Query: "ALTER TABLE ghost DROP FOREIGN KEY ghost.row_id"
    I looked for some information but I didn't get a solution..any help?

    Javi

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    There is a bug report about this. The message is a little misleading but basically you should be dropping the constraint name and not the index name. Have a look at this report which I think answers your question: MySQL Bugs: #14347: Can't remove FOREIGN KEY
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

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