Nikolaos, Monday, September 09, 2002, 7:51:43 PM, you wrote: NG> I have installed mysql 4.0.2 alpha log (actually compiled by me) in a linux NG> box (Mandrake 8.2) and for 2 months was working perfectly. After migrating NG> some data from an other installation (Windows 2000 / mysql 4.0.1 alpha log) NG> my FULL-TEXT indexes stop functioning. I am issuing the following statement NG> but no FULL-TEXT index is created. NG> DROP TABLE IF EXISTS e_genlogmatergroup; NG> CREATE TABLE `e_genlogmatergroup` ( NG> `genlogmatergroupid` decimal(10,0) NOT NULL default '0', NG> `genlogmatergrouptitle` text, NG> `genlogmatergroupcont` text, NG> `genlogmatergroupparent` decimal(10,0) default '0', NG> `chapter` varchar(255) default NULL, NG> `genlogmatergroup` varchar(255) default NULL, NG> `genlogmaterdateins` date default NULL, NG> `infopg` tinyint(3) unsigned default '0', NG> PRIMARY KEY (`genlogmatergroupid`), NG> FULLTEXT KEY `genlogmatergrouptitle` (`genlogmatergrouptitle`), NG> FULLTEXT KEY `genlogmatergroupcont` (`genlogmatergroupcont`), NG> FULLTEXT KEY `compound_e_genlogmatergroup` NG> (`genlogmatergroupcont`,`genlogmatergrouptitle`) NG> ) TYPE=MyISAM;
NG> Any Ideas?????? I tested your example on 4.0.3 and it worked fine for me. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
