seems I may need to upgrade to .51, but as the server I am running on is
hosted and I may not be able to get them to install the latest mysql
version, I have come up with the following hack...
to recap my problem:
I am getting a corruption when I update a table that uses two fulltext and
one PK
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: de
e 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" <[EMA
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Ralf Narozny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Nick Traenkner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 12:05 PM
Su
[EMAIL PROTECTED] wrote:
>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
-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 ha
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
