[TYPO3-english] andWhere internal server error

[Katja Lampela]

sorry this has wrong field names, vuosi should be year


17.5.2012 10:44, Katja Lampela kirjoitti:
> Hi,
>
> Any idea why following andWhere gives Internal Server Error (500):
>
> andWhere = tx_klfilms_category.UID = 16 AND tx_klfilms_film.year>= YEAR(CURDATE()) OR tx_klfilms_film.year = 0
>
> So I need the category 16 and the year field has to this or future year or empty year field.
>
>
> In another page this works ok (where I want to show past years records and also the year field has to be filled):
>
> andWhere = tx_klfilms_category.UID = 16 AND tx_klfilms_film.vuosi<  YEAR(CURDATE()) AND tx_klfilms_film.vuosi>  0
>
>