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

Error 1100

forums › forums › SQLyog › Using SQLyog › Error 1100

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 10, 2003 at 11:11 pm #8027
      spc_123
      Member

      Things seem to be getting stranger and stranger. After deleting indexes and relationships so that I could enter data into my tables (otherwise violated constraints)…I'm getting Error 1100 whenever I try and open a table. The table I just entered data in opens fine, but I get “Error 1099 Table 'table_name' was locked with a READ lock and can't be updated.” All other tables give me Error 1100.

    • June 10, 2003 at 11:21 pm #14491
      spc_123
      Member

      I disconnected/reconnected, and it seems that I can open my tables again…however, when I try to delete a relationship on a form I get: Error No. 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '?, modified, im_id from `cyberdb`.`cs_operator`' at line 1

      I'm doing this via SQLyog, and not personally running any SQL

    • June 10, 2003 at 11:22 pm #14492
      spc_123
      Member

      Then, right after I get this message, I continually get the Error 1100 again…..which is then resolved by disconnecting and reconnecting again. I resolved the problem by dropping the problem tables and recreating them.

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