2014-11-06, 01:36 PM
Hi, I am trying to upgrade my BB forum from 1.6.15 to 1.8.1 but as soon as I run the upgrade script I get the following error:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1366 - Incorrect string value: '\xF5z' for column 'ip' at row 1Query:REPLACE INTO mybb_sessions SET
I would appreciate any help on this, I have updated MySQL to the latest version but still get the same error.
Thanks in advance for any suggestions.
Paul.
Think I solved it, I replaced "inc/class_session.php" with the one from my backup, then run the upgrade, which ran ok and then uploaded the new class_session.php after the upgrade.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1366 - Incorrect string value: '\xF5z' for column 'ip' at row 1Query:REPLACE INTO mybb_sessions SET
uid
='1',sid
='fc85afc1ce4edb9149a92f53cffd1bda',time
='1415280589',ip
=X'521ef57a',location
='/forum/install/upgrade.php',useragent
='Mozilla/5.0 (Windows NT 6.1; rv:33.0) Gecko/20100101 Firefox/33.0',location1
='0',location2
='0',nopermission
='0'I would appreciate any help on this, I have updated MySQL to the latest version but still get the same error.
Thanks in advance for any suggestions.
Paul.
Think I solved it, I replaced "inc/class_session.php" with the one from my backup, then run the upgrade, which ran ok and then uploaded the new class_session.php after the upgrade.