2017-08-26, 02:53 AM
Trying to merge the old database with the new one but it stuck at the user import.
Old MYBB 1.8 to New MYBB 1.8 installation
Below is the full error
Old MYBB 1.8 to New MYBB 1.8 installation
Below is the full error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1366 - Incorrect string value: '\x80?',\x0A ...' for column 'message' at row 1
Query:
INSERT INTO mybb_debuglogs (`type`,`message`,`timestamp`) VALUES (8,'File: /merge/resources/modules/users.php Line: 178 Function: Log->datatrace -> \r\nFile: /merge/boards/mybb/users.php Line: 36 Function: Converter_Module_Users->insert -> \r\nFile: /merge/index.php Line: 946 Function: MYBB_Converter_Module_Users->import -> \r\n$data: array (\n \'uid\' => \'17\',\n \'username\' => \'wixxs abaton\',\n \'password\' => \'34778f66e2e38275efde1ff14a70f39e\',\n \'salt\' => \'25Riookd\',\n \'loginkey\' => \'c968UnR5Nwn513oZcjrcX4mAfeMOVQbGhMzO2aHAXlr25LWJ4Z\',\n \'email\' => \'[email protected]\',\n \'postnum\' => \'0\',\n \'threadnum\' => \'0\',\n \'avatar\' => \'\',\n \'avatardimensions\' => \'\',\n \'avatartype\' => \'\',\n \'usergroup\' => \'2\',\n \'additionalgroups\' => \'\',\n \'displaygroup\' => \'0\',\n \'usertitle\' => \'\',\n \'regdate\' => \'1440992040\',\n \'lastactive\' => \'1440992129\',\n \'lastvisit\' => \'1440992040\',\n \'lastpost\' => \'0\',\n \'website\' => \'\',\n \'icq\' => \'0\',\n \'aim\' => \'\',\n \'yahoo\' => \'\',\n \'skype\' => \'\',\n \'google\' => \'\',\n \'birthday\' => \'\',\n \'birthdayprivacy\' => \'all\',\n \'signature\' => \'\',\n \'allownotices\' => \'0\',\n \'hideemail\' => \'0\',\n \'subscriptionmethod\' => \'0\',\n \'invisible\' => \'0\',\n \'receivepms\' => \'0\',\n \'receivefrombuddy\' => \'0\',\n \'pmnotice\' => \'0\',\n \'pmnotify\' => \'0\',\n \'buddyrequestspm\' => \'1\',\n \'buddyrequestsauto\' => \'0\',\n \'threadmode\' => \'linear\',\n \'showimages\' => \'1\',\n \'showvideos\' => \'1\',\n \'showsigs\' => \'1\',\n \'showavatars\' => \'1\',\n \'showquickreply\' => \'1\',\n \'showredirect\' => \'1\',\n \'ppp\' => \'0\',\n \'tpp\' => \'0\',\n \'daysprune\' => \'0\',\n \'dateformat\' => \'\',\n \'timeformat\' => \'\',\n \'timezone\' => \'\',\n \'dst\' => \'0\',\n \'dstcorrection\' => \'0\',\n \'buddylist\' => \'\',\n \'ignorelist\' => \'\',\n \'style\' => \'3\',\n \'away\' => \'0\',\n \'awaydate\' => \'0\',\n \'returndate\' => \'0\',\n \'awayreason\' => \'\',\n \'pmfolders\' => \'\',\n \'notepad\' => \'\',\n \'referrer\' => \'0\',\n \'referrals\' => \'0\',\n \'reputation\' => \'0\',\n \'regip\' => \'?�?\',\n \'lastip\' => \'?�?\',\n \'language\' => \'\',\n \'timeonline\' => \'89\',\n \'showcodebuttons\' => \'1\',\n \'totalpms\' => \'0\',\n \'unreadpms\' => \'0\',\n \'warningpoints\' => \'0\',\n \'moderateposts\' => \'0\',\n \'moderationtime\' => \'0\',\n \'suspendposting\' => \'0\',\n \'suspensiontime\' => \'0\',\n \'suspendsignature\' => \'0\',\n \'suspendsigtime\' => \'0\',\n \'coppauser\' => \'0\',\n \'classicpostbit\' => \'0\',\n \'loginattempts\' => \'1\',\n \'usernotes\' => \'\',\n \'sourceeditor\' => \'0\',\n \'usemobileversion\' => \'1\',\n \'myalerts_disabled_alert_types\' => \'[]\',\n)',1503715777)