At 04:05 PM 9/10/2002 +0300, you wrote: >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.
I have tested on 4.0.3 and it worked fine also for me. Perfect job also with Greek charset and full-text search. Remains a little problem with the sorting order of accented capital letters caused by the erroneous ../share/mysql/charsets/greek.conf file. I have already look in the documentation bat i could not understand understand how to correct the existing one or write one from the scratch. Could you advise me on this issue???? Also i discovered a bug of mysqlfront and phpmyadmin 2.3.0 (they dont report correctly the fulltext indexes.) With thanks Nikos >-- >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 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
