Excuse if i'm not correct but this may be your problemo ?
MySQL 3.23.55 running on my webhost's Linux box
phpMyAdmin 2.1.0
I didnt think fulltext was in 3.23 wasnt this a Mysql 4 feature ??
> Summary: When I run a fulltext search, it always returns no results. I
> have added a fulltext index to the column being searched. Also, I am
> searching for a term that is in the table, but not in more than 50% of
> the rows.
>
> I notice that when I add EXPLAIN to my search, the key_len of my
> fulltext index is 0. Does that mean my fulltext index is empty,
> explaining why my searches never return any results?
>
> Either way, I'd be grateful for any suggestions on how to get fulltext
> search to work!
>
>
> Config:
> MySQL 3.23.55 running on my webhost's Linux box
> phpMyAdmin 2.1.0
>
>
> Long description:
> My test database has two tables and 16 rows. The table named "entry"
> starts out looking like this:
>
>
> Field Type Attributes Null Default Extra
> -------------------------------------------------------------------
> itemid mediumint(8) UNSIGNED No 0
> permid mediumint(8) UNSIGNED No 0
> eventtime datetime No 0000-00-00 00:00:00
> subject varchar(255) Yes
> event text Yes
> current_music varchar(255) Yes
> current_mood varchar(255) Yes
>
> Indexes
> Keyname Unique Field
> --------------------------
> PRIMARY Yes itemid
>
>
> To allow fulltext search, I add a fulltext index via phpMyAdmin's "Run
> SQL query" textarea:
>
> ALTER TABLE entry ADD FULLTEXT subject_index (subject);
>
>
> I log out of and back into phpMyAdmin. Now there is a new row in the
> list of indexes:
>
> Keyname Unique Field
> ------------------------------
> PRIMARY Yes itemid
> subject_index No subject
>
>
> I do a fulltext search for a term I know is in the "subject" data:
>
> SELECT subject FROM entry WHERE MATCH (subject) AGAINST ('contact');
>
>
> But I get back an error/empty results:
>
>>Error
>>
>>SQL-query:
>>
>>SELECT subject FROM entry WHERE MATCH (subject) AGAINST ('contact');
>>
>>MySQL said:
>
>
> I run the query again, using EXPLAIN:
>
> EXPLAIN SELECT subject FROM entry WHERE MATCH (subject) AGAINST
> ('contact');
>
>
> The query is echoed (with an additional LIMIT apparently added by
> phpMyAdmin):
>
> EXPLAIN SELECT subject FROM entry WHERE MATCH (subject) AGAINST
> ('contact'); LIMIT 0, 30
>
>
> And the EXPLAIN output is:
>
> table type possible_keys key key_len ref rows
> Extra
> --------------------------------------------------------------------------
> entry fulltext subject_index subject_index 0 1 where
> used
>
> _________________________________________________________________
> Watch high-quality video with fast playback at MSN Video. Free!
> http://click.atdmt.com/AVE/go/onm00200365ave/direct/01/
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
