SQL error on v. 7.6.29

Resolved George
(@giorgos93)

1 year ago

Hi, I use v. 7.6.29 of your plugin atm, so idk if this was fixed in future versions or not. But just in case:

Yesterday some user left a comment on my website. The comment contained this emoticon (from default Android phone emoticons): 💕

However, this emoticon was automatically removed from the comment, and I get this error in logs:

WordPress database error Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '=' for query SELECT comment_ID FROM wp_comments WHERE comment_post_ID = 3945 AND comment_parent = '0' AND comment_approved != 'trash' AND ( comment_author = 'Светлана' AND comment_author_email = 'authors email' ) AND comment_content = 'Да, знакома, и мне очень нравится этот автор) Прочитала практически все произведения, выложенные Сергеем на АТ. Что удивительно, нравятся даже книги, написанные в соавторстве с Вязовским, хотя самого Алексея читать не получается, не моё.\r\nЖелаю Сергею дальнейших творческих успехов в соавторстве и без) 💕' LIMIT 1 made by do_action('wp_ajax_nopriv_wpdAddComment'), WP_Hook->do_action, WP_Hook->apply_filters, WpdiscuzCore->addComment, wp_new_comment, wp_allow_comment

The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)

Plugin Support gVectors Support
(@gvectorssupport)

1 year ago

Hi,

This issue is not caused by the wpDiscuz plugin. To resolve it, you’ll need to update your database collation from utf8mb3 to utf8mb4.

Thread Starter George
(@giorgos93)

1 year ago

It did help, thank you!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘SQL error on v. 7.6.29’ is closed to new replies.