Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
2 votes

Issue moving site from mysql 5.7 to mysql 8

MySQL 5.7 to 8 is a notable upgrade by itself. Have you gone through the mysql_upgrade process? See for example, https://dev.mysql.com/blog-archive/inplace-upgrade-from-mysql-5-7-to-mysql-8-0/ ...
Aidan's user avatar
  • 13.5k
2 votes

CiviCRM Smart Group Cache SQL Collation Error

Okay, this appears to be an issue with running CiviCRM on MySQL 8. I downgraded to MySQL 5.7 and it's now working. Maybe worth investigating further.
Rich Smith's user avatar
1 vote

Issues with CiviCRM Tables During MySQL 8.0 Upgrade

Yes. If you see any errors coming from core code it would be good to create a PR or file an issue. There's an api call you can run instead which will use the correct sql statements and update the ...
Demerit's user avatar
  • 23.1k
1 vote
Accepted

Issue moving site from mysql 5.7 to mysql 8

MySQL8 is working fine for us so far. You may need to play around with the parameters of mysqldump to make a useable dump that works out of the box: To fix that warning you need to add the parameter --...
Thomas Schüttler's user avatar
1 vote
Accepted

Ajax error with Manage Groups after upgrading to PHP 7.3, MySQL 8.0 and 5.22.0

MySQL 8 isn't officially supported yet. This particular problem should be fixed in 5.23 though since it's the word "groups" that mysql 8 doesn't like - see https://lab.civicrm.org/dev/core/issues/1143 ...
Demerit's user avatar
  • 23.1k
1 vote

MySQL v8.0 released. Will CiviCRM work with it?

Clearly CiviCRM won't work with MySQL 8.9 yet; at least not in my environment.
Stephen Palmstrom's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible