[ASTPPCOM-797] Community version upgrade v4.0 to 5.0 - During upgradation database error getting. Created: 07/Oct/21  Updated: 19/Oct/21  Resolved: 18/Oct/21

Status: Closed
Project: ASTPP Community
Component/s: None
Affects Version/s: v4.0.1
Fix Version/s: v5.0

Type: Bug Priority: Highest
Reporter: Prashant Kumar Assignee: Sahil Sheikh (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: 1h 40m
Original Estimate: Not Specified

Attachments: PNG File image-2021-10-08-15-19-40-035.png     PNG File MobaXterm_GtPqVWXaUU.png    
Issue Links:
Relates
relates to ASTPPCOM-804 Community upgrade script verification Done
Reproducibility: always
Category: Database
Edition: Community

 Description   

Steps :- 

  1. Set-up community v4.0.1 source code.
  2. Login as admin.
  3. Go to Accounts > Admin.
  4. Create at least one sub admin.
  5. Upgrade to version 5.0
  6. During upgradation check error in console.

Actual Result :- mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1062 (23000) at line 495: Duplicate entry 'Sub Admin' for key 'translations.en_En'

Expected result :- It should not be get error during upgrade.

 

See Screenshot :- 

 Comments   
Comment by Sahil Sheikh (Inactive) [ 08/Oct/21 ]

Hello Prashant Kumar, I checked and I am not getting any error during database import . I check in Portal as well we are not having any module name"Sub Admin" in translations in v4.0.1. Sharing you the screenshot.

Comment by Prashant Kumar [ 19/Oct/21 ]

Verified in latest source, working fine

Generated at Sat Feb 10 07:20:21 CET 2024 using Jira 8.13.3#813003-sha1:22ebedbb75c99b147c66f14e031dd8a2d214753a.