UPGRADE ERROR/ISSUE - Some Email Addresses seem to have 'lost' their relationship to Account, Lead and other module records

šŸ“¦ Install & Upgrade Help
3

Yesā€¦I 100% agree with that you area saying.

In fact, Iā€™d edited this post many times as I was diagnosing, and realize now that itā€™s all jacked upā€¦heh.
My Bad!!

Iā€™ve solved the issue with the email relationships missing. I have a script that caused the issue, and deployed the fix. Did NOT seem to be related to the upgrade.
Turns out, I had the SAME issue a few months ago, and yaā€™ll helped me solve.

I also solved some Linux module issues I caused while upgrading from 18 to 20.

So, now, Iā€™m only left with 2 concerns:

1 - Did the ā€œupgradeā€ seem to ā€˜finishā€™ based on the log above, or is it possible that there was some issue that might cause problems moving forward? Iā€™m not sure how to ā€˜verifyā€™ if everything is okā€¦or if there may be something missing in the log, that might point me at potential issues?

2 - the issue where the ā€œDiagnostic Toolā€ will not run. Seems to hang at 0%. Iā€™m ā€˜worriedā€™ that perhaps the upgrade failure caused the issueā€¦but not sure.

When I run it, I get no errors in the console, and there seem not to be any errors in the log.

Iā€™ve set the file and folder permissions thusly:
sudo chown -R www-data:www-data .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload
sudo chmod 775 config_override.php 2>/dev/null

I turned on Debug, and found this, seemingly bad, line in there:
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Unable to find SugarController:: Diagnostic

Here are some surrounding lines:

Wed Nov 22 15:42:46 2023 [2363][-none-][INFO] Query Execution Time:0.0001380443572998
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Hook called: ::after_entry_point
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Including module specific hook file for custom/modules
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Including Ext hook file for custom/application
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Hook called: ::after_session_start
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Unable to find SugarController:: Diagnostic
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] We have an authenticated user id: 1
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Hook called: Users::before_retrieve
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Including module specific hook file for custom/modules/Users
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Retrieve User : SELECT users.* FROM users  WHERE users.id = '1' AND users.deleted=0
Wed Nov 22 15:42:46 2023 [2363][-none-][DEBUG] Limit Query:SELECT users.* FROM users  WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1
Wed Nov 22 15:42:46 2023 [2363][-none-][INFO] Query:SELECT users.* FROM users  WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1
Wed Nov 22 15:42:46 2023 [2363][-none-][INFO] Query Execution Time:0.00022292137145996
Wed Nov 22 15:42:46 2023 [2363][1][DEBUG] get_user_array query: SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC
Wed Nov 22 15:42:46 2023 [2363][1][INFO] Query:SELECT id, first_name, last_name, user_name FROM users WHERE 1=1 ORDER BY first_name, last_name ASC
Wed Nov 22 15:42:46 2023 [2363][1][INFO] Query Execution Time:0.00017881393432617
Wed Nov 22 15:42:46 2023 [2363][1][INFO] Query:SELECT u1.first_name, u1.last_name from users  u1, users  u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0
Wed Nov 22 15:42:46 2023 [2363][1][INFO] Query Execution Time:0.00015592575073242
Wed Nov 22 15:42:46 2023 [2363][1][DEBUG] SugarBean[User].load_relationships, Loading relationship (reports_to_link).

Is this at all helpful??