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

getting Error 1005

forums › forums › SQLyog › Using SQLyog › getting Error 1005

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • June 10, 2003 at 5:40 am #8024
      spc_123
      Member

      I created relationships on several tables, and have removed them with no problem. However, I have one table where I had created 3 relationships, and when I try to remove the relationship, I get:

      Error No. 1005 Can't create table 'C:DOCUMEN~1ADMINI~1LOCALS~1Temp#sql574_2_8.frm'(errno:140)

      Any suggestions?

      btw—win2k server/mysql v4/sqlyog 3.11 and I've checked the manuals with no luck…

      thanks in advance

    • June 10, 2003 at 6:16 pm #14487
      spc_123
      Member

      Resolved this issue….I had several indexes on this table. Once I deleted the indexes, I was able to delete the relationships…..Is this as designed? Thanks for being there anyway…

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