3 replies to this topic

[α∂αмяoss]

Hey folks,

I need help with a SQL error i'm getting from my forums. The error is:

mySQL query error: INSERT INTO ibf_admin_permission_keys (perm_key,perm_main,perm_child,perm_bit) VALUES('tools:admin:recache','tools','admin','recache')

SQL error: Duplicate entry 'tools:admin:recache' for key 1
SQL error code: 
Date: Thursday 10th of August 2006 09:22:09 AM

How do i fix this?

Thanks in advance,
Adam Ross

[Matthew.]

You might be better off on the IPB support forums. I can tell you what the error means but i don't know what has gone wrong

It means the script is trying to insert something already exists (well, the key exists anyway).

Thats all i can say, you'll have to wait for an IPB nerd lol

[Av-]

it means theres a field in your database that is set to only accept unique values, your trying to insert a value that already exists in another field.... if that makes sense

[NGPixel]

Just set the ID field as primary key and set as Auto_Increment.