Custom Date field not saving correct timestamp?

Hi there,

I am using Ditto and Reflect to show a list of upcoming events, sorting by a custom date field (myDate).

Since I’ve upgraded, it seems like it’s not saving the timestamp when choosing a date for an event. Even events that were already entered are just grouping under January 1970. When I print out the myDate TV for debugging, it’s showing all events with the same timestamp, even though they have different dates saved in each document.

Does anyone know what’s happening to my dates?

Cheers,
Jacob

How are the dates stored in the database? As a date string, or as a timestamp?

It’s just a custom Template Variable with Date Input Type, and using the Unixtime Widget.

Not working for me as well. I’m using the same setup: Input Type - Date, Widget - Unixtime. Any ideas?

Got this problem as well. Reflect worked properly in 1.0.2, but not in 1.0.4. And the debug console is showing correct unix timestamps in my custom date field. Considering that no changes to Ditto/Reflect code have been made between these versions and that the minor changes in the parser class would not cause this, what could it possibly be ... any clues?

Considering that no changes to Ditto/Reflect code have been made between these versions

might be related (Ditto - Server Offset Time Bug): http://modxcms.com/forums/index.php/topic,50691.0.html

It doesn’t seem to be an offset issue, although setting the offset properly (in my case to +3) actually kills ditto functionality all together. When the offset is "0" ditto retrieves documents as it should, but reflect doesn’t do its job and just outputs 1969 as the sole category of archives. Other insights?

It doesn’t seem to be an offset issue

no, but maybe Ditto has been updated/altered?

No, unfortunately it’s not that — I did run a search for differences on the snippet and the classes ... all identical (also checked phx). Any other ideas?

Quote from: sottwell at Jun 30, 2010, 06:13 AM

How are the dates stored in the database? As a date string, or as a timestamp?

Hi Susan,

I’ve looked in the actual database to see where the custom template variable data is being stored, and I’ve found the following:

It’s not stored in the site_content table, although the document’s data is;

The TV info is being stored in the site_tmplvars table;

A value IS being stored in the site_tmplvar_contentvalues table, but the date looks like "06-11-2010 10:00:00", and it’s a text field.

I presume that Ditto is doing (or should be doing) a conversion of that date string, as it looks like it was stored the same way in my old 0.9.6 sql backup file as well (and it had no trouble there!).

Considering that no changes to Ditto/Reflect code have been made between these versions and that the minor changes in the parser class would not cause this

Perhaps it has??

I wouldn’t even know where to start looking, if this were the case.

Cheers,
Jake