Using MySQL version 3.23.39 on a Win2k server with SP2, I have some problems with the FULLTEXT index. I have a table created like this: 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`), KEY `kategori_id` (`kategori_id`), KEY `bruger_id` (`visitkort`), KEY `postnr` (`postnr`), KEY `email` (`email`), FULLTEXT KEY `ft` (`navn`,`beskrivelse`,`tekst1`,`tekst2`,`tekst3`,`tekst4`) ) TYPE=MyISAM; Currently there are 338 rows in the table. What happens is, that when somebody adds a new row, the index file is not closed. myisamchk with the --extend-check option says: mysamchk: warning: 1 clients is using or hasn't closed the table properly The result of this is, that if anyone is trying to update the same record afterwards, the index is corrupted. If I *remove* the FULLTEXT index entirely from the table (drop index), the error does not occur. The table is updated through a webbased client, that I've made in PHP 4.0.5. I've checked the code, and it seems to me, that I explicitely close all connections to the database before exiting a script. Besides, the above test with removing the index kind of rules out, that it has anything to with the script. Are there any limitations to FULLTEXT indices? I know it's a large table with 4 TEXT fields, but is that prone to error? - Carsten --------------------------------------------------------------------- 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
