CBSubs history log

4 years ago when you made this post yes it was "utf8_general_ci", but the default collation for Joomla is now "utf8mb4_unicode_ci". You may just have a broken entry in the history log. Empty the _cbsubs_history table, change the table and its columns collation to utf8mb4_unicode_ci, and see if the issue comes back.

This also seems to have to do with special characters in user names. If I remove these entries it is working fine.

Question: Is there an URL, where I can go to the history page and have either page 2, or just a single item displayed?

Since the display from the menu fails, I do not know right know how to do this. It would help me get past the error.

You need to use phpmyadmin for managing your database. Navigate to the _cbsubs_history table for your database then click Operations tab at the top. Now scroll down and click "Empty the table (TRUNCATE)". Once that is done running go back to the Operations tab and follow the below steps.

1. Find "Table options" section
2. Set "Collation" to "utf8mb4_unicode_ci"
3. Click checkbox next to it labelled "Change all column collations"
4. Click "Go" bottom right of "Table options" section

This should stop the issue from happening. The collation is likely just incorrect so data isn't storing properly. Then monitor things to see if it happens again.

Question: Is there an URL, where I can go to the history page and have either page 2, or just a single item displayed?

You can view a specific history entry by clicking whatever is in the "Message" column.