<div dir="ltr">44 years ago - means the date_diff is not getting the right reference date and is using 1970 (unix time start). So need to review what value is getting into the tracker tables.</div><div class="gmail_extra"><br clear="all"><div><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><b>Connect with us on: </b><a href="http://twitter.com/vtigercrm" style="color:rgb(0,0,204)" target="_blank">Twitter</a> <b>I</b> <a href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" style="color:rgb(0,0,204)" target="_blank">Facebook</a> <b>I</b> <a href="https://blogs.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Blog</a><b> I</b> <a href="http://wiki.vtiger.com/index.php/Main_Page" style="color:rgb(0,0,204)" target="_blank">Wiki</a> <b>I </b><a href="https://discussions.vtiger.com" style="color:rgb(0,0,204)" target="_blank">Forums </a><b>I</b> <a href="https://www.vtiger.com/" style="color:rgb(0,0,204)" target="_blank">Website</a></span></div>
<br><div class="gmail_quote">On Thu, Oct 9, 2014 at 10:58 PM, Rishab K <span dir="ltr"><<a href="mailto:rishab.k@vtiger.com" target="_blank">rishab.k@vtiger.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Alan,<div>This is because in ModTrackerHandler.php we check for 'modifiedtime' as fieldname </div><div>and updating the Status in vtiger_modtracker_basic</div><div><br></div><div>What is the fieldname of modifiedtime and createdtime within vtiger_field for the given module</div><div><br></div><div>Regards,</div><div>Rishab<div><div class="h5"><br><br>On Thursday, October 9, 2014, Alan Lord <<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I remember someone else seeing this before... What the problem - why does it say 44 years ago, when it was just a couple of seconds?<br>
<br>
Cheers<br>
<br>
Al<br>
<br>
PS: ModTracker widget registered on my Module using the following bootstrap code:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
if ($module != false){<br>
$url = "javascript:ModTrackerCommon.<u></u>showhistory('$RECORD$')";<br>
$module->deleteLink('<u></u>DETAILVIEWBASIC', 'View History', $url);<br>
$module->addLink('<u></u>DETAILVIEWBASIC', 'View History', $url);<br>
<br>
// Insert tabid - will fail if in already as tabid is a primary key<br>
$query = "INSERT INTO vtiger_modtracker_tabs(tabid,<u></u>visible) VALUES(?,1)";<br>
$adb->pquery($query, array($module->id));<br>
}<br>
</blockquote>
<br>
</blockquote></div></div></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>