BTW: As I've stated earlier, the error goes away, if you either remove the
FULLTEXT index or let the affected fields accept NULL values.
- Carsten
----- Original Message -----
From: "Carsten Gehling" <carsten@stripped>
To: "Sergei Golubchik" <serg@stripped>
Cc: <mysql@stripped>
Sent: Friday, July 20, 2001 12:06 PM
Subject: Re: Bug report: FULLTEXT index corrupts the index with too many
TEXT fields
> I'm going to Spain today and cannot respond to any questions in the next
> week. I was going to wait with this until I got home again, but what the
> heck ;-)
>
> Run the following script through your MySQL on an empty database with
>
> mysql -uusername -ppassword dbname <scriptname
>
> and the last command should produce the following error:
>
> ERROR 1034 at line 31: Incorrect key file for table: 'visitkort'. Try to
> repair it
>
> I've let 3 people besides myself test it, and they all get the same error.
> It has now been tested on:
>
> Win2k server SP2, MySQL 3.23.32
>
> Win2k server SP2, MySQL 3.23.39
>
> Win2k Pro (Danish), MySQL 3.23.33 (normal version)
>
> Win2k Pro SP2 (English), MySQL 3.23.38-MAX
>
> Debian GNU/Linux, MySQL 3.23.39 (bniary .deb package)
>
> Some other Linux (didn't get the distro name), MySQL 3.23.39
>
> All of the above produces the error. So something must be wrong.
>
> Sincerily,
> - Carsten
>
> Here's the script:
>
> ##################################################
> CREATE TABLE `visitkort` (
> `id` int(10) unsigned NOT NULL auto_increment,
> `kategori_id` int(10) unsigned NOT NULL default '0',
> `aktiv` tinyint(3) unsigned NOT NULL default '0',
> `navn` varchar(60) NOT NULL default '',
> `adresse` varchar(150) NOT NULL default '',
> `postnr` varchar(5) NOT NULL default '',
> `tlf` varchar(20) NOT NULL default '',
> `fax` varchar(20) NOT NULL default '',
> `email` varchar(60) NOT NULL default '',
> `password` varchar(20) NOT NULL default '',
> `url` varchar(150) NOT NULL default '',
> `beskrivelse` varchar(200) NOT NULL default '',
> `visitkort` tinyint(3) unsigned NOT NULL default '0',
> `skabelon` tinyint(3) unsigned NOT NULL default '0',
> `logo` tinyint(3) unsigned NOT NULL default '0',
> `billede` tinyint(3) unsigned NOT NULL default '0',
> `tekst1` text NOT NULL,
> `tekst2` text NOT NULL,
> `tekst3` text NOT NULL,
> `tekst4` text NOT NULL,
> PRIMARY KEY (`id`),
> FULLTEXT KEY `ft`
> (`navn`,`beskrivelse`,`tekst1`,`tekst2`,`tekst3`,`tekst4`)
> ) TYPE=MyISAM;
>
> insert into visitkort (kategori_id) values (108);
>
> update visitkort set navn = 'test5' where id = last_insert_id();
>
> update visitkort set tekst1 = 'bla bla' where id = last_insert_id();
> ##################################################
>
>
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread80247@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-##L=##H@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
