android6011 Posted June 8, 2007 Share Posted June 8, 2007 this is driving me crazy. when i first hit the index.php page it says "Duplicate entry '127' for key 1" if i refresh it goes away, then it randomly shows up on pages but goes away for awhile after i refresh them. where do i look to fix this? Link to comment https://forums.phpfreaks.com/topic/54712-duplicate-entry-127-for-key-1/ Share on other sites More sharing options...
rusbb Posted June 8, 2007 Share Posted June 8, 2007 See if this helps: http://forums.devshed.com/t22921/s.html Is your datatype tinyint? Link to comment https://forums.phpfreaks.com/topic/54712-duplicate-entry-127-for-key-1/#findComment-270565 Share on other sites More sharing options...
rusbb Posted June 8, 2007 Share Posted June 8, 2007 A signed tinyint field can hold 128 different values (0 -> 127). Use an alter table command and make your auto-increment value larger (smallint or int). Link to comment https://forums.phpfreaks.com/topic/54712-duplicate-entry-127-for-key-1/#findComment-270569 Share on other sites More sharing options...
android6011 Posted June 8, 2007 Author Share Posted June 8, 2007 thanks i think that did it. i googled but i found different solutions that didnt help.(what threw me off is that there are only 120 entries and i am getting this but oh well) so i appreciate it Link to comment https://forums.phpfreaks.com/topic/54712-duplicate-entry-127-for-key-1/#findComment-270570 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.