Plugin received next error message from network API for this feed

Resolved amadamaria
(@amadamaria)

7 years, 5 months ago

Hi!

I am getting this error on twitter – Plugin received next error message from network API for this feed
Here are screen shot – https://prnt.sc/lumequ

flow\db\SafeMySQL: Incorrect string value: \xF0\x9F\x97\xA3\xE0\xA4… for column user_screenname at row 1. Full query: [INSERT INTO wp_ff_posts SET creation_index=1544729049, feed_id= ms18614 ,post_id= 1073297481239355392 ,post_type= twitter ,post_permalink=

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

Plugin Contributor Oleksandr
(@awesomeoman)

7 years, 5 months ago

Hi, please check and make sure you have mbstring PHP extension enabled.
Also, make sure that charset of your DB is utf8mb4 to be able to store Unicode characters in DB tables. Please ask for this your developer or hosting help. Here is more info https://gist.github.com/Xeoncross/5d85c3f5547ee04d5bd81113a2c8ec4d

disagree
(@disagree)

7 years ago

Another solution for this is to change in wp-config.php :
define( 'DB_CHARSET', 'utf8' );
to
define( 'DB_CHARSET', 'utf8mb4' );

Ahmad Mushtaq
(@ahmad-mushtaq)

6 years, 10 months ago

So I am using PHP 7.3 on Ubuntu 18.04 and have the mbstring extension enabled.
Also, I added define( ‘DB_CHARSET’, ‘utf8mb4’ ); to my wp-config.

But still can’t enable the Instagram feed and receiving the following error:

flow\db\SafeMySQL: Incorrect string value: \xF0\x9F\x87\xB8\xF0\x9F… for column user_screenname at row 1. Full query: [INSERT INTO inj_ff_posts SET creation_index=1564548900, feed_id= yb21482 ,post_id= 2087994395857465637 ,post_type= instagram ,post_permalink= https://www.instagram.com/p/Bz6C9ciFzEl ,user_nickname= injazsaudiarabia ,user_screenname= Injaz Saudi Arabia 🇸🇦 ,user_pic= https://scontent-frt3-1.cdninstagram.com/vp/4448d87addead0aaf59f808da1b5a6a3/5DC916BF/t51.2885-19/s150x150/46263179_578011805977859_2793170541446430720_n.jpg?_nc_ht=scontent-frt3-1.cdninstagram.com ,user_bio= ,user_counts_media= 0 ,user_counts_follows= 0 ,user_counts_followed_by= 0 ,user_link= http://instagram.com/injazsaudiarabia ,post_source= ,location= ,smart_order= 0 ,post_status= approved , image_url= https://scontent-frt3-1.cdninstagram.com/vp/db0b65214c77595190dff53a844ef9a8/5DE49648/t51.2885-15/sh0.08/e35/s640x640/65579731_2302562996665402_5269777804537677537_n.jpg?_nc_ht=scontent-frt3-1.cdninstagram.com , image_width=300, image_height=300, media_url= https://scontent-frt3-1.cdninstagram.com/vp/ecb7f50ba3cdcb5055c03be24315131d/5DD1A68C/t51.2885-15/sh0.08/e35/s750x750/65579731_2302562996665402_5269777804537677537_n.jpg?_nc_ht=scontent-frt3-1.cdninstagram.com , media_width=600, media_height=600, media_type= image , post_header= ,post_text=

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

The topic ‘Plugin received next error message from network API for this feed’ is closed to new replies.