search

teamtnt / laravel-scout-tntsearch-driver

Driver for Laravel Scout search package based on https://github.com/teamtnt/tntsearch
MIT License
1.1k stars 144 forks source link

Unknown column '__soft_deleted' in 'where clause' when 'soft_delete' => true in scout config #184

Closed ge022 closed 6 years ago

ge022 commented 6 years ago

I am not sure if this is an issue with scout or tntsearch. I am getting error "SQLSTATE[42S22]: Column not found: 1054 Unknown column '__soft_deleted' in 'where clause' (SQL: select..." when trying to search. I am using "laravel/scout" version "v4.0.4", and teamtnt/laravel-scout-tntsearch-driver" version"v3.0.7". I have tried flushing and importing the index.

thoresuenert commented 6 years ago

@ge022 we will deliver a fix for that. Laravel scout set a custom field in where clauses with the name “__soft_deleted”. We introduced this error while adding where clause support.

michaelklopf commented 6 years ago

We created a fix, see https://github.com/teamtnt/laravel-scout-tntsearch-driver/pull/191