Dear all, I have installed mysql 4.0.2 alpha log (actually compiled by me) in a linux box (Mandrake 8.2) and for 2 months was working perfectly. After migrating some data from an other installation (Windows 2000 / mysql 4.0.1 alpha log) my FULL-TEXT indexes stop functioning. I am issuing the following statement but no FULL-TEXT index is created. DROP TABLE IF EXISTS e_genlogmatergroup; CREATE TABLE `e_genlogmatergroup` ( `genlogmatergroupid` decimal(10,0) NOT NULL default '0', `genlogmatergrouptitle` text, `genlogmatergroupcont` text, `genlogmatergroupparent` decimal(10,0) default '0', `chapter` varchar(255) default NULL, `genlogmatergroup` varchar(255) default NULL, `genlogmaterdateins` date default NULL, `infopg` tinyint(3) unsigned default '0', PRIMARY KEY (`genlogmatergroupid`), FULLTEXT KEY `genlogmatergrouptitle` (`genlogmatergrouptitle`), FULLTEXT KEY `genlogmatergroupcont` (`genlogmatergroupcont`), FULLTEXT KEY `compound_e_genlogmatergroup` (`genlogmatergroupcont`,`genlogmatergrouptitle`) ) TYPE=MyISAM;
Any Ideas?????? Thanks in advance Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 --------------------------------------------------------------------- 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
