Incorrect Date Displayed for Email Sent

[jkitsmiller]

I am using the SurgarCRM email client so that it makes it easy to archive email when sent without going through extra steps.

But I just noticed that when I sent an email it is logging a VERY incorrect date. See the image attached. I sent this email today 7/6/07 at about 0930. I checked the server date and time and it is correct.

Running SugarCRM on Windows Server 2003 with MS SQL 2005.



Any help would sure be appreciated.

John

[jkitsmiller]

I just want to add to this as I have been trying to figure out where else it is causing problems.

In the previous example, when I click on the email with the wrong date, it simply goes to a blank page.

I have been using the Sugar Outlook Plug-In also and archiving emails to contacts and opportunities.

So I thought I would check to see if I had the same problem with email archived from that plug-in. As you can see the date is correctly set to the date of the email, but when I click on the email it goes to a blank screen also.



Would really appreciate any help.

John

[Deuce]

If you are running MS SQL server, see this thread: http://www.sugarcrm.com/forums/showthread.php?t=23708

[jkitsmiller]

Thanks!

I changed the line referenced at the end of that thread in email.php in \modules\Emails\

The first time I went and looked at the same History it had changed the date/time to the correct date/time the email was sent this morning. See below.

Before:



After:



But when I click on the emails to view them I still wind up with a blank screen. So I thought maybe it might have something to do with emails archived before the change was made. So I archived a Test email. Not only can I not view the newly archived email, but as you can see below the date is incorrect again!



Help!!!

John

[Deuce]

There's a couple of places in that file you need to make that change. Search through the file for date_start and you should be able to find the queries you need to change.

[jkitsmiller]

Deuce, thanks so much for continuing to help.

I made the changed as you referenced here
______________________________________

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.

---------------------------------------------------------------

You mention searching for date_start, and I found lots of those, but what do I change those to?

Thanks again for your help.

John