From: dan
Date: April 2 1999 5:02pm
Subject: Re: Duplicate entry for non-existant value
List-Archive: http://lists.mysql.com/win32/58
Message-Id: <3704F836.D5AF6F1A@wde.com>
MIME-Version: 1.0
Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms42C8E59850A47F41EF48F0AD"

--------------ms42C8E59850A47F41EF48F0AD
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

Have you tried running isamchk.exe on the table to see if you get any errors?
That might show you some helpful information.

Also, what's the schema for your table?

Dan.

Scollick Family wrote:

> I'm getting a problem that causing all sorts of havoc. I'm
> trying to insert a new row into a table using
>
> insert into tab1 (tabid, val) values ('s1083','test')
>
> and keep getting an error 'Duplicate entry 's1083' for key 1'
> (tabid is the primary key for the table).  The problem is that
> s1083 doesn't exist.  If I try to select and/or delete, I get an
> empty set response, but I still can't insert it into the table.
> The same holds true if I increment s1083 up to somewhere
> around s1100.  Also, any inserts into related tables don't return
> properly in I insert the s1083 key in it.  That is:
>
> insert into tabrelated (id1, id2) values ('n0074','s1083')
> select * from tabrelated where id2='s1083'
>   returns an empty set while
> select * from tabrelated where id1='n0074'
>   does indeed show s1083
>
>  As another bit of wierd behavior, as far as I can tell there are 1075 rows
> in the table, but a select count(tabid) returns that there are 1086 rows.
> And, tab1 is my main table on which everything else is derived, so until
> this is solved, I'm dead in the water.
>
>   Finally, I'm using the shareware version on Win95 (a potential web host
> uses mySQL, and I'm trying to see if it will work for my purposes).
>
>   Any help would be greatly appreciated.
>
>   --Keith Scollick
>   scollick@stripped
>
> P.S. - if this is an old question, my apologies as I haven't been able to get
> through the old messages
> -----------------------------------------------
> Keith Scollick
> scollick@stripped
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread57@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.

--------------ms42C8E59850A47F41EF48F0AD
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIII9QYJKoZIhvcNAQcCoIII5jCCCOICAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC
BtYwggO0MIIDHaADAgECAhArJEezyiy5Q0QGw77FB2uIMA0GCSqGSIb3DQEBBAUAMIG4MRcw
FQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0d29y
azFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAuIEJ5
IFJlZi4sTElBQi5MVEQoYyk5ODE0MDIGA1UEAxMrVmVyaVNpZ24gQ2xhc3MgMiBDQSAtIElu
ZGl2aWR1YWwgU3Vic2NyaWJlcjAeFw05ODA3MjMwMDAwMDBaFw05OTA3MjMyMzU5NTlaMIHl
MRcwFQYDVQQKEw5WZXJpU2lnbiwgSW5jLjEfMB0GA1UECxMWVmVyaVNpZ24gVHJ1c3QgTmV0
d29yazFGMEQGA1UECxM9d3d3LnZlcmlzaWduLmNvbS9yZXBvc2l0b3J5L1JQQSBJbmNvcnAu
IGJ5IFJlZi4sTElBQi5MVEQoYyk5ODEmMCQGA1UECxMdRGlnaXRhbCBJRCBDbGFzcyAyIC0g
TmV0c2NhcGUxHTAbBgNVBAMTFERhbmllbCBDIEhlaWRlYnJlY2h0MRowGAYJKoZIhvcNAQkB
FgtkYW5Ad2RlLmNvbTBcMA0GCSqGSIb3DQEBAQUAA0sAMEgCQQDPDT3rywJGFln1SEhLK3TR
S3GiZ7s2MgXD7SpdKwIKSBAuUrqIV6Tm8zhQJ63sHcGGla1Dff/ST+nCuO05MdWDAgMBAAGj
gdMwgdAwCQYDVR0TBAIwADCBrwYDVR0gBIGnMIAwgAYLYIZIAYb4RQEHAQEwgDAoBggrBgEF
BQcCARYcaHR0cHM6Ly93d3cudmVyaXNpZ24uY29tL0NQUzBiBggrBgEFBQcCAjBWMBUWDlZl
cmlTaWduLCBJbmMuMAMCAQEaPVZlcmlTaWduJ3MgQ1BTIGluY29ycC4gYnkgcmVmZXJlbmNl
IGxpYWIuIGx0ZC4gKGMpOTcgVmVyaVNpZ24AAAAAAAAwEQYJYIZIAYb4QgEBBAQDAgeAMA0G
CSqGSIb3DQEBBAUAA4GBAHIDfBJvFMEnXcFxNsGfQSsBnmbON6jRXEodHoWLfm7Qa4uMFhqY
WHPDdw3qs9zdkUV5pYB+A+aEhwSqqEV9W+iHiOp5qsOzbupb/99J7zSeVt3yARvLXbGtLYbX
4V+1xhC+FU/Za92g3vwNANTZh1wx/oXpJGo/FzDTxklRxw3wMIIDGjCCAoOgAwIBAgIRAJzg
U17ybUJ/D7NEvSvaLYMwDQYJKoZIhvcNAQEEBQAwXzELMAkGA1UEBhMCVVMxFzAVBgNVBAoT
DlZlcmlTaWduLCBJbmMuMTcwNQYDVQQLEy5DbGFzcyAyIFB1YmxpYyBQcmltYXJ5IENlcnRp
ZmljYXRpb24gQXV0aG9yaXR5MB4XDTk4MDUxMjAwMDAwMFoXDTA0MDEwNjIzNTk1OVowgbgx
FzAVBgNVBAoTDlZlcmlTaWduLCBJbmMuMR8wHQYDVQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3
b3JrMUYwRAYDVQQLEz13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvUlBBIEluY29ycC4g
QnkgUmVmLixMSUFCLkxURChjKTk4MTQwMgYDVQQDEytWZXJpU2lnbiBDbGFzcyAyIENBIC0g
SW5kaXZpZHVhbCBTdWJzY3JpYmVyMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC1yxpU
XiWwLFlfCWvQ2tZKSxGdGgo+fi+3ZV8XYxXlLNAgAAzwumuqXkmxaJODJawkX6IjHGlNuDvb
fdqPwQnPpVg6tkvE1NvYrnX6hiKZIgEoYKXb1TDfIXBeSJmtIVSR0d5f+zgpUxvielNYxQ1d
EwezUMQGSzn4VKu5i2kSEwIDAQABo3wwejARBglghkgBhvhCAQEEBAMCAQYwRwYDVR0gBEAw
PjA8BgtghkgBhvhFAQcBATAtMCsGCCsGAQUFBwIBFh93d3cudmVyaXNpZ24uY29tL3JlcG9z
aXRvcnkvUlBBMA8GA1UdEwQIMAYBAf8CAQAwCwYDVR0PBAQDAgEGMA0GCSqGSIb3DQEBBAUA
A4GBAHYm/uX7R7J2sY9PNEe4SloN6wcDY7xluazuw3+5fo42Qohkx6p3BZ3b3bt4uFhfYhpu
vllrN+9I86yDf56SXhPIn8ipT5nJOlsh9bZ8w24lnPs8Ok3Nk2MiYz1Q0v1qfV8xXZzd+5GF
0sbYdyirWK6eANQnb6SouI20aKkkulVcMYIB5zCCAeMCAQEwgc0wgbgxFzAVBgNVBAoTDlZl
cmlTaWduLCBJbmMuMR8wHQYDVQQLExZWZXJpU2lnbiBUcnVzdCBOZXR3b3JrMUYwRAYDVQQL
Ez13d3cudmVyaXNpZ24uY29tL3JlcG9zaXRvcnkvUlBBIEluY29ycC4gQnkgUmVmLixMSUFC
LkxURChjKTk4MTQwMgYDVQQDEytWZXJpU2lnbiBDbGFzcyAyIENBIC0gSW5kaXZpZHVhbCBT
dWJzY3JpYmVyAhArJEezyiy5Q0QGw77FB2uIMAkGBSsOAwIaBQCggbEwGAYJKoZIhvcNAQkD
MQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNOTkwNDAyMTcwMjQ4WjAjBgkqhkiG9w0B
CQQxFgQU8qAp0NF61CstfrDa/0tgs3x6brwwUgYJKoZIhvcNAQkPMUUwQzAKBggqhkiG9w0D
BzAOBggqhkiG9w0DAgICAIAwBwYFKw4DAgcwDQYIKoZIhvcNAwICAUAwDQYIKoZIhvcNAwIC
ASgwDQYJKoZIhvcNAQEBBQAEQGN6ONiMzpBtPr1Yw/fhT/Nqh1A5BOBvSkaoUR6pGFFPvV/t
4puOxlXujPaBy4qIAgS9WnQQixGh4CIPDeCA2hw=
--------------ms42C8E59850A47F41EF48F0AD--