I was just trying to move three old CiviCRM drupal 7 sites from Ubuntu 16, PHP7.2 and mysql 5.7 Ubnuntu 22.04 lts, php 7.4 and mysql 8 and have run into some issues.
two of the three sites work but throw this warning:
Missing Phone numeric function Your database is missing a function to populate the 'Phone number' field with a numbers-only version of the phone.
Trying to rebuild the DB triggers throws an
Unknown database error and just hangs.
The third site, doesn't work at all and throws this error:
RuntimeException: CiviCRM has not bootstrapped sufficiently to fire event "hook_civicrm_entityTypes". in Civi\Core\CiviEventDispatcher->dispatch() (line 190 of /var/www/html/mysite/sites/all/modules/civicrm/Civi/Core/CiviEventDispatcher.php).
The host drupal 7 site is connecting to the DB fine.
- resetting the file permissions in the files directory
- resyncing the site files (I used rsync)
- re-downloading the database.
the mysql dump seem to go into the new DB without errors.
Is it possible to move a CiviCRM install from Mysql 5.7 to Mysql 8 or do I have to install an older version? And what will happen in a year or so when 5.7 is EoL?