Full-Text Help

[madk]

Could someone tell me why this query is not working? If I run it on just subject or just post, it works. But when I add both tables I get an error.

SELECT * FROM ds_posts WHERE MATCH (subject, post) AGAINST('$find')

subject is char(100)
post is text

Please help as I am pulling my hair out.

[madk]

I'm getting

"1191 - Can't find FULLTEXT index matching the column list "

Got it..indexes weren't setup correctly