Linea21

[ error n° 1191 : Can't find FULLTEXT index matching the column list ]
SQL query : SELECT project_id, project_name, DATE_FORMAT(project_published_date, '%d-%m-%Y') AS date_display, project_statut AS statut, MATCH(project_name,project_goal,project_description,project_body,project_comment,project_budget_comment, project_elected, project_team) AGAINST('energie') AS pertinence FROM l21_project WHERE MATCH (project_name,project_goal,project_description,project_body,project_comment,project_budget_comment, project_elected, project_team) AGAINST ('energie' IN BOOLEAN MODE) AND project_statut<>'E' AND project_statut<>'AA' AND project_statut<>'D' ORDER BY pertinence DESC;