Unsupported Screen Size: The viewport size is too small for the theme to render properly.

ERROR 1192 – ALTER TABLE

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › ERROR 1192 – ALTER TABLE

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 19, 2003 at 2:05 pm #7704
      tag
      Member

      I'm getting the following error when trying to rename a table:

      error no 1192

      Can't execute the given command because you have active locked tables or an active transaction.

      I have full permissions and I can rename the table from other software.

      Otherwise I really like this product. We are trying to make it our main gui interface.

      Thx

      Tag 🙂

    • February 19, 2003 at 4:25 pm #13772
      CalEvans
      Member

      Bounce the server (stop and restart mysql) and try again. You've got a transaction blocking you somewhere. (Warning! Ignore this advice totally if it's a production server!)

      =C=

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.