Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
MwSpaceLLC opened this issue Dec 5, 2022 · 3 comments
Labels

Comments

@MwSpaceLLC
Copy link

MwSpaceLLC commented Dec 5, 2022

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 MwSpaceLLC added the bug label Dec 5, 2022
@MwSpaceLLC MwSpaceLLC changed the title FULLTEXT | failed with status code 500. Error: ER_PARSE_ERROR: You have an error in your SQL syntax; FULLTEXT | MYSQL | failed with status code 500. Error: ER_PARSE_ERROR: You have an error in your SQL syntax; Dec 5, 2022
@MwSpaceLLC
Copy link
Author

@achrinza
Copy link
Member

achrinza commented Dec 5, 2022

Duplicate of loopbackio/loopback-connector-mysql#475

@achrinza
Copy link
Member

achrinza commented Dec 8, 2022

Hi @MwSpaceLLC, I'll proceed to close this issue in favour of the other one linked above so as to ease tracking.

I've added the other issue to the icebox for triaging.

@achrinza achrinza closed this as not planned Won't fix, can't repro, duplicate, stale Dec 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants