Project

General

Profile

Actions

Anomalie #1125

closed

error n° 1064 : syntax error, unexpected '@', expecting $end - [< v2.2]

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

Status:
Rejeté
Priority:
Normal
Assignee:
Category:
general
Target version:
Start date:
03/24/2021
Due date:
% Done:

100%

Estimated time:
1.00 h
Resolution:

Description

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(';Bg@dgwCrbTI:KqO') 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 (';Bg@dgwCrbTI:KqO' IN BOOLEAN MODE) AND project_statut<>'E' AND project_statut<>'AA' AND project_statut<>'D' ORDER BY pertinence DESC;

See also : https://stackoverflow.com/questions/25088183/mysql-fulltext-search-with-symbol-produces-error-syntax-error-unexpected

Actions

Also available in: Atom PDF