[TYPO3-english] andWhere internal server error

Philipp Gampe philipp.gampe at typo3.org
Thu May 17 12:27:40 CEST 2012

Hi Katja,

Katja Lampela wrote:

> 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.

I think you have an SQL error.
What does "empty year" mean? I mean what is stored in the SQL Database for 
an empty year.
Check your queries via PhpMyAdmin, this should give you more meaningful 
error messages.

Philipp Gampe – PGP-Key 0AD96065 – TYPO3 UG Bonn/Köln
Documentation – linkvalidator
TYPO3 .... inspiring people to share!

More information about the TYPO3-english mailing list