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? Quote 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? Quote 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). Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.