0

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

Thanks

0

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!)

| improve this answer | |

You must log in to answer this question.

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