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

Cannot always delete the last comment to a web content

    Details

    • Fix Priority:
      3

      Description

      Reproducing steps

      1. Use SQL Server as database.
      2. In a given site, add a Web Content Display to a page.
      3. Create a new web content
      4. Go to the portlet's Configuration > Content Metadata and choose Comments
      5. Add a comment
      6. Delete the comment

      Expected: The comment is deleted.
      Observed: The comment is not always deleted and and error message can appear informing that the action couldn't be carried out.

      Note: It may take more than one try to reproduce the issue.

      Comment

      The problem lies in the precision used by SQL Server for fields of type DATETIME (a query is used when deleting the comment which makes a date comparison). Milliseconds are rounded to one of the possible values: .xx0 s, .xx3 s, .xx7 s. SQL Server 2008 introduced a new type, DATETIME2, increasing the accuracy to 100 ns.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              ricardo.couso Ricardo Couso
              Participants of an Issue:
              Recent user:
              Jose Jimenez
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 34 weeks, 1 day ago

                  Packages

                  Version Package