[TYPO3-english] andWhere internal server error

Katja Lampela katja.lampela at lieska.net
Thu May 17 09:44:54 CEST 2012


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


-- 
With kind regards

Katja Lampela
*Lieska-tuotanto*
www.lieska.net



More information about the TYPO3-english mailing list