History will not display

Top of the Simple History Dashboard states 77 events today from one user and 2 other sources, however no history is displayed, only the message “Your search did not match any history events.”

I am in Troubleshooting Mode running the Twenty Twenty Two theme with ALL other plugins disabled.

—-

I found the following error in the debug log:

[16-Dec-2022 23:28:53 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' for query 
				/*NO_SELECT_FOUND_ROWS*/
				SELECT
					SQL_CALC_FOUND_ROWS
					h.id,
					h.logger,
					h.level,
					h.date,
					h.message,
					h.initiator,
					h.occasionsID,
					count(t.repeated) AS subsequentOccasions,
					t.rep,
					t.repeated,
					t.occasionsIDType,
					c1.value AS context_message_key

				FROM OkQ_simple_history AS h

				LEFT OUTER JOIN OkQ_simple_history_contexts AS c1 ON (c1.history_id = h.id AND c1.key = "_message_key")

				INNER JOIN (
					SELECT
						id,
						IF(@a=occasionsID,@counter:=@counter+1,@counter:=1) AS rep,
						IF(@counter=1,@groupby:=@groupby+1,@groupby) AS repeated,
						@a:=occasionsID occasionsIDType
					FROM OkQ_simple_history AS h2

					# First/inner where
					WHERE
						1 = 1 AND logger IN ("SimpleCommentsLogger", "SimpleCoreUpdatesLogger", "SimpleExportLogger", "SimpleLogger", "SimpleMediaLogger", "SimpleMenuLogger", "SimpleOptionsLogger", "SimplePluginLogger", "SimplePostLogger", "SimpleThemeLogger", "SimpleUserLogger", "SimpleCategoriesLogger", "AvailableUpdatesLogger", "FileEditsLogger", "SH_Privacy_Logger", "SH_Translations_Logger", "SH_Jetpack_Logger", "PluginUserSwitchingLogger", "PluginWPCrontrolLogger", "PluginEnableMediaReplaceLogger", "Plugin_UltimateMembers_Logger", "Plugin_LimitLoginAttempts", "Plugin_Redirection", "Plugin_DuplicatePost", "Plugin_ACF", "Plugin_BeaverBuilder")
 AND date >= "2022-12-16 00:00:00"

					ORDER BY id DESC, date DESC
				) AS t ON t.id = h.id

				WHERE
					# Outer/Second where
					1 = 1

				GROUP BY repeated
				ORDER BY id DESC, date DESC
				LIMIT 0, 1
			 made by require_once('wp-admin/admin.php'), do_action('dashboard_page_simple_history_page'), WP_Hook->do_action, WP_Hook->apply_filters, SimpleHistory->history_page_output, do_action('simple_history/history_page/before_gui'), WP_Hook->do_action, WP_Hook->apply_filters, SimpleHistory->output_quick_stats, SimpleHistoryLogQuery->query
[16-Dec-2022 23:28:54 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' for query 
				/*NO_SELECT_FOUND_ROWS*/
				SELECT
					SQL_CALC_FOUND_ROWS
					h.id,
					h.logger,
					h.level,
					h.date,
					h.message,
					h.initiator,
					h.occasionsID,
					count(t.repeated) AS subsequentOccasions,
					t.rep,
					t.repeated,
					t.occasionsIDType,
					c1.value AS context_message_key

				FROM OkQ_simple_history AS h

				LEFT OUTER JOIN OkQ_simple_history_contexts AS c1 ON (c1.history_id = h.id AND c1.key = "_message_key")

				INNER JOIN (
					SELECT
						id,
						IF(@a=occasionsID,@counter:=@counter+1,@counter:=1) AS rep,
						IF(@counter=1,@groupby:=@groupby+1,@groupby) AS repeated,
						@a:=occasionsID occasionsIDType
					FROM OkQ_simple_history AS h2

					# First/inner where
					WHERE
						1 = 1 AND logger IN ("SimpleCommentsLogger", "SimpleCoreUpdatesLogger", "SimpleExportLogger", "SimpleLogger", "SimpleMediaLogger", "SimpleMenuLogger", "SimpleOptionsLogger", "SimplePluginLogger", "SimplePostLogger", "SimpleThemeLogger", "SimpleUserLogger", "SimpleCategoriesLogger", "AvailableUpdatesLogger", "FileEditsLogger", "SH_Privacy_Logger", "SH_Translations_Logger", "SH_Jetpack_Logger", "PluginUserSwitchingLogger", "PluginWPCrontrolLogger", "PluginEnableMediaReplaceLogger", "Plugin_UltimateMembers_Logger", "Plugin_LimitLoginAttempts", "Plugin_Redirection", "Plugin_DuplicatePost", "Plugin_ACF", "Plugin_BeaverBuilder")

				# lastdays
				AND date >= DATE(NOW()) - INTERVAL 30 DAY
			

					ORDER BY id DESC, date DESC
				) AS t ON t.id = h.id

				WHERE
					# Outer/Second where
					1 = 1

				GROUP BY repeated
				ORDER BY id DESC, date DESC
				LIMIT 0, 20
			 made by do_action('wp_ajax_simple_history_api'), WP_Hook->do_action, WP_Hook->apply_filters, SimpleHistory->api, SimpleHistoryLogQuery->query