SQL error in Admin: Character set ‘binary’ cannot be used with ‘u

  • Admin gives database error messages below:

    [Character set ‘binary’ cannot be used in conjunction with ‘utf8mb4_unicode_520_ci’ in call to regexp_like.]
    SELECT wp_posts.*, meta_value as sked FROM wp_posts JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID WHERE post_type=’rsvpmaker’ AND BINARY meta_key REGEXP ‘_sked_[A-Z].+’ and meta_value AND post_status=’publish’ GROUP BY wp_posts.ID ORDER BY post_title

    at

    /wp-admin/edit.php?post_type=rsvpmaker&page=rsvpmaker_template_list

  • The topic ‘SQL error in Admin: Character set ‘binary’ cannot be used with ‘u’ is closed to new replies.