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
