Re: Problem with SQL
| From: | Maureen | Date: | Tue, 10 Sep 2002 14:51:56 +0000 |
| Subject: | Re: Problem with SQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21672@lists.php.net to get a copy of this message | ||
Most likely the datatype you are using for the id field is tinyint, auto
increment. The tinyint datatype only goes to 127, so once you get to 127, it
tries to assign the same value for the next one. Try changing your id
datatype to int.
HTH
Maureen
Brtosz Matosiuk <madsiuk@morellos.net> said:
> Hi all
> SQL gives me a strange error and I can't find any info about it. Mayby
> someone of you could give me a clue what is wrong.
>
> The error is : 'Duplicate entry '127' for key 1'
> Thanks for any help
> ----------
> -= MAdSiuK (madsiuk@morellos.net) =-
> "(...) jestesmy nihilistami, w nic nie wierzymy, doslownie w nic(...)"
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--