Duplicate Entry Error

[chaseman]

I get this error when trying to submit data:

 

Duplicate entry '35' for key 'user_id'

 

I can not submit data on ANOTHER row when the same user_id has been used on a DIFFERENT row.

The user_id field is simply an integer field, it's at default null, and has a yes null.

It stores the user_id which on the other hand is stored in a session variable.

 

BEFORE the user_id is the con_id (contribution which is auto_increment).

 

What do I have to set up to allow the user_id field to have the same value on different rows like this:

 

con_iduser_idname

135a name

235a different name

335one more name

 

[Pikachu2000]

You've somehow managed to add an index to the user_id field. You'll need to drop the index to allow duplicate entries.

[chaseman]

Thank you a lot, that fixed it.

 

I didn't even notice that, I must have accidentally clicked the index button.

 

Is there a way to double-check if things like this are being set accidentally?