Hi,
I've set up a small catalog with one entry so far, some select fields that get their value from taxonomy, a list, a reader and a filter that should filter the list (no entries are shown before the user selects something).
It worked until I added a second filter option:
'Fatal error: Uncaught exception Exception with message Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND region=3' at line 1 (SELECT DISTINCT(position) FROM jobs WHERE AND region=3) thrown in /www/htdocs/reichofa/motus/system/libraries/Database.php on line 599'
See the example here:
http://motus.hotelfachschule-berlin....job-test2.html
It seems like a faulty query as there is nothing between WHERE and AND. If I set TL/Contao to not use page aliases, the URL looks like
http://motus.hotelfachschule-berlin....=134®ion=3=
which doesn't seem right either. Do you have any ideas?
I use TL 2.8.3, catalog 2.0.0 b1
Bookmarks