Textpattern Search Problems

A quick note for others who might have the same problem. I’ve been having trouble with the output of search on Retrorocket. I’ve defined a specific section to take the output, but there’d be no results after executing a query.

I turned on Textpattern’s debugging option, and found this error message:

Can’t find FULLTEXT index matching the column list

After a bit of digging around online, I found that there needs to be a fulltext index in the MySQL database. I did a quick trip to my new best friend, PHPMyadmin, and added full text to the main contents table on my textpattern database. So now search works again! W00t!

Warning: I am not a database expert by any stretch. Do not take advice internally. I think I’m probably a little bit better than a cargo cultist at this kind of thing. But you never know.