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 index, where one of the fulltext indexed fields gets a value that is
a duplicate of an existing record's value in the same field.
pseudocode: (the field "title" has a fulltext index)
insert record id="a", title="test 123"
insert record id="b",title="test 1234"
update record set title="test 1234" where id="a"
and there's where the corruption happens- (but it's not seen by "check
table" until both records are deleted).
so- here's my hack.
after the update, i run the following sql query in php:
$result = mysql_query("repair table Works");
this seems to fix the problem, albeit with chewing gum.
any really bad problems with doing this?
-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
