Thread Details
  • State Verified Answer
  • Replies 7 replies
  • Subscribers 354 subscribers
  • Views 2598 views
  • Users 0 members are here
Forum Actions
Related

Sugar 8 Pro to Enterprise Conversion Upgrade fails - Duplicate entry into SugarFavorites

Josh Whitlow

So I'm currently working on upgrading our SugarCRM instance.

Before proceeding with the rest of the upgrades, I need to convert from Pro to Enterprise.

When applying the upgrade, I see this error in UpgradeWizard.log

Wed, 30 Aug 2023 19:12:27 +0000 [Upgrader] - Starting script 6_SharableDashboards
Wed, 30 Aug 2023 19:12:27 +0000 [Upgrader] - ERROR: Exception: An exception occurred while executing 'INSERT INTO sugarfavorites (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, module, record_id, assigned_user_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["098fee45e1e7041684fa96f0f459c8a3", null, "2023-08-30 19:12:27", "2023-08-30 19:12:27", "1", "1", null, 0, "Dashboards", "3fc434e6-9b6d-357a-0759-576936d6ca5e", "1"]:
Duplicate entry '098fee45e1e7041684fa96f0f459c8a3' for key 'PRIMARY'
Wed, 30 Aug 2023 19:12:27 +0000 [Upgrader] - Finished script 6_SharableDashboards
Wed, 30 Aug 2023 19:12:27 +0000 [Upgrader] - ERROR: Post-upgrade stage failed! Error executing post scripts


I'm not sure what the purpose of this script is, but I checked the 7.9.4 -> 8.0 upgrader for 6_SharableDashboards.php and I see the exact same file there. So I'm wondering if anyone has run into this issue before and what they might have done to fix it.

Seems like I have no choice but to try to modify the upgrader to remove this script?


Parents
  • 0

    I don't think the error refers to the 6_SharableDashboards

    The Error is on the post-upgrade stage which, in my experience, is often related to a problem with file permissions and the final QRR that each upgrade goes through.

    Check this guideline on File Permissions and rerun the silent upgrader with the continue option (-S continue) or rerun the upgrade wizard to finish the upgrade.

    FrancescaS

    PS. Also check what other ERROR lines you have, it looks like you have an issue with a duplicate entry for primary key in your sugarfavorites table. (just 2 lines up from the last)

Reply
  • 0

    I don't think the error refers to the 6_SharableDashboards

    The Error is on the post-upgrade stage which, in my experience, is often related to a problem with file permissions and the final QRR that each upgrade goes through.

    Check this guideline on File Permissions and rerun the silent upgrader with the continue option (-S continue) or rerun the upgrade wizard to finish the upgrade.

    FrancescaS

    PS. Also check what other ERROR lines you have, it looks like you have an issue with a duplicate entry for primary key in your sugarfavorites table. (just 2 lines up from the last)

Children