MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1300 - Invalid utf8 character string: 'AE86B4'
Query:
SELECT * FROM mybb_sessions WHERE sid='76436901158378ae531327edf6890862' AND ip=X'ae86b4ac'
I'm getting that when trying to upgrade 1.6 to 1.8 in a test installation.
is that IP address ? what exactly is the character encoding used ?
you may have to change the encoding of that column or empty the column
There was nothing with that session id or IP listed which was very unusual.
I completely emptied mybb_sessions and the error continues to persist with the same error. I went back down to 1.6 and dropped the sessions and we were able to login just fine. But, added 1.8 files back and that error spits up again.
Encoding is: utf8_general_ci
I think this is very odd :/.
Alright! .m. I investgated this issue and with another person that had this error too.
I have tested it on MySQL 5.5 perfect. But, MariaDB 10 is not working at all.
I created a 100% fresh installation of 1.6 and tried to upgrade, never even logged into the forum.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1300 - Invalid utf8 character string: 'AE86B4'
Query:
SELECT * FROM mybb_sessions WHERE sid='b5223716007c2c29e88eca64751e54e2' AND ip=X'ae86b4ac'
When I tried it on a server without MariaDB it worked fine. But, with MariaDB 10.
So is MyBB no longer compatible with MariaDB 10?