Column Not Found SQL ERROR

Hello there filament,

Love the admin panel, tough I have a weird issue I can't figure out.

When I sort the visible 'Venue names' I get an SQL error saying Column not found.

I get the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'questions.venue_id' in 'where clause'

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'questions.venue_id' in 'where clause'

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'questions.venue_id' in 'where clause'

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'questions.venue_id' in 'where clause'

I believe the query it fails on is:

select `name` from `venues` where `questions`.`venue_id` = `venues`.`id`;

select `name` from `venues` where `questions`.`venue_id` = `venues`.`id`;

select `name` from `venues` where `questions`.`venue_id` = `venues`.`id`;

select `name` from `venues` where `questions`.`venue_id` = `venues`.`id`;

But if I run

SELECT VENUE_ID FROM QUESTIONS;

SELECT VENUE_ID FROM QUESTIONS;

SELECT VENUE_ID FROM QUESTIONS;

SELECT VENUE_ID FROM QUESTIONS;

On my database I do get all venue_id returned

Column Not Found SQL ERROR

Similar Threads

Similar Threads

Similar Threads