• Resolved ChaosZero112

    (@chaoszero112)


    App received next error message for this feed:
    flow\db\SafeMySQL: Incorrect string value: \xF0\x9F\x87\xA8\xF0\x9F... for column user_screenname at row 1. Full query: [INSERT INTO <code>wp_ff_posts</code> SET <code>creation_index</code>=1633035793, <code>feed_id</code>= sp54615 ,<code>post_id</code>= 1443305270076219400 ,<code>post_type</code>= twitter ,<code>post_permalink</code>= https://twitter.com/BradWButt/status/1443305270076219400 ,<code>user_nickname</code>= @BradWButt ,<code>user_screenname</code>= Brad Butt???? ,<code>user_pic</code>= https://pbs.twimg.com/profile_images/1332390894616662016/ruA0kuoQ_200x200.jpg ,<code>user_counts_media</code>= 0 ,<code>user_counts_follows</code>= 0 ,<code>user_counts_followed_by</code>= 0 ,<code>user_link</code>= https://twitter.com/BradWButt ,<code>post_source</code>= ,<code>post_status</code>= approved , <code>post_header</code>= ,<code>post_text</code>= RT @ShopLocalSauga: Tune in now! Come join us for a special announcement from Mayor @BonnieCrombie and @MBOTOntario President and CEO @tmcp… ,<code>post_timestamp</code>= 1632931366 ,<code>post_additional</code>= {\"shares\":\"7\",\"likes\":\"0\"} ON DUPLICATE KEY UPDATE <code>post_header</code>= ,<code>post_text</code>= RT @ShopLocalSauga: Tune in now! Come join us for a special announcement from Mayor @BonnieCrombie and @MBOTOntario President and CEO @tmcp… ,<code>post_timestamp</code>= 1632931366 ,<code>post_additional</code>= {\"shares\":\"7\",\"likes\":\"0\"} ]

    Possibly being caused by not handling the emoji in the screenname? Please provide assistance.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Oleksandr

    (@awesomeoman)

    Hi, please check and make sure you have the mbstring PHP extension enabled.
    Also, make sure that the charset of your DB is utf8mb4 to be able to store Unicode characters in DB tables. Please ask your developer or hosting support for help. Here is more info https://gist.github.com/Xeoncross/5d85c3f5547ee04d5bd81113a2c8ec4d.
    And also, make sure that your WordPress installation is using utf8mb4 as database encoding in the wp-config.php file.
    If this will not help, let us know.

    Thread Starter ChaosZero112

    (@chaoszero112)

    That fixed it. Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL Error’ is closed to new replies.