laravel-scout-tntsearch-driver icon indicating copy to clipboard operation
laravel-scout-tntsearch-driver copied to clipboard

Published 20 hours ago • verified publisher icon teamtnt

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

Open hanspagel opened this issue 6 years ago • 7 comments

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?

hanspagel avatar Dec 13 '17 20:12 hanspagel

Any chance you are running php 7.2?

nticaric avatar Dec 18 '17 14:12 nticaric

Exactly, you are right! Forgot to mention it.

hanspagel avatar Dec 18 '17 14:12 hanspagel

#127

nticaric avatar Dec 18 '17 21:12 nticaric

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

nticaric avatar Dec 18 '17 22:12 nticaric

Fixed! :)))

hanspagel avatar Dec 20 '17 10:12 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.

hanspagel avatar Dec 21 '17 16:12 hanspagel

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.

spacemudd avatar Dec 23 '17 07:12 spacemudd