PHP 5.2.13, MySQL 5.1.44

I have a content type with a date field (its type is Date, not Datestamp or Datetime), which means the date is getting stored in ISO format (e.g. 2011-03-14T03:30:00). It looks like date_views always wants to treat it as a DATE_UNIX, or a datestamp, instead of a DATE_ISO.

The main problem I'm seeing right now is an insertion of FROM_UNIXTIME() in the views filter query, which makes me wonder if this piece just isn't finished yet. But I also saw in #1075890 that the filter handler got a big reworking.

Is there anything I'm missing, or is this a bug?

Comments

jamesnumiko’s picture

jamesnumiko commented

Same issue here

jamesnumiko’s picture

jamesnumiko commented

I am testing with:

Views: 7.x-3.0-alpha1 - 2011-Jan-06
Date: 7.x-2.0-alpha1 - 2011-Mar-09

I can't get even the most basic date view to work. A simple filter of nodes with a date field in the future. As mentioned above the SQL uses FROM_UNIXTIME() which doesn't seem to tally with the data stored in the database.

karens’s picture

karens commented
Status: Active » Fixed

I committed a fix this morning that should take care of this.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.