MyBB Community Forums

Full Version: SQL Error 1300 invalid uft8mb4 character string
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi,

I have just updated MYBB software and i have a lot of problems with mYy SQL DB . Now,  when i try to add me like a new register user it comes this error:


MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1300 - Invalid utf8mb4 character string: 'BBD07D'

Query: SELECT * FROM mybb_users WHERE regip=X'bbd07d8d' AND regdate > '1459983412'

I tried all the possible solutions that are here in the forum but i didn´t undestand it all and i wish you may help me with the steps to solution this problem.

I´ve tried to change the regip to uftmb4 but thats did not solve my problem. same with the variable regdate. i used PHPMyAdmin as my DB.

Thank you so much Big Grin
From which to which version did you upgrade?
Hi Destroy 666

Fists of all thanks for the answer. i upgraded from 1.8.6 to 1.8.7 version
(2016-04-09, 11:43 PM)AlbertoG Wrote: [ -> ]Hi Destroy 666

Fists of all thanks for the answer. i upgraded from 1.8.6 to 1.8.7 version

I have also upgraded same version when an errors occurred. That's why I really browse that might help me with it. Thanks God!