2022-04-26, 07:41 PM
While trying to convert my SMF data to myBB using the Merge system, I keep getting the following error:
"MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1366 - Incorrect string value: '\x80\x0A?,\x0A ...' for column 'message' at row 1"
The error appears while trying inserting the Users data, if I delete the specific user from the smf table it continues but it stops after a few users, I have too many users, I cannot delete one every 10-20 users, when it stops!
The error I get after that is something like the following:
"Query:
INSERT INTO mybb_debuglogs (
Any ideas as to what is wrong and how to solve it?
Thanks
"MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1366 - Incorrect string value: '\x80\x0A?,\x0A ...' for column 'message' at row 1"
The error appears while trying inserting the Users data, if I delete the specific user from the smf table it continues but it stops after a few users, I have too many users, I cannot delete one every 10-20 users, when it stops!
The error I get after that is something like the following:
"Query:
INSERT INTO mybb_debuglogs (
type
,message
,timestamp
) VALUES (8,'File: /merge/resources/modules/users.php Line: 176 Function: Log->datatrace -> \r\nFile: /merge/boards/smf2/users.php Line: 36 Function: Converter_Module_Users->insert -> \r\nFile: /merge/index.php Line: 948 Function: SMF2_Converter_Module_Users->import -> \r\n$data: array (\n \'id_member\' => \'8086\',\n \'member_name\' => \'Guest\',\n \'date_registered\' => \'1284587614\',\n \'posts\' => \'1\',\n \'id_group\' => \'0\',\n \'lngfile\' => \'\',\n \'last_login\' => \'1284674044\',\n \'real_name\' => \'Guest\',\n \'instant_messages\' => \'1\',\n \'unread_messages\' => \'1\',\n \'new_pm\' => \'1\',\n \'buddy_list\' => \'\',\n \'pm_ignore_list\' => \'\',\n \'pm_prefs\' => \'0\',\n \'mod_prefs\' => \'\',\n \'message_labels\' => \'\',\n \'passwd\' => \'$H$9pI93vl1cBhvxfS5dZl9QRqASrKN6C/\',\n \'email_address\' => \'[email protected]\',\n \'personal_text\' => \'\',\n \'birthdate\' => \'1004-01-01\',\n \'website_title\' => \'\',\n \'website_url\' => \'\',\n \'show_online\' => \'1\',\n \'time_format\' => \'\',\n \'signature\' => \'\',\n \'time_offset\' => \'0\',\n \'avatar\' => \'\',\n \'karma_bad\' => \'0\',\n \'karma_good\' => \'0\',\n \'usertitle\' => \'\',\n \'secret_question\' => \'\',\n \'secret_answer\' => \'\',\n \'id_theme\' => \'0\',\n \'is_activated\' => \'1\',\n \'validation_code\' => \'\',\n \'id_msg_last_visit\' => \'0\',\n \'additional_groups\' => \'20\',\n \'smiley_set\' => \'\',\n \'id_post_group\' => \'12\',\n \'total_time_logged_in\' => \'0\',\n \'password_salt\' => \'\',\n \'ignore_boards\' => \'\',\n \'warning\' => \'0\',\n \'passwd_flood\' => \'\',\n \'pm_receive_from\' => \'1\',\n \'alerts\' => \'0\',\n \'timezone\' => \'UTC\',\n \'tfa_secret\' => \'\',\n \'tfa_backup\' => \'\',\n \'member_ip\' => \'?�\n?,\n \'member_ip2\' => \'?�\n?,\n)',1651001932)"Any ideas as to what is wrong and how to solve it?
Thanks