[TYPO3-english] andWhere internal server error

[Philipp Gampe]

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.

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