Bug: Cannot Assign Member to Group

[bja2u]

Description

When going to a member profile and selecting "Assign New Group" application does not show list of groups available; displays as "No results found".

• ChurchCRM version: 5.4.3
• PHP version is the server running: 8.2
• DB Server and Version are you running: MySQL (dreamhost)

Steps To Reproduce

1. Go to member profile
2. Click on "assign new group"
3. select dropdown for group
4. See error "No results Found"

Expected behavior

Listing of available groups to assign

Screenshots and/or logs

Debugging Steps

 _PHP Fatal error:  Uncaught Error: Call to a member function setUser() on null in /home/ChurchCRM/model/ChurchCRM/Base/User.php:3609
Stack trace:
#0 /home/ChurchCRM/model/ChurchCRM/User.php(35): ChurchCRM\model\ChurchCRM\Base\User->getPerson()
#1 /home/ChurchCRM/Authentication/AuthenticationProviders/LocalAuthentication.php(180): ChurchCRM\model\ChurchCRM\User->getName()_

Desktop (please complete the following information):

• OS: [e.g. iOS] windows
• Browser [e.g. chrome, safari] chrome
• Version [e.g. 22] 120

[DAcodedBEAT]

I was unable to reproduce this on the latest code on the master branch.

[bja2u]

I don't get the error on a new install, when I restore from backup and then the message appears to upgrade DB, and then when I log back in once restored I cannot populate group and see no results.

[DAcodedBEAT]

@bja2u this sounds like an issue with the data in your database then. Can you look at your database and see the person which your user_usr record is associated with? Does this value line up with a person_per record?

[bja2u]

yes mu user_usr and all the users assigned in the DB line up with a personper record. I downgraded back to 5.1.1 (last version used prior to upgrading) and I don't have this issue.

[MrClever]

Please review the rollback/restore from back instructions on our wiki here: https://github.com/ChurchCRM/CRM/wiki/Rollback#restoring-a-broken-database-from-backup

Specifically step 2 which states: "Restore the database over the existing one. This is ONLY possible if you are restoring a database backup from the SAME version of ChurchCRM."

In other words, don't restore a database and the use a different application version. Restotre the database, install the SAME application version, then attempt the application upgrade.

[bja2u]

Yes I still had my backup of my db from 5.1.1 and I reinstalled churchcrm from that version as well.

[bja2u]

YES YES YES!!! Issue resolved with 5.5.0 new release! Tested all functionality I mostly use and found no issues. Thank you!!!!