----- Original Message -----
From: "Steven Fruchter" <[EMAIL PROTECTED]>
> Hi Everyone,
> I have a big problem, that I bet could be solved pretty simply but I
am
> new to mysql so its killing me and my database.
>
> Ok heres the problem, suddenly out of no where when my php script
tries
> to (or manually) do a insert it says:
>
> ERROR 1062: Duplicate entry '127' for key 1
>
<snip>
> CREATE TABLE custinfo ( id tinyint(4) DEFAULT '0' NOT NULL
<snip>
Hi Steven,
Carefully check out your data types. You used a tinyint for the ID, which
according to another poster, has a maximum limit of 127.
So it can't auto_increment above the maximum limit.
Use int. It can do into the thousands.
Anna
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php