By thebruins on

Using a view I am trying to get all nodes whose start date is greater than or equal to today's date. Problem is that somehow it only returns nodes that have a start date that is greater than today. I used the 'devel'-module to check the SQL query the view generates, but the query seems fine: when I copy&paste it to MySQL, it returns the correct nodes.
Hooking the view at '_pre_execute' gives the same result: the query seems fine.

Is there anything else I can check to see where things go wrong?

⋅ Categories: Drupal 6.x

Comments

thebruins’s picture

thebruins commented

Fixed.
MySQL conversion FROM_UNIXTIME() of the node's timestamp went wrong. Because of an incorrect/unset MySQL timezone all drupal timestamps lost a few hours during conversion in MySQL which resulted in some of the dates getting set to the day before. Fixed it by setting the MySQL timezone.