[SOLVED] all profiles visible apart from own profile - 404

After updating to latest CB, the own profile page is not showing anylonger.
Profiles of other people are functioning well.

One template generates a '404' page.
An other template shows:
1267
ILLEGAL MIX OF COLLATIONS (LATIN1_SWEDISH_CI,IMPLICIT) AND (LATIN1_GENERAL_CI,IMPLICIT) FOR OPERATION '='

Please advise,
Patrick

Your database collations are incorrect. Ensure your entire Joomla database has a collation of utf8mb4_unicode_ci. Can usually use the Operations tab of phpmyadmin to mass-change collation for tables and their columns (make a backup before you do this). Joomla is and always has been UTF8 so it's important data is stored in the expected collation.

database is set already set to utf8mb4_unicode_ci.

I retraced my steps:
-- update cb to 2.7.2
-- update plugins
--- CB Profile book to 3.2.0
--- CB Activity to 5.0.0
--- CB Galery to 2.4.0

after updating the plugins, the problems shows in the frontend:
The own profile page is giving the error 1267.
Profiles of other people are showing ok.

I can even edit my own profile perfectly, but after saving, the error shows.

Please advice.

Your collations are not all correct if you're getting that error. It's directly from SQL. Use phpmyadmin and under Operations force all tables AND their columns to utf8mb4_unicode_ci. Make a backup before doing this. That will fixed the mixed collation environment.

The own profile page is giving the error 1267.

Enable debug mode and maximum error reporting in Joomla global configuration. Once done retry and provide the full error being output.

I solved the problem by using the latest version of CB activity plugin.
I was using a 5.0.0-2021-08 version, that generated the problem.
The 5.0.0-2022-02 version is ok!

Thanks.