Filter with more than two options causes fatal error

[vox]

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&region=3=
which doesn't seem right either. Do you have any ideas?

I use TL 2.8.3, catalog 2.0.0 b1

[thyon]

Have you not set-up a condition is the pre-filter condition string?

[vox]

Hi,

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?)

[thyon]

Can't help you any further, unless we can see the config screens, to see what you're doing.

[MacKP]

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

[vox]

Thanks, in my case it doesn't make sense to set an additional condition.

[thyon]

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.

[xtra]

I hope I fixed it with Revision 179.

Was a little bit nasty to track down.