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

[3.0 & 2.1]: Database Error: syntax error, unexpected '+', expecting FTS_TERM or FTS_NUMB or '*' #8350

Open
sbulen opened this issue Dec 3, 2024 · 0 comments

Comments

@sbulen
Copy link
Contributor

sbulen commented Dec 3, 2024

Basic Information

I have started getting errors on my 2.1 forum, which I had recently cut over to using fulltext search. (Previously I had used a custom index, I was trying to see if a fulltext search would resolve other search issues, see #7870...)

I have not been able to reproduce. I am assuming both 2.1 & 3.0 are affected since the codebases are similar.

I was hoping someone familiar with the fulltext syntax could look into this.

The errors are:
Database Error: syntax error, unexpected '+', expecting FTS_TERM or FTS_NUMB or '*'
Database Error: syntax error, unexpected ')', expecting $end

Both errors are on /Sources/SearchAPI-Fulltext.php Line 297
Both errors are on https://yadayada/index.php?action=search2

Steps to reproduce

  1. I do not know how to reproduce at this time

Expected result

No response

Actual result

No response

Version/Git revision

2.1.4

Database Engine

MySQL

Database Version

8.0.36

PHP Version

8.2.24

Logs

Errors have the same backtrace:
    #0: smf_db_error()
    Called from /yada/yada/yada/smf/Sources/Subs-Db-mysql.php on line 494
    #1: smf_db_query()
    Called from /yada/yada/yada/smf/Sources/SearchAPI-Fulltext.php on line 297
    #2: indexedWordQuery()
    Called from /yada/yada/yada/smf/Sources/Search.php on line 1588
    #3: PlushSearch2()
    Called from /yada/yada/yada/smf/index.php on line 224

Additional Information

No response

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant