WordPress database error: Character set ‘binary’ cannot be used

  • Resolved buckrackley

    (@buckrackley)


    1 year, 4 months ago

    Hello! First off, thank you. I love your work.

    I’m getting an error across the top of any admin page:

    WordPress database error: [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_template' AND BINARY meta_key REGEXP '_sked_[A-Z].+' and meta_value AND post_status='publish' GROUP BY wp_posts.ID ORDER BY post_title

    On the user side, any page that has RSVPmaker components displays as a blank page. Which is kinda scary cause it’s the whole events section.

    I didn’t make any changes on my end. This message and behavior was there when I logged in today, after a few days of inactivity.

    Do you have any suggestions I could try?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author davidfcarr

    (@davidfcarr)

    I just put out an update that removes that binary keyword from the sql code, as the reason for it is obsolete. Let me know if installing that solves the issue.

    Thread Starter buckrackley

    (@buckrackley)

    Solved it! Thank you so much!!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress database error: Character set ‘binary’ cannot be used’ is closed to new replies.