FULLTEXT related problem on "search"

Hello there, I have recently updated my site http://tinyurl.com/asg8hj by adding a new database.

When I use the "search" feature, I get this error:

Error: Can't find FULLTEXT index matching the column list

Code (markup):

Kindly tell me what do I need to do to correct it?

FYI, I am using phpMyadmin.

Thanks!

 

you need to add fulltext into mysql table field via phpmyadmin
check the query which table and field is needed for the search and add a query like this into phpmyadmin

ALTER TABLE `yourtblname` ADD FULLTEXT (`fieldname`)

 

Thanks for the reply crivion, my site is http://tinyurl.com/asg8hj

When I try to use the search box to find a lyric, I get this problem. I have tried to put this query in SQL

ALTER TABLE `lyrics` ADD FULLTEXT (`title,artist,album`)

But I get this error:

What should I do?

 

do it like this
ALTER TABLE `lyrics` ADD FULLTEXT (`title`,`artist`,`album`)

 

Oh my God! It worked! You are a genius crivion! I appreciate this effort.+ rep for you.

A guy from here only was asking for $25 to fix it, and I never knew it was that easy (you made it easier for me). Thanks for saving my money and my site!

God bless you!