raymondrna
-
Posts
1 -
Joined
-
Last visited
Never
raymondrna's Achievements
Newbie (1/5)
0
Reputation
-
[code] show index from vinyl; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id: 2986025 Current database: records +-------+------------+------------+--------------+-------------+-----------+----- --------+----------+--------+----------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Card inality | Sub_part | Packed | Comment | +-------+------------+------------+--------------+-------------+-----------+----- --------+----------+--------+----------+ | vinyl | 0 | PRIMARY | 1 | catalog | A | 1 | NULL | NULL | | | vinyl | 1 | full_index | 1 | label | A | NULL | NULL | NULL | FULLTEXT | | vinyl | 1 | full_index | 2 | title | A | NULL | NULL | NULL | FULLTEXT | | vinyl | 1 | full_index | 3 | composer | A | NULL | NULL | NULL | FULLTEXT | | vinyl | 1 | full_index | 4 | conducter | A | NULL | NULL | NULL | FULLTEXT | | vinyl | 1 | full_index | 5 | performer | A | NULL | NULL | NULL | FULLTEXT | +-------+------------+------------+--------------+-------------+-----------+----- --------+----------+--------+----------+ 6 rows in set (0.01 sec) mysql> select * from vinyl -> where match (title) against ('Symphony'); ERROR: mysql> mysql> select * from vinyl -> where match (title) against ('Symphony'); ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id: 2986047 Current database: records ERROR 1191: Can't find FULLTEXT index matching the column list mysql> [/code] what's going on? I ask mysql to describe the index and it tells me it's there. Do a match, and match tells me it's not? I'm guessing this is a simple syntax mistake, but I'm new with mysql and it seems like what I'm going should just work. :P Thanks for the help and your infinite wisdom!!