Nick, ok, so that kills my working theory. Also, glad to see you have an ID field.
Upgrade your Linux MySQL server. I seem to remember a recent version being compiled against a bad library or something and it was causing problems only on the Linux version. The latest (.51) does not have this issue. See if that clears it up. =C= * * Cal Evans * Techno-Mage * http://www.calevans.com * ----- Original Message ----- From: "Nick Traenkner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 12:18 PM Subject: Re: delete corrupts > mysql Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686) > > i have been using both the mysql CLI and a php script using the > mysql_query() function. > > here's how this error is being tested: > > insert a record > > (php) insert into Works (id,Title,Desc,HTML) values ('39b81e034','Test > 123','',''); > (php) insert into Works (id,Title,Desc,HTML) values ('39a413923','Test > 1234','',''); > > (cli) check table Works; > > 67046_3.Works | check | status | OK > > then... > > (php) update Works set Title='Test 1234' where id='39b81e034'; > (php) update Works set HTML = '<a href="http://www.google.com/">link</a>' > where id='39b81e034'; > > (cli) check table Works; > > 67046_3.Works | check | status | OK > > then... > > (php || cli) delete from Works where id='39a413923'; > > (cli) check table Works; > > 67046_3.Works | check | status | OK > > then... > > (php || cli) delete from Works where id='39b81e034'; > > (cli) check table Works; > > | Works | check | error | Found 824 keys of 825 | > | 67046_3.Works | check | error | Corrupt > > > BUT if i run > > (cli) repair table Works; > > after the update everything is fine. > > So it would seem that the update corrupts something but this corruption > doesnt show up until the second delete. > > I am looking into the update function i am using in php. > > -nick > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "Nick Traenkner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, June 13, 2002 12:51 PM > Subject: Re: delete corrupts > > > > What version of MySQL? > > What interface are you using to execute the delete? > > > > How do you know you only deleted one of the records? From a CLI, without a > > PK, there would be no way to delete only one. Delete from Works where > title > > = something would delete both of them. > > > > =C= > > * > > * Cal Evans > > * Techno-Mage > > * http://www.calevans.com > > * > > > > ----- Original Message ----- > > From: "Nick Traenkner" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Thursday, June 13, 2002 11:32 AM > > Subject: delete corrupts > > > > > > > sql query > > > > > > once again... > > > > > > I am using PHP. > > > > > > i have a table (called Works) with two fulltext indices, one (Title) is > a > > > varchar(64) and the other (Desc) is a longtext. > > > > > > when there are two records having the same value in Title and I delete > one > > > of the records i recieve the following result from "check table Works" > > > > > > +---------------+-------+----------+-----------------------+ > > > | Table | Op | Msg_type | Msg_text | > > > +---------------+-------+----------+-----------------------+ > > > | Works | check | error | Found 825 keys of 826 | > > > | 67046_3.Works | check | error | Corrupt | > > > +---------------+-------+----------+-----------------------+ > > > > > > i am nearing wits end. this does not happen on windows 2000, only on > > linux. > > > > > > -nick > > > > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php