Project

General

Profile

Actions

Evolution #1176

closed

fix SQL issue on search

Added by Simon about 3 years ago. Updated about 3 years ago.

Status:
Fermé
Priority:
Normal
Assignee:
Category:
general
Target version:
Start date:
09/21/2021
Due date:
% Done:

100%

Estimated time:
0.50 h
Resolution:

Description

[ 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;
Actions

Also available in: Atom PDF