I have a mysql table that was working fine. I'll try to be brief.
I have a table that has two primary keys, both are also foreign keys to other tables. The primary keys are qid and pid. If I try to enter a record, using pid > 10, I get an error, for example, if the pid was 15, "Duplicate Entry '15' for key 1'.
Qid is INT(4) and Pid is also INT(4)
I have tried checking indexes, entering manually a record in using the command line, etc.
I am using MYSQL 5.0.45.
I can't seem to figure out why this problem is occuring.
Any help is much appreciated.