vt71: Migration Issue in History Widget?

I did a test migration from 5.4.0 to 7.1.0. I just added the History widget to the dashboard...

See the time stamp for these recent activities... (48 years!!!)

@lord_alan are you sure you was on 5.4.0? 48 years ago that didn´t exist. :) :)

@lord_alan - 48 years ago is 1970 => date column is NULL. Can you review?

changedon value not available for the change, which is being transformed wrong.

Status changed to closed by commit e01f180c

I think there might be more to this though. This is a migrated system so why is there no OR NULL data in ModTracker (assuming that is where this data comes from?)? I'll do some more digging in the db tomorrow...

@prasad See below. This problem also occurs in the "Recent Updates" view... (Where is the data problem? is this in the ModTracker table?)

Status changed to reopened

@lord_alan - I doubt of data-missing in changedon vtiger_modtracker_basic table. Please review.

@lord_alan - confirmed via email that issue was due to fieldname case change (createdtime and modified time were having title-case for this custom module) fix it worked.

Status changed to closed

It doesn't fix the "48 years ago" showing for any existing entries in the modtracker tables that have a NULL value in changedon though :-(

(I think I can fix this with a query as in the modtracker_detail are entries for the ModifiedTime field. So I can copy this across. But as this was how vtiger documented creating The modifiedtime and createdtime fields in vtlib there may well be others who come across this problem as well. I think it would be better to not show "48 years ago" :-)