Filament (possibly laravel itself) using wrong mysql syntax

When going to one of my resources page, eloquent executes this query. notice that it uses WHERE user_id IS 2 instead of user_id = 2 every online syntax checker I try says that this is a wrong syntax and I am not sure why my app is using it.
No description
Solution:
I figured it out as I was answering your question :) I had a is inside my where clause instead of an =. not sure why. thanks!...
Jump to solution
2 Replies
Dennis Koch
Dennis Koch7mo ago
What DB are you using? Any special db driver? Can you share the Flare exception as mentioned in #✅┊rules ? What code lead to that exception?
Solution
Stormageddon, Dark Lord of All
I figured it out as I was answering your question :) I had a is inside my where clause instead of an =. not sure why. thanks!