Breaking: #79565 - Removed "usergroup_cached_list" database field

See forge#79565

Description

The database field be_users.usergroup_cached_list has been removed. It was populated by a list of all groups (including subgroups) the user belongs to, and stored when a user logged in. The field however was never updated when an admin added or removed a group from the users group list.

Impact

The mentioned database field is removed, any direct SQL queries accessing or writing this field will result in a database error.

The PHP entry is removed from \TYPO3\CMS\Core\Authentication\BackendUserAuthentication->user array. Accessing the array key will result in warnings since PHP 8.0.

Affected Installations

TYPO3 installations using or querying this database field with third-party extensions.

TYPO3 installations reading the array key from \TYPO3\CMS\Core\Authentication\BackendUserAuthentication->user array.

Migration

Use the class \TYPO3\CMS\Core\Authentication\GroupResolver to fetch all groups of a user directly.