Sent E-Mail Shows Up As 1969-12-31 14:00

[mhoppes]

I have installed Sugar and things seem to be working fine. However, one tiny issue. When I send an e-mail out it shows in the 'History' section of an account with a date and time of 1969-12-31 14:00. However, if I click it then the date and time show correctly on the next screen.

Any ideas?

[franklin_sugar]

Hi,

This is Franklin from Sugar QA team. I tried your scenario and couldn't reproduce it. Can you tell me your environment, Sugar version and detailed steps to reproduce it?

FYI, I used Sugar Open Source 4.5.1d build 1273, Windows XP, Apache 2.2.4, PHP 5.2.1, and MySQL 5.0.37.

Thanks,
Franklin

[mhoppes]

Hi,

This is Franklin from Sugar QA team. I tried your scenario and couldn't reproduce it. Can you tell me your environment, Sugar version and detailed steps to reproduce it?

FYI, I used Sugar Open Source 4.5.1d build 1273, Windows XP, Apache 2.2.4, PHP 5.2.1, and MySQL 5.0.37.

Thanks,
Franklin

Franklin,
Thanks for your response. The MySQL version of Sugar seems to display the correct date. To reproduce my problem try the following:

Sugar Open Source 4.5.1d build 1273, Windows 2003 Server (though XP shouldn't affect it), Apache 2.2.4, PHP 5.2.1, MSSQL. The only thing I see different between your installation that worked, mine that worked, and mine that didn't work is the MSSQL vs. MySQL code.

[mhoppes]

Just wanted to follow up. To duplicate this.. just send an e-mail from SugarCRM. Make sure you archive it. Then, go back and view it in history... in the history tab under the account you'll see it listed as 1969. If you click on it, the date shows correctly.

[franklin_sugar]

I can reproduce it under MSSQL. A bug report is opened for it: bug #13347. Thanks for catching this bug.

Thanks,
Franklin

[mrobertson]

The problem is the following section in email.php

         /*/////////////////////////////////////////////////////////////////////
        //// cn: bug 9193 - displaying "date_modified" in Subpanels makes it look
         * like we're overwriting the date/time values on replies.
         * This code is called from SubPanelTiles - we are overloading the date_modified field with the values below.
         */
        $q = "SELECT date_start, time_start FROM emails WHERE id = '{$this->id}' AND deleted = 0";
        $r = $this->db->query($q);
        $a = $this->db->fetchByAssoc($r);
 
        $dateStart = $a['date_start']." ".$a['time_start'];
 
        $dateStartHack = $timedate->to_display_date_time($dateStart);
        $this->date_modified = $dateStartHack; 
  

[mhoppes]

Cool! Now, do you know what is wrong with it? I can take some guesses, but if someone knows before I go meddling, that would be better.

The problem is the following section in email.php

         /*/////////////////////////////////////////////////////////////////////
        //// cn: bug 9193 - displaying "date_modified" in Subpanels makes it look
         * like we're overwriting the date/time values on replies.
         * This code is called from SubPanelTiles - we are overloading the date_modified field with the values below.
         */
        $q = "SELECT date_start, time_start FROM emails WHERE id = '{$this->id}' AND deleted = 0";
        $r = $this->db->query($q);
        $a = $this->db->fetchByAssoc($r);
 
        $dateStart = $a['date_start']." ".$a['time_start'];
 
        $dateStartHack = $timedate->to_display_date_time($dateStart);
        $this->date_modified = $dateStartHack; 
  

[mhoppes]

I see in the bug 13347
it says 'Fixed In Release: 4.5.1.patch'
However, the only thing I see is: Sugar Open Source for Microsoft SQL Server Patch 4.5.1d (1.14 MB ZIP)

Is that what I want to download to fix this issue?

[susiewilliams]

Hi there,

I'm betting that it's fixed in 4.5.1.e, which is coming out in a couple of weeks. It wouldn't be fixed in 4.5.1.d since that was released before your issue was found and reported.

Watch our Announcements section of the Forums for the announcement that 4.5.1.e is out.

[Deuce]

Cool! Now, do you know what is wrong with it? I can take some guesses, but if someone knows before I go meddling, that would be better.

I was fighting the same issue a while back... Replace the the line that reads
$q = "SELECT date_start, time_start FROM emails WHERE id = '{$this->id}' AND deleted = 0";
with
$q = "SELECT convert(varchar, date_start, 101) as date_start, convert(varchar, time_start, 108) as time_start FROM emails WHERE id = '{$this->id}' AND deleted = 0";

The issue here is that MS SQL does not have separate date and time data types, it is all datetime. The convert(xx,xx,101) plucks out just the date part, and the 108 grabs just the time part of the date.