Search error message

[trf]

I get the following on on a Custom View: with basic search

Failed to execute SQL. Error: Unknown column 'syllabus.visibility' in 'where clause'

In my custom view. I have a where visibility = 1

In advanced search there is no issue. I get the results.

Why is that?

[mobhar]

Make sure you have included the visibility column in the SELECT clause.