| Subject: | List function snags on date (not datetime) item |
This is a plain vanilla product of running RDGC v0.07.
If I select <database_name>, <table_name>, List, it reports N records,
50 per page, but where it would display them, it reports no records
found. The debug says:
[debug] Rendering template "rdgc/yui_datatable.tt"
[error] Couldn't render template "date error - bad time/date string:
expects 'h:m:s d:m:y' got: '-787622400'"
[error] Couldn't render template "date error - bad time/date string:
expects 'h:m:s d:m:y' got: '-787622400'"
Interestingly, doing:
$ perl -e 'print scalar(localtime(-787622400)), "\n";'
Mon Jan 15 19:00:00 1945
Now that's my birthday (16 Jan 45, actually) in a date field in the
database. But if I do a Search in that same table and select one of my
records, everything displays just fine. Differences in the templates,
perhaps? I don't know enough TT or JavaScript to grok what's going on.
Note also that it shows up twice, which made me wonder if there are two
bad records in the (MySQL) database. But I did a "select dob from
client;" and saw nothing irregular. Most of the records have a null
field there, a few have others' DOBs, but most of the rest are mine, and
it's more than two.
Data problem? Template problem? Code problem?