Filter with more than two options causes fatal error
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
Re: Filter with more than two options causes fatal error
Have you not set-up a condition is the pre-filter condition string?
Re: Filter with more than two options causes fatal error
Hi,
Quote:
Originally Posted by thyon
Have you not set-up a condition is the pre-filter condition string?
What do you mean? (Probably not, how would I set this up and where?)
Re: Filter with more than two options causes fatal error
Can't help you any further, unless we can see the config screens, to see what you're doing.
Re: Filter with more than two options causes fatal error
Hey i have found it i think.
There was no Condition in the lister..
When i fill in something that would never be there like 'date!=1900' it works finde.
I think i never used a catalog without that, so i have not thought about that point ^^
thyon should i make a bug report?
regards
Re: Filter with more than two options causes fatal error
Thanks, in my case it doesn't make sense to set an additional condition.
Re: Filter with more than two options causes fatal error
Never heard of this before. Always worked with just 1 filter. Need to be very specific in report as the vox guy didn't give much info.
Re: Filter with more than two options causes fatal error
I hope I fixed it with Revision 179.
Was a little bit nasty to track down.