I attempted to import from my 3.8 site while it was closed. Still can't import PMs and forums.
Server Error
Mysqli statement execute error : Incorrect string value: '\xF4\x80\x82\x83 H...' for column 'message' at row 1
Zend_Db_Statement_Mysqli->_execute() in M:\xampp\htdocs\xenforo\library\Zend\Db\Statement.php at line 300
Zend_Db_Statement->execute() in M:\xampp\htdocs\xenforo\library\Zend\Db\Adapter\Abstract.php at line 468
Zend_Db_Adapter_Abstract->query() in M:\xampp\htdocs\xenforo\library\Zend\Db\Adapter\Abstract.php at line 546
Zend_Db_Adapter_Abstract->insert() in M:\xampp\htdocs\xenforo\library\XenForo\DataWriter.php at line 1484
XenForo_DataWriter->_insert() in M:\xampp\htdocs\xenforo\library\XenForo\DataWriter.php at line 1473
XenForo_DataWriter->_save() in M:\xampp\htdocs\xenforo\library\XenForo\DataWriter.php at line 1287
XenForo_DataWriter->save() in M:\xampp\htdocs\xenforo\library\XenForo\Model\Import.php at line 253
XenForo_Model_Import->_importData() in M:\xampp\htdocs\xenforo\library\XenForo\Model\Import.php at line 770
XenForo_Model_Import->importPost() in M:\xampp\htdocs\xenforo\library\XenForo\Importer\vBulletin.php at line 1794
XenForo_Importer_vBulletin->stepThreads() in M:\xampp\htdocs\xenforo\library\XenForo\Importer\Abstract.php at line 77
XenForo_Importer_Abstract->runStep() in M:\xampp\htdocs\xenforo\library\XenForo\ControllerAdmin\Import.php at line 152
XenForo_ControllerAdmin_Import->_runStep() in M:\xampp\htdocs\xenforo\library\XenForo\ControllerAdmin\Import.php at line 101
XenForo_ControllerAdmin_Import->actionImport() in M:\xampp\htdocs\xenforo\library\XenForo\FrontController.php at line 303
XenForo_FrontController->dispatch() in M:\xampp\htdocs\xenforo\library\XenForo\FrontController.php at line 132
XenForo_FrontController->run() in M:\xampp\htdocs\xenforo\admin.php at line 13i change some lines in the converter file with preg_match string, to change the messagetext to another one with the postID, in case that "\xF4\x80\x82\x83" will in the message, but the pregmatch don't hit anything.
..... sorry, how did you manage to find the postID of the offending message? This is exactly what I am struggling to do - I want to pin down the message that is bawking this and not having a great deal of lucki change some lines in the converter file with preg_match string, to change the messagetext to another one with the postID, in case that "\xF4\x80\x82\x83" will in the message, but the pregmatch don't hit anything.
The good thing was, the process don't stop afterwards, don't know whats happend, but the conversion was successful at the end
if (isset($user['field1']))
{
$import['about'] = $this->_convertToUtf8($user['field1']) . "\n\n" . $this->_convertToUtf8($user['field3']);
}
// TODO: potentially import additional custom fields as about if (isset($user['field1']))
{
if (isset($user['field3']))
{
$import['about'] = $this->_convertToUtf8($user['field1']) . "\n\n" . $this->_convertToUtf8($user['field3']);
}
else
{
$import['about'] = $this->_convertToUtf8($user['field1']);
}
}
// TODO: potentially import additional custom fields as about $import = array(
'thread_id' => $threadId,
'user_id' => $this->_mapLookUp($userIdMap, $post['userid'], 0),
'username' => $this->_convertToUtf8($post['username'], true),
'post_date' => $post['dateline'],
'message' => $this->_convertToUtf8($post['pagetext']),
'attach_count' => $post['attach'],
'ip' => $post['ipaddress']
); $post['pagetext'] = $this->_convertToUtf8($post['pagetext']);
if (preg_match('#\xF4\x80\x82\x83#',$post['pagetext'])) $post['pagetext'] = $this->_convertToUtf8('error '.$threadId.' findthetext');
$import = array(
'thread_id' => $threadId,
'user_id' => $this->_mapLookUp($userIdMap, $post['userid'], 0),
'username' => $this->_convertToUtf8($post['username'], true),
'post_date' => $post['dateline'],
'message' => $post['pagetext'],
'attach_count' => $post['attach'],
'ip' => $post['ipaddress']
);
