MyBB Community Forums

Full Version: Forum Error/Help D:
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have recently made a website with hostinger.co.uk.
I deleted the default.php, (it said to do it) and it just showed the files. I then took the index.php files, copied and pasted it into a default.php I made. I then put it inside the FTP. I deleted the dir public_html\Install because it said there was an error.
So my problem is I am recieving this error:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1300 - Invalid utf8 character string: '821A0F'Query:DELETE FROM m96v_sessions WHERE ip=X'49821a0f'


How to fix? Thanks! --TJ
what is your forum url ? do you know which type of database you are using ?
(05-05-2016, 04:30 AM)TJ123 Wrote: [ -> ]MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1300 - Invalid utf8 character string: '821A0F'Query:DELETE FROM m96v_sessions WHERE ip=X'49821a0f'

Looks like your IP column is not set to BINARY somehow.
Login to your PHPMYADMIN, select your MYBB database and run this query in SQL section

ALTER TABLE `mybb_sessions` CHANGE `ip` `ip` VARBINARY(16) NOT NULL DEFAULT '';