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

Error removing foreign key

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Error removing foreign key

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • February 3, 2004 at 10:38 pm #8315
      gmcui
      Member

      Sqlyog is a wonderful software!

      Here is my problem:

      When trying to remove a foreign key restraint from an innodb table, I received the following error: Error No. 1005: Can't create table 'c:mysqltemp#sql314_dd_4.frm' (errorno: 140)

      A look at the history showed this query:

      create temporary table if not exists `db`.`sqlyog_2864` (

      ….

      `sample_id` smallint(6) NULL ,

      …

      FULLTEXT KEY `sample_id_ind` ( `sample_id` ),

      …

      )

      The query works if “FULLTEXT” is removed. I am also puzzled at the need of adding Fulltext index to the 'sample_id' column, since in the original table it is only indexed but not fulltext indexed.

      Thanks for looking into this.

    • February 4, 2004 at 3:01 am #15440
      Ritesh
      Member

      Can you tell me the version of SQLyog and MySQL?

    • February 4, 2004 at 12:37 pm #15441
      gmcui
      Member

      MySql 4.0.12-nt

      Sqlyog 3.64

    • February 8, 2004 at 8:57 pm #15442
      Shadow
      Member

      Ritesh, it's the same problem I have already reported. For some reason SQLyog attempts to create FULLTEXT indices in the temporary table regardless of the field and table type. In this particular example: InnoDB table type does not support FULLTEXT indices at all and the sample_id field is of smallint type…

      This bug should be corrected!

    • February 9, 2004 at 2:07 am #15443
      Ritesh
      Member

      This is a known bug. This will be fixed in SQLyog 3.64 final release.

  • Author
    Posts
Viewing 4 reply threads
  • You must be logged in to reply to this topic.