See everything in a single timeline view which helps you to keep track of key business events and gives you the means to specify what exactly constitutes a key business event for your company. Best of all, it works great on all devices. Get even more value by tracking and displaying key business events that matter to your specific business.
#1908 - Emails Sent/Received date incorrectly showing as 'Unknown' in History Timeline
Sometimes we receive emails and consequently create a lead. When we attach the older email to the newer lead, then the date/time stamp instead of showing on History Timeline, it shows as 'Unknown'. See attached screenshot.
SuiteCRM 7.10
PHP 7.2.16
MySQL 5.6
CentOS Linux release 7.6
-
"UPDATE FOR V2: customer support is top notch! Highly recommended. This is an essential plugin that behaves with multiple skins and responsive. A must ..." - rickdolishny
Read More Reviews
- Most Recent Love from Users
ghansen- lodevlayen
- R&D Tax Solutions
5 years ago
Many many thanks you. For this issue and 1907. We're still investigate to fix it, maybe the next version(1.2.4), will soon release. Currently, We has release v1.2.3 included bug fixes for 1903,1906 because, 2 issues relate to other customers trialling. Now You can down v1.2.3 and verify 1903 and 1906. Thanks again.
5 years ago
Hi,
Can you please confirm with me? Did you upgrade SuiteCRM older version to v7.10.x? Anyway, If you can access database, please help me check date_sent does exist in **emails **table or not? If yes, I think I found the problem.
Thanks,
5 years ago
We have done several upgrades, all the way from 6.20 when it was still SugarCRM Community Edition. Most recent upgrade was from 7.8.27->7.10.15.
The email from the screenshots: **date_sent NULL ** date_entered '2019-04-16 13:04:02' date_modified '2019-04-17 11:00:14' date_sent_received '2019-04-16 13:03:00'
5 years ago
Thanks You. We has found the root cause. Because We priority date_sent to display if exist, so in case upgrade. This field does exist and the system has get value of this field to display instead use date_sent_received value. We will release it on today. Please wait.
5 years ago
Thank you. Would suggest a conditional check of both fields, to cover new and upgraded SuiteCRM users.
5 years ago
We had released v1.2.4 fixed this issue. can you please verify and close ticket. Thanks.
5 years ago
Now emails before the 7.10 upgrade that used date_sent and have date_sent_received=NULL are showing as 'Unknown'. You code needs to check both DB fields to cover for both old and newwer emaiils. if (date_sent_received != NULL){ $date_mts_history = $date_sent_received } else if (date_sent != NULL) { $date_mts_history = $date_sent } else { $date_mts_history = 'Unknown' }
5 years ago
I think no need do that, after upgrade to 7.10. You shoud migrate data in date_sent to date_sent_received to use. We just used one of 2 above fields. Currently, We have check if date_sent_received we will use it else we will use date_sent.
Thanks
5 years ago
I have upgraded to v1.2.4. See screenshots, now it does not work for the old emails whcih use 'date_sent' field.
These are the values in our DB for an old and a new email.
5 years ago
You please run migrate query bellow to move data from date_sent to date_sent_received. This query will resolve issue in email detail for old email to if you did showing date_sent_received in detail.
UPDATE emails SET date_sent_received = date_sent WHERE date_sent_received is NULL
5 years ago
Thank you resolved. This ticket can be closed.
5 years ago
No worries, hope you happy with us addon and will buy it after trial. Thanks you for all feedback.