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

Unable to turn on Staging for Personal Site for a User

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Duplicate
    • Affects Version/s: 7.2.X, Master
    • Fix Version/s: None
    • Component/s: Staging
    • Labels:
      None
    • Fix Priority:
      4

      Description

      Steps to Reproduce:
      1. Under Avatar icon, go to My Profile
      2. Go to Publishing
      3. Enable Local Staging
      4. Assert Success Message

      Expected Results:
      Successfully enabled staging

      Actual Results:
      An error appears

      Error: An unexpected error occurred with the initial staging publication. org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into Group_ (mvccVersion, uuid_, companyId, creatorUserId, classNameId, classPK, parentGroupId, liveGroupId, treePath, groupKey, name, description, type_, typeSettings, manualMembership, membershipRestriction, friendlyURL, site, remoteStagingGroupCount, inheritContent, active_, groupId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
      
      ERROR [http-nio-8080-exec-5][JDBCExceptionReporter:234] Duplicate entry '20101-20006-20129' for key 'IX_D0D5E397'
      

      Environment:
      Tomcat 9.0.17 + MySQL 5.7 + Portal Master GIT ID: 32919af6e0ee46758597d84f463fc65a9f0bb81f
      Tomcat 9.0.17 + MySQL 5.7 + Portal 7.2.x GIT ID: 41cfac8974be4ee60ef5a472a840023e69ce91a5
      Base Branch Commit: c0c13433600398fed8768f539aa8212978f7409c

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              randolph.do Randolph Do (Inactive)
              Participants of an Issue:
              Recent user:
              Matthew Chan
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 43 weeks, 5 days ago

                  Packages

                  Version Package