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

[Bug]: Unknown column 'status' in 'where clause' when using search #10

Open
thyseus opened this issue Jan 7, 2025 · 1 comment
Open
Assignees
Labels
bug Something isn't working

Comments

@thyseus
Copy link

thyseus commented Jan 7, 2025

What happened?

I am in the overview of the e-mails and want to search for a string in the filament table search:

ERROR: Error occurred on line 825 of file /usr/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php: 
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'where clause' 
(Connection: mysql, SQL: select count(*) as aggregate from mails where sent_at is not null and (status like %lange% or subject like %lange% or html like %lange% or text like %lange% or attachments like %lange% or to like %lange% or opens like %lange% or clicks like %lange% or sent_at like %lange%)) 
(View: /usr/www/vendor/filament/tables/resources/views/index.blade.php) (View: /usr/www/vendor/filament/tables/resources/views/index.blade.php)

How to reproduce the bug

Search for something in the index view of mails

Package Version

1.0

PHP Version

8.3

Laravel Version

11.0

Which operating systems does with happen with?

Linux

Notes

No response

@thyseus thyseus added the bug Something isn't working label Jan 7, 2025
@markvaneijk
Copy link
Member

@arduinomaster22 can you look into this one?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

When branches are created from issues, their pull requests are automatically linked.

3 participants