Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I am using TW 6.x-1.2 with Views 6.x-2.11 on MySQL table that contains 2 datetime fields. TW is no longer formatting the datetime fields properly. This worked properly for the past year or so until I did an update to TW 6.x-1.2 4 weeks ago. The datetime fields are correct in the database and display properly in several other locations when used through custom modules. All 5 million records in the table display the same time, 12/31/1969 - 8:33pm, when viewed through TW and Views.
There appears to be at least one other complaint like this at http://drupal.org/node/819072.
Thanks,
Elmer.
Comments
Comment #1
overaph CreditAttribution: overaph commentedI found same error.
My date fields show the same value:
01/01/1970 - 02:33
any idea for fix this?
Comment #2
mikeryan_tw_views_handler() was setting date handlers for these fields - unfortunately, those handlers assume they're dealing with Unix timestamps rather than true date fields. Backed it out to treat datetime fields like strings - this will probably make other datetime stuff harder, but fixes the straightforward case you're seeing.