i dont know what is the problem with my search fuction or databse but when i try to access https://ide50-username.cs50.io/search.php?geo=Cambridge,Massachusetts,US it gives me an error showing:

Fatal error: Can't find FULLTEXT index matching the column list in /home/ubuntu/workspace/pset8/vendor/library50-php-5/CS50/CS50.php on line 352

I dont know what to do i m stuck here from past few days anybody please help


1 Answer 1


It means a field or fields in the MATCH clause are not in a FULLTEXT index, as in this "hint" from the spec.

CS50::query("SELECT * FROM places WHERE MATCH(postal_code, place_name) AGAINST (?)", $_GET["geo"])

This query searches not only on postal_code but also on place_name, but it leaves it to MySQL to figure out how. It assumes, though, that you’ve defined a FULLTEXT index jointly on postal_code and place_name, which you can do via phpMyAdmin’s Structure tab. (See if you can determine how!)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .