Edirectory help please

[ad7863]

Hello there, I have a website http://www.NewYorkLocal.co and I need some help with the script I am using. The search doesn't seem to be functioning correctly. I get this error message:

 

Database Error. System Administrator has been notified and this problem will be solved as soon as possible. We are sorry for the inconvenience.

 

and then I get this email:

 

ERROR: http://newyorklocal.co/results.php

 

Query: SELECT COUNT(DISTINCT(Event.id)) FROM Event WHERE Event.status = 'A' AND Event.end_date >= DATE_FORMAT(NOW(), '%Y-%m-%d') AND MATCH (Event.fulltextsearch_keyword) AGAINST ('Sylhet Sylhets Motors Motor Inc. Inc.s') ORDER BY Event.id

 

Errno: 1191

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

_SERVER data

REMOTE_ADDR : 94.3.240.221

REMOTE_PORT : 54232

SCRIPT_FILENAME : /home/wwwjowk/public_html/nylocal/results.php

REQUEST_METHOD : GET

QUERY_STRING : keyword=Sylhet+Motors+Inc.&where=&template_id=

REQUEST_URI : /results.php?keyword=Sylhet+Motors+Inc.&where=&template_id=

 

Now I must say, I'm very inexperienced when it comes to PHP but I really need to get this sorted. Any ideas?

 

Thank you very much in advance.

[sgchris]

it looks like you did not set "fulltextsearch_keyword" field as a "FULLTEXT" index.

in phpMyAdmin it's in structure tab of the table at the bottom of the page

[ad7863]

Hello, thanks for the reply.

 

I have made sure that it is set to FULLTEXT and I still get an error.

 

 

Here, you can see a screenshot:

 

http://cl.ly/1M3l332Z050Y3y3D1u3H

[ad7863]

The search seems to be working fine and the results that it's returning are correct, including advanced search. I can't see why I still get an error and an email.

 

The error is as below.

 

Database Error. System Administrator has been notified and this problem will be solved as soon as possible. We are sorry for the inconvenience.

[ad7863]

Any other ideas guys?