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

Error 1062

forums › forums › SQLyog › Using SQLyog › Error 1062

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • September 22, 2003 at 1:06 pm #8173
      mchenrycounty
      Member

      SQL/DB Error — [Duplicate entry '2147483647' for key 1]

      INSERT INTO lawyers_users VALUES ('0', '0', 'ddfdfd', '', 'dfdfdf', '', 'dfdfdf', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', '', '0', '0', '', '0', '', '0', '0', '', '', '0', '0', '0', '', '0', '0', '', '0', '0', '0', '', '', '2', '0', '220830168', '')

    • September 22, 2003 at 1:32 pm #14931
      CalEvans
      Member

      http://www.phpbuilder.com/mail/php-general…001072/1686.php

      Google is your friend.

      =C=

    • September 22, 2003 at 1:57 pm #14932
      mchenrycounty
      Member

      I deleted the row, and changed the table type to MyISAM and it didn't work.

      Can you explain the Delete From, How do I do that?

      Table Name =users

      Column = “id”

      Row= with problem= id = 2147483647, when it should be about 369

    • September 22, 2003 at 2:10 pm #14933
      Shadow
      Member

      Issue an INSERT INTO command that explicitly sets the id column to the next desired value. That will reset the counter.

    • September 22, 2003 at 2:37 pm #14934
      Shadow
      Member

      My bad, I replied before thinking! An INSERT INTO works only if you specify a higher value than the current seed. If you use MyISAM then you should take advantage of the -A option of myisamchk:

      Quote:
      -A or –set-auto-increment[=value]

      Force AUTO_INCREMENT to start at this or higher value. If no value is given, then sets the next AUTO_INCREMENT value to the highest used value for the auto key + 1.

    • September 22, 2003 at 3:28 pm #14935
      mchenrycounty
      Member

      Shadow

      what do I actually type to set to a value I keep getting

      and then do I hit “execute query”

      This is the error code I get when I hit “execute query”

      Error Code : 1064

      You have an error in your SQL syntax near 'auto-increment[=372] ' at line 1

      (350 ms taken)

      Thanks

    • September 22, 2003 at 3:39 pm #14936
      mchenrycounty
      Member

      What if I unchecked the auto-increment, and then assigned the id number myself?

    • September 22, 2003 at 3:48 pm #14937
      mchenrycounty
      Member

      Its fixed: these are the steps I took:

      1. Clicked on the Table

      2. went to “Alter Table Structure”

      3. went to “Other Properties”

      4. then inserted the next number in “Autoincremet box”

      Thanks

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