Free Republic
Browse · Search
News/Activism
Topics · Post Article

To: Jim Robinson
382 days will go by fast. I can’t believe it’s that time again. BTTT
65 posted on 10/15/2007 11:51:39 PM PDT by Earthdweller (All reality is based on faith in something.)
[ Post Reply | Private Reply | To 1 | View Replies ]


To: Jim Robinson; Admin Moderator

Yeah, yeah, election schmelection, I think I found a fix for the DB:

After removing the auto-increment from the ID field, and moving the primary key to a different field, I was able to save two entries with no duplicates.

I then re-instigated the auto-increment on the ID field, and moved the primary key back to that field.
After doing the above, the problem went away.

I still have another database that I have not altered. I will do a more careful study of the problem with that database, and see if I can nail it down. When I do, I will post the results here. May be a number of days, though, as I am quite busy.

Thanks for your comments, Peter. I didn’t think of checking logs.

http://forum.mysqlperformanceblog.com/s/t/381/


69 posted on 10/15/2007 11:56:22 PM PDT by txhurl (Yes there were WMDs)
[ Post Reply | Private Reply | To 65 | View Replies ]

Free Republic
Browse · Search
News/Activism
Topics · Post Article


FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson