Unknown column 'XXX' in 'where clause'

[andyrav]

When i have multiple extended search dropdown load with the second having a parent field of the first when i click search i get
vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php(67): An exception occurred while executing a query: Unknown column 'XXXXXX' in 'where clause'
any ideas.
thanks

[arbei]

Your description is too brief to reproduce. You should:

1. Enable Debug to see the complete error,
2. Check where the column 'XXXXXX' comes from. If you are using a field which is not in the current table (e.g. your page is a view), it won't work. (Do not use Custom View, always use database view.)
3. If the column 'XXXXXX' comes from your lookup filter, you better specify the fully qualified name (i.e. <table>.<field>).

[andyrav]

This was because my table had the wrong field type