loopback-connector-mysql icon indicating copy to clipboard operation
loopback-connector-mysql copied to clipboard

FULLTEXT | MYSQL | failed with status code 500. Error: ER_PARSE_ERROR: You have an error in your SQL syntax;

Open MwSpaceLLC opened this issue 2 years ago • 1 comments

Describe the bug

Hi there,

Today we try to fulltextsearch with mysql, after install system, and configure as follow: image

Our application model: image

Our request crud (get): image

Server response: image

System as installed with clear installation and clear mode, repo & crud generation.

Logs

No response

Additional information

Install loopback, generate model, add fulltextindex, add mysql datasource, query with match fulltext query

Reproduction

Sorry, dataset has private, we can reproduce error with dataset demo.

MwSpaceLLC avatar Dec 05 '22 00:12 MwSpaceLLC