# Fix this

**URL:** <https://forum.kirupa.com/t/fix-this/11051>\
**Category:** Uncategorized\
**Created:** [January 11, 2003, 5:46am UTC](https://forum.kirupa.com/t/fix-this/11051 "2003-01-11T05:46:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kaotic](https://avatars.discourse-cdn.com/v4/letter/k/c77e96/32.png) [@kaotic](https://forum.kirupa.com/u/kaotic)\
**Post date:** [January 11, 2003, 5:46am UTC](https://forum.kirupa.com/t/fix-this/11051/1 "2003-01-11T05:46:05Z")

</div>

anyone know how to fix this sql error  
Error  
SQL-query : [Edit]

INSERT INTO ibf\_categories (id, position, state, name, description, image, url) VALUES (-1, NULL, NULL, ‘-’, NULL, NULL, NULL)

MySQL said:

Duplicate entry ‘-1’ for key 1

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [January 11, 2003, 1:37pm UTC](https://forum.kirupa.com/t/fix-this/11051/2 "2003-01-11T13:37:39Z")

</div>

How/why to you want to set the id to -1?  
What are these fields properties, auto-increment, etc?  
Should start at 0…what do you want to do here?  
If you want to remove stuff, use either drop to get rid of the table, or at least select by ID and then overwrite, but not MINUS 1!?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [January 11, 2003, 3:56pm UTC](https://forum.kirupa.com/t/fix-this/11051/3 "2003-01-11T15:56:20Z")

</div>

yes mysql will read those as a duplicate unless the field is setup as nvarchar or something like that. But yes why would you want a negative 1 as a prim key. Unless that is a valid value like from a form or something and you atre using it as a prim key. But if it is auto increment…then no need for -1

Eyes  
How did you do your footer? I could use a effect like that. shoot me a tut or something.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [January 12, 2003, 9:35am UTC](https://forum.kirupa.com/t/fix-this/11051/4 "2003-01-12T09:35:13Z")

</div>

All you need and more at  
[http://downloads.junioronline.us/](http://downloads.junioronline.us/)  
, one of my favorite script sites, the guy is too good.  
check quicksilver, egoflag, repel…all of’em… 🙂

Are ou very good with PHP / mySQL ? could need a hand on something…