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
Unknown column 'XXX' in 'where clause'
-
- User
- Posts: 642
Unknown column 'XXX' in 'where clause'
-
- User
- Posts: 9424
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>).