Page 1 of 1
Unknown column 'XXX' in 'where clause'
Posted: Thu Apr 04, 2024 1:55 am
by 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
Re: Unknown column 'XXXXXX' in 'where clause'
Posted: Thu Apr 04, 2024 11:47 am
by arbei
Your description is too brief to reproduce. You should:
- Enable Debug to see the complete error,
- 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.)
- If the column 'XXXXXX' comes from your lookup filter, you better specify the fully qualified name (i.e. <table>.<field>).
Re: Unknown column 'XXX' in 'where clause'
Posted: Sun Apr 07, 2024 3:40 pm
by andyrav
This was because my table had the wrong field type