-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 7.0.X, 7.1.X, 7.2.X, Master
-
Fix Version/s: 7.0.0 DXP FP85, 7.0.10.12 DXP SP12, 7.0.X, 7.1.10 DXP FP13, 7.1.X, 7.2.10 DXP FP1, 7.2.1 CE GA2, 7.2.X, 7.3.10 DXP GA1, Master
-
Component/s: Staging
-
Branch Version/s:7.2.x, 7.1.x, 7.0.x
-
Backported to Branch:Committed
-
Fix Priority:3
-
Git Pull Request:
Description
An error is thrown when enable staging on My Dashboard.
Steps to reproduce
- Setup liferay 7.0
- Login as default user
- Navigate to My Dashboard > Publishing > Staging
- Enable Local Live staging
Actual result
The following is thrown and an error message is displayed.
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
2019-07-04 02:36:18.038 ERROR [http-nio-8080-exec-3][JDBCExceptionReporter:234] Duplicate entry '20115-20087-20155' for key 'IX_D0D5E397'
Expected result
Staging feature should not be enabled on My Dashboard.
Reproduced in
7.0.x Commit: f32bb75b0f08e42417997d62c799861a4d5cc214
Master Commit: 79f9d28848bb635cb4effee85618164314c283a5
Not Reproducible in 6.2 as Staging menu is not available for My Dashboard.
- is duplicated by
-
LPS-97045 Unable to turn on Staging for Personal Site for a User
- Closed