Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-68982

Message board email notifications do not have consistent Message-IDs when using MYSQL

    Details

      Description

      Description:
      Message board email notifications do not have consistent Message-IDs.

      Steps to reproduce:

      1. Start portal with MySQL 5.5
      2. Configure an SMTP service configured to deliver message board notifications to an email account. I set it up with the following:
        Incoming POP Server: pop.gmail.com
        Incoming Port: 995
        Use a Secure Network Connection: Checked
        User Name: Your email address
        Password: The password to your email account
        
        Outgoing SMTP Server: smtp.gmail.com
        Outgoing Port: 465
        Use a Secure Network Connection: Checked
        User Name: Your email address
        Password: The password to your email account
        
      3. Add a message board portlet and Subscribe to the message board
      4. Create an initial post to the new message board thread.
      5. Control Panel --> Server Administration --> Clear content cached across the cluster
      6. On the Liferay portal, reply to the thread.
        1. Confirm that the message board portlet shows the postings as a tree structure with the reply as a child of the initial post.
      7. Check gmail inbox
      8. Open both Message board thread emails and view full headers
        1. How to view full headers on Gmail: https://support.google.com/mail/answer/29436?hl=en
      9. For the email received for the initial post:
        1. Look for the message-id
      10. For the email received for the reply to the initial post:
        1. Look for the in-reply-to and references

      Expected Behavior: The in-reply-to and references from the reply email headers should match the message-id of the initial post.

      Actual Behavior: The in-reply-to and references from the reply email headers do not match the message-id of the initial post.


      Example - Email Headers
      The initial posting has the email header:
      Message-ID: <[email protected]>

      The reply has the email header:
      Message-ID: <[email protected]>
      In-Reply-To: <[email protected]>
      References: <[email protected]>


      Extra Notes
      The message-id inconsistency also changes, based on the version of MYSQL being used.

      This is due to the changes introduced by MYSQL regarding the DateTime field:
      https://bugs.mysql.com/bug.php?id=68760

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              joyce.wang Joyce Wang
              Reporter:
              eric.yan Eric Yan
              Participants of an Issue:
              Recent user:
              Esther Sanz
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 3 weeks, 3 days ago

                  Packages

                  Version Package
                  6.2.X EE