Database error on Assignments tab

Receiving the following error in the Assignments page.

`WordPress database error: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']
SELECT COUNT(*) FROM wp_broo_user_assignment a LEFT JOIN wp_posts p ON ( a.type = p.post_type AND a.value = p.ID AND p.post_status = "publish" ) WHERE ( ( a.type = "badge" AND p.post_status = "publish" ) OR ( a.type = "points" ) ) AND ( a.expiry_dt >= NOW() OR a.expiry_dt IS NULL )

WordPress database error: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']
SELECT COUNT(*) FROM wp_broo_user_assignment a LEFT JOIN wp_posts p ON ( a.type = p.post_type AND a.value = p.ID AND p.post_status = "publish" ) WHERE ( ( a.type = "badge" AND p.post_status = "publish" ) OR ( a.type = "points" ) ) AND ( a.expiry_dt >= NOW() OR a.expiry_dt IS NULL ) AND a.status = "approved"

WordPress database error: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']
SELECT COUNT(*) FROM wp_broo_user_assignment a LEFT JOIN wp_posts p ON ( a.type = p.post_type AND a.value = p.ID AND p.post_status = "publish" ) WHERE ( ( a.type = "badge" AND p.post_status = "publish" ) OR ( a.type = "points" ) ) AND ( a.expiry_dt >= NOW() OR a.expiry_dt IS NULL ) AND a.status = "pending"

WordPress database error: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']
SELECT COUNT(*) FROM wp_broo_user_assignment a LEFT JOIN wp_posts p ON ( a.type = p.post_type AND a.value = p.ID AND p.post_status = "publish" ) WHERE ( ( a.type = "badge" AND p.post_status = "publish" ) OR ( a.type = "points" ) ) AND ( a.expiry_dt >= NOW() OR a.expiry_dt IS NULL ) AND a.status = "unapproved" `