SQLSTATE[HY000]: General error: 21 bad parameter or other API misuse` after updating TNTSearch.

[hanspagel]

Seeing warnings when running tests:

SQLSTATE[HY000]: General error: 21 bad parameter or other API misuse

Works fine before these updates:

- Updating teamtnt/tntsearch (v1.0.7 => v1.2.0): Loading from cache
- Updating teamtnt/laravel-scout-tntsearch-driver (v3.0.4 => v3.0.5): Loading from cache

Latest Laravel, PostgreSQL 10.1. Any ideas?

[nticaric]

Any chance you are running php 7.2?

[hanspagel]

Exactly, you are right! Forgot to mention it.

[nticaric]

#127

[nticaric]

Can you try v3.0.6, hopefully it should be fixed

[hanspagel]

Fixed! :)))

[hanspagel]

Ah, sorry. It's not fixed. Scout was disabled in testing environment. Still the same message with teamtnt/laravel-scout-tntsearch-driver 3.0.6.

[spacemudd]

PHP 7.2 here.

The first time this error occured to me is when I try to insert 2k+ records into a sqlite db.

Then I started encountering it with TNTSearch like OP.

I'm getting the error when retrieving records using Scout's paginate() method.

Reverting back to 7.1, which works fine.