socalnate Posted August 3, 2007 Share Posted August 3, 2007 I don't understand something...I'm getting this error: Duplicate entry '18709' for key 1 When it says, "duplicate entry 18709" does it mean that the NUMBER 18709 is duplicated in a table? Also, when it says, "key 1" key 1 of what? Key 1 of what table? I don't understand what key 1 is exactly and what table it is referring to because I'm using left joins. What's odd is that I did a search on every table in my left join for a duplicated 18709 and I don't see one. I'm stumped... ??? Link to comment https://forums.phpfreaks.com/topic/63144-duplicate-entry-error-help/ Share on other sites More sharing options...
Illusion Posted August 3, 2007 Share Posted August 3, 2007 Check the parent table which has the primary key has that value(18709) if u r referenced that column for which u r getting error. U can use SHOW INDEX FROM database.tablename to get the keys information Link to comment https://forums.phpfreaks.com/topic/63144-duplicate-entry-error-help/#findComment-314792 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.