I did the deed and upgraded from Debian 8 to 9 and from PHP 5.6 to PHP 7.0. I wanted 7.1 but the host recommended I stick with the native packages since the 7.1 broke the SOAP function. I've been having all kinds of issues since the upgrade, such as users getting a DB error when trying to subscribe or use the contribution form, and numerous issues or errors in the log. Without going into that detail, I am wondering if there was any provisioning I need to do? I tested it all on a different PHP 7.1 server without issue.
- How can I check the database integrity, etc. of the CiviCRM and is there a checklist to make sure the upgrade didn't break something
- Is there a pre and post-upgrade CRM and server provisioning checklist?
- What is the recommended MySQL version?
It seems like some simple setting got overwritten somewhere on the server.
Drupal 7, CiviCRM 5.7.2
An example of the problems we've run into since upgrading the server, no settings in CiviCRM or Drupal were changed and to my knowledge, no file permissions were changed:
- Postfix status is excited
- CiviSMTP keeps sending a notification that our password and username is wrong but testing the settings in CiviCRM and CiviSMTP reports that they are correct
- The soap user also had an issue and our first mailing had a 100% failure rate. My host downgraded to PHP7.0 to stick with native Debian 9 packages. Mailings seem to work now
- CiviMail drafts take forever to save or give an error that they can't be saved because content is out of date (posted separately)
- CiviCRM sometimes runs very slowly
- Users get an unknown db_error when trying to submit a contribution form (a lot of the time but not every time, posting separately)
- Unknown DB Error for query
UPDATE civicrm_mailing. Error includes the full HTML of the email. (Submitting separately).
- Several/constant MySQL deadlocks
- Several in log: "We can't load the requested web page. This requires cookies to be enabled...". (Submitting separately).
I want to post in server fault also but when they see "CiviCRM" they might assume it goes here.