query error

[Stijn Goris]

I get an error when trying to insert a new row:
query error- 5 - Duplicate entry '80.200.213.102 Mozilla/4.0 (compatible;
MSIE 6.0; Windows NT 5.1; Avant Browser [avantbrowser.co m]; MyIE2; .NET CLR
1.0.' for key 1

The table consist of timestamp, file, level, ip, naam , ID


Where ID is an autoincrement, unique key.
Someone has an idea what going wrong?

kind regards
Stijn

[Erwin Moller]

Re: query error

Stijn Goris wrote:
[color=blue]
> I get an error when trying to insert a new row:
> query error- 5 - Duplicate entry '80.200.213.102 Mozilla/4.0 (compatible;
> MSIE 6.0; Windows NT 5.1; Avant Browser [avantbrowser.co m]; MyIE2; .NET
> CLR 1.0.' for key 1
>
> The table consist of timestamp, file, level, ip, naam , ID
>
>
> Where ID is an autoincrement, unique key.
> Someone has an idea what going wrong?[/color]

Yes, you made the column where this string is inserted in UNIQUE too, and it
already contained that value.
Check your tabledefinition , constraints and such.
[color=blue]
>
> kind regards
> Stijn[/color]


Regards,
Erwin