Project

General

Profile

Actions
Copy link

Anomalie #1285

closed

fix search error [ error n° 1271 : Illegal mix of collations for operation 'match' ]

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

Status:
Fermé
Priority:
Normal
Assignee:
Simon
Category:
general
Target version:
2.5
Start date:
02/04/2022
Due date:
% Done:

100%

Estimated time:
1.00 h
Resolution:

Description

Seems to be due to mysql-server update :

Version du serveur : 8.0.27-0ubuntu0.21.10.1 - (Ubuntu)

Actions
Copy link
 #1

Updated by Simon almost 3 years ago

only on project ?

Maybe on localhost only :

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_opgoal,project_description,project_body,project_comment,project_budget_comment, project_cal_comment, project_elected, project_team) AGAINST('aaa') AS pertinence FROM l21_project WHERE MATCH (project_name,project_goal,project_opgoal,project_description,project_body,project_comment, project_cal_comment, project_budget_comment, project_elected, project_team) AGAINST ('aaa' IN BOOLEAN MODE) AND project_statut<>'E' AND project_statut<>'AA' AND project_statut<>'D' ORDER BY pertinence DESC;
Actions
Copy link
 #2

Updated by Simon almost 3 years ago

  • Status changed from Nouveau to Fermé
  • % Done changed from 0 to 100

probably due to development. Fixed

Should be ok on production

Actions
Copy link

Also available in: Atom PDF