You could try dropping and rebuilding the primary key (that's if you haven't
already done that). Something like:
ALTER TABLE name DROP PRIMARY KEY
ALTER TABLE name ADD PRIMARY KEY (id)
If you still get problems, then try zipping up the database and mailing it
Instant Computer Solutions
From: Matt <Matt@bishop.org>
To: firstname.lastname@example.org <email@example.com>
Date: 28 September 1999 09:05
Subject: select not selecting correctly.
>I just upgraded my database from 1.8.1 to 2.4.1. I dropped all the
>indexes I could, performed a clean shutdown, and installed the new
>classes. When I restarted the machine and checked the database, I found
>an oddity in the data.
>Two records with different ID values (I have an auto-incrementing integer
>field called ID) are being selected when I select on just one of their
>values. The values are 3198 and 2680, but both hit on 2680. Neither
>hits on 3198.
>EARTH FIRST--we'll screw up the other planets later.