by SuiteCRM Addon

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.

Free 30 day trial
Try it Now

#1908 - Emails Sent/Received date incorrectly showing as 'Unknown' in History Timeline

Closed Bug? created by R&D Tax Solutions Verified Purchase a year ago

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

Screenshot 2019-04-16 at 17.40.47.png

Screenshot 2019-04-16 at 17.40.32.png

  1. nhat.thieu member avatar

    SuiteCRM Addon Provider Affiliate

    a year 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.

  2. nhat.thieu member avatar

    SuiteCRM Addon Provider Affiliate

    a year 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,

    • evgeni member avatar

      R&D Tax Solutions Verified Purchase

      a year 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'

    • nhat.thieu member avatar

      SuiteCRM Addon Provider Affiliate

      a year 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.

    • evgeni member avatar

      R&D Tax Solutions Verified Purchase

      a year ago

      Thank you. Would suggest a conditional check of both fields, to cover new and upgraded SuiteCRM users.

    • nhat.thieu member avatar

      SuiteCRM Addon Provider Affiliate

      a year ago

      We had released v1.2.4 fixed this issue. can you please verify and close ticket.
      Thanks.

  3. evgeni member avatar

    R&D Tax Solutions Verified Purchase

    a year 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'
    }

    • nhat.thieu member avatar

      SuiteCRM Addon Provider Affiliate

      a year 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

    • evgeni member avatar

      R&D Tax Solutions Verified Purchase

      a year ago

      I have upgraded to v1.2.4. See screenshots, now it does not work for the old emails whcih use 'date_sent' field.

      Screenshot 2019-04-17 at 16.28.01.png

      Screenshot 2019-04-17 at 16.30.01.png

      These are the values in our DB for an old and a new email.

      Screenshot 2019-04-17 at 16.30.53.png

    • nhat.thieu member avatar

      SuiteCRM Addon Provider Affiliate

      a year 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

  4. evgeni member avatar

    R&D Tax Solutions Verified Purchase

    a year ago

    Thank you resolved. This ticket can be closed.

    • nhat.thieu member avatar

      SuiteCRM Addon Provider Affiliate

      a year ago

      No worries, hope you happy with us addon and will buy it after trial.
      Thanks you for all feedback.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...