Upgrade 11.0.3 -> 12 failed in post rebuild: Invalid favorite_link

Hi, 

currently upgrading an instance from 11.0.3 to 12. On 11.0.3 with PHP: 7.4.3 and Mysql: 5.7.38. Everything seems to work correctly. When we start the upgrade with the silent installer (or ui installer doesn't matter much) we eventually hit the following error: 

Tue, 14 Jun 2022 07:08:46 +0000 [Upgrader] - Verifying audit tables for modules: Leads,Cases,Bugs,ProjectTask,Campaigns,Prospects,Contacts,Accounts,Opportunities,Notes,Calls,Meetings,Tasks,EmailAddresses,Contracts,ProductTemplates,Quotes,Products,RevenueLineItems,ForecastManagerWorksheets,Quotas,BusinessCenters,Shifts,ShiftExceptions,Messages,Purchases,PurchasedLineItems,DataPrivacy,ReportSchedules,Tags,KBContents,KBContentTemplates,Escalations,DocumentTemplates,DocumentMerges,aconf_Configurator,aconf_Import_Match,aconf_Import_Auto_Fill
Tue, 14 Jun 2022 07:08:46 +0000 [Upgrader] - Database repaired
Tue, 14 Jun 2022 07:08:46 +0000 [Upgrader] - Start rebuilding relationships
Tue, 14 Jun 2022 07:09:33 +0000 [Upgrader] - ERROR: Exception: Invalid link favorite_link
Tue, 14 Jun 2022 07:09:33 +0000 [Upgrader] - Finished script 2_Rebuild
Tue, 14 Jun 2022 07:09:33 +0000 [Upgrader] - ERROR: Post-upgrade stage failed! Error executing post scripts

We already tried the following but without any luch: 

- truncate the relationships table in the database (it's not used anymore to my knowledge)

- prior upgrade hit the repair relationships and do a quick repair / rebuild. 

Does anyone else have any idea what the cause could be and most importantly a solution. 

Parents
  • I was about to make a thread until I found this one.

    I'm having this same issue:

    I've tried using both the Upgrade Wizard + silent upgrader several times.

    I'm on PHP 7.4 + mySQL 5.7, which are each compatible with both Sugar 11 and 12. I've tried all suggestions in this thread, including running rebuild relationships/QRR before the upgrade, resetting file permissions and retrying upgrade with the -S continue flag (which it just fails instantly at the same spot). Nothing helps.

    The instance loads as a Sugar 12 instance, and everything seems to be functioning as expected after rebuilding config file, except none of the uploads/documents seem to be properly mapped in Sugar:

    They don't seem to be pointing to the file like they should... I'm guessing Sugar 12 changed something with the upload directory structure? And my directory didn't get changed since the upgrade process keeps failing before it's fully complete?

    I tried researching to see what exactly changed with the uploads with Sugar 12 but I cannot find anything. I tested by uploading some new attachments/documents. After looking into the upload directory, it does appear that sugar saves them differently now (within subdirectories with a new naming scheme).

    Anyone have a solution? :(

  • EDIT: made a new thread for this since it's a different issue I'm having now. But I was able to rectify the original "invalid favorite_link" error by redoing the upgrade from scratch from silent upgrader, and when I got the invalid favorite_link error, I reset file permissions on full sugar directory and ran silent upgrade again with -S continue flag. It then completed fully. 

Reply Children