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

CalEvent classNameId entries remain in MBMessage and MBDiscussion tables

    Details

    • Branch Version/s:
      7.3.x
    • Backported to Branch:
      Committed
    • Fix Priority:
      3

      Description

      Steps to Reproduce:

      1. In a 6.1 portal add a Calendar portlet to a page.
      2. Under 'Liferay's Calendar' combo, click on down arrow of 'Liferay' calendar option. Choose 'Calendar Settings' option. Then click on 'Enable Comments' check. Save.
      3. Create a Calendar Event.
      4. Open the created Calendar Event (just click on its link, do not edit it) and add a comment.
      5. Execute the following query and save the classNameId returned that will be used for future queries:
        • select classNameId from ClassName_ where value = 'com.liferay.portlet.calendar.model.CalEvent'
      6. Ensure, with the following queries, that there are records in the two tables:
        • select * from mbmessage where classnameid = <classNameId>;
          select * from mbdiscussion where classnameid = <classNameId>;

          For the <classNameId> use the one returned in step 5.

      7. Upgrade to 6.2
      8. Ensure, with the following queries, that there are records in the two tables:
        • select * from mbmessage where classnameid = <classNameId>;
          select * from mbdiscussion where classnameid = <classNameId>;

          For the <classNameId> use the one returned in step 5.

      9. Upgrade to master.
      10. Check if there are still old CalEvent classNameId records in the two tables:
        • select * from mbmessage where classnameid = <classNameId>
          select * from mbdiscussion where classnameid = <classNameId>

          For the <classNameId> use the one returned in step 5.

      Expected Results:

      No records with old CalEvent classNameId should remain neither mbmessage table nor mbdiscussion table.

      Actual Results:

      Records with old CalEvent classNameId remain in mbmessage table and mbdiscussion table.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              rodrigo.cunha Rodrigo Cunha
              Reporter:
              sergio.alonso Sergio Alonso
              Participants of an Issue:
              Recent user:
              Jose Bango
              Engineering Assignee:
              Sergio Alonso
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                20 weeks, 6 days ago

                  Packages

                  Version Package
                  7.3.7 CE GA8
                  7.3.10 DXP FP2
                  7.3.X
                  7.4.1 CE GA2 DXP 7,4
                  Master