XF 2.0 Import error from vBulletin 3.8.9 to XF 2.0.2 InvalidArgumentException: Received invalid UTF-8 for string column [signature]

Earl

Well-known member
I'm trying to import vB 3.8.9 to XF 2.0.2. I used CLI importer and Browser both, but no luck.

`user` table has 555,467 rows, table type is MyISAM, collation is latin1_swedish_ci (145.9 MiB)


InvalidArgumentException: Received invalid UTF-8 for string column [signature]
src/XF/Import/Data/EntityEmulator.php:93



Code:
Stack trace
#0 src/XF/Import/Data/User.php(123): XF\Import\Data\EntityEmulator->set('signature', '[CENTER][IMG]ht...', Array)
#1 src/XF/Import/Data/AbstractData.php(292): XF\Import\Data\User->set('signature', '[CENTER][IMG]ht...')
#2 src/XF/Import/Importer/vBulletin.php(1119): XF\Import\Data\AbstractData->__set('signature', '[CENTER][IMG]ht...')
#3 src/XF/Import/Importer/vBulletin.php(988): XF\Import\Importer\vBulletin->setupImportUser(Array, Object(XF\Import\StepState), Array)
#4 src/XF/Import/Runner.php(160): XF\Import\Importer\vBulletin->stepUsers(Object(XF\Import\StepState), Array, 8)
#5 src/XF/Import/Runner.php(74): XF\Import\Runner->runStep('users', Object(XF\Import\StepState), 8)
#6 src/XF/Admin/Controller/Import.php(232): XF\Import\Runner->run()
#7 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\Import->actionRun(Object(XF\Mvc\ParameterBag))
#8 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', 'html', Object(XF\Mvc\ParameterBag), 'importData', Object(XF\Admin\Controller\Import), NULL)
#9 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(1889): XF\Mvc\Dispatcher->run()
#11 src/XF.php(328): XF\App->run()
#12 admin.php(13): XF::runApp('XF\\Admin\\App')
#13 {main}

-------------

Previous InvalidArgumentException: Received invalid UTF-8 for string column - src/XF/Mvc/Entity/ValueFormatter.php:100
#0 src/XF/Import/Data/EntityEmulator.php(89): XF\Mvc\Entity\ValueFormatter->castValueToType('[CENTER][IMG]ht...', 5, Array)
#1 src/XF/Import/Data/User.php(123): XF\Import\Data\EntityEmulator->set('signature', '[CENTER][IMG]ht...', Array)
#2 src/XF/Import/Data/AbstractData.php(292): XF\Import\Data\User->set('signature', '[CENTER][IMG]ht...')
#3 src/XF/Import/Importer/vBulletin.php(1119): XF\Import\Data\AbstractData->__set('signature', '[CENTER][IMG]ht...')
#4 src/XF/Import/Importer/vBulletin.php(988): XF\Import\Importer\vBulletin->setupImportUser(Array, Object(XF\Import\StepState), Array)
#5 src/XF/Import/Runner.php(160): XF\Import\Importer\vBulletin->stepUsers(Object(XF\Import\StepState), Array, 8)
#6 src/XF/Import/Runner.php(74): XF\Import\Runner->runStep('users', Object(XF\Import\StepState), 8)
#7 src/XF/Admin/Controller/Import.php(232): XF\Import\Runner->run()
#8 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\Import->actionRun(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', 'html', Object(XF\Mvc\ParameterBag), 'importData', Object(XF\Admin\Controller\Import), NULL)
#10 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(1889): XF\Mvc\Dispatcher->run()
#12 src/XF.php(328): XF\App->run()
#13 admin.php(13): XF::runApp('XF\\Admin\\App')
#14 {main}


Code:
Request state
array(4) {
  ["url"] => string(21) "/admin.php?import/run"
  ["referrer"] => string(43) "http://www.site.com/admin.php?import/run"
  ["_GET"] => array(1) {
    ["import/run"] => string(0) ""
  }
  ["_POST"] => array(1) {
    ["_xfToken"] => string(8) "********"
  }
}


and another error

InvalidArgumentException: Received invalid UTF-8 for string column [username] src/XF/Import/Data/EntityEmulator.php:93
Code:
Stack trace
#0 src/XF/Import/Data/User.php(123): XF\Import\Data\EntityEmulator->set('username', 'dewasmith\xC3\x84\xEF\xBF\xBE1', Array)
#1 src/XF/Import/Data/AbstractData.php(292): XF\Import\Data\User->set('username', 'dewasmith\xC4\x811')
#2 src/XF/Import/Helper.php(103): XF\Import\Data\AbstractData->__set('username', 'dewasmith\xC4\x811')
#3 src/XF/Import/Importer/AbstractCoreImporter.php(107): XF\Import\Helper->importUser(108330, Object(XF\Import\Data\User), Array)
#4 src/XF/Import/Importer/vBulletin.php(993): XF\Import\Importer\AbstractCoreImporter->importUser(108330, Object(XF\Import\Data\User), Array)
#5 src/XF/Import/Runner.php(160): XF\Import\Importer\vBulletin->stepUsers(Object(XF\Import\StepState), Array, 8)
#6 src/XF/Import/Runner.php(74): XF\Import\Runner->runStep('users', Object(XF\Import\StepState), 8)
#7 src/XF/Admin/Controller/Import.php(232): XF\Import\Runner->run()
#8 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\Import->actionRun(Object(XF\Mvc\ParameterBag))
#9 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', 'html', Object(XF\Mvc\ParameterBag), 'importData', Object(XF\Admin\Controller\Import), NULL)
#10 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#11 src/XF/App.php(1889): XF\Mvc\Dispatcher->run()
#12 src/XF.php(328): XF\App->run()
#13 admin.php(13): XF::runApp('XF\\Admin\\App')
#14 {main}

-------------

Previous InvalidArgumentException: Received invalid UTF-8 for string column - src/XF/Mvc/Entity/ValueFormatter.php:100
#0 src/XF/Import/Data/EntityEmulator.php(89): XF\Mvc\Entity\ValueFormatter->castValueToType('dewasmith\xC3\x84\xEF\xBF\xBE1', 5, Array)
#1 src/XF/Import/Data/User.php(123): XF\Import\Data\EntityEmulator->set('username', 'dewasmith\xC3\x84\xEF\xBF\xBE1', Array)
#2 src/XF/Import/Data/AbstractData.php(292): XF\Import\Data\User->set('username', 'dewasmith\xC4\x811')
#3 src/XF/Import/Helper.php(103): XF\Import\Data\AbstractData->__set('username', 'dewasmith\xC4\x811')
#4 src/XF/Import/Importer/AbstractCoreImporter.php(107): XF\Import\Helper->importUser(108330, Object(XF\Import\Data\User), Array)
#5 src/XF/Import/Importer/vBulletin.php(993): XF\Import\Importer\AbstractCoreImporter->importUser(108330, Object(XF\Import\Data\User), Array)
#6 src/XF/Import/Runner.php(160): XF\Import\Importer\vBulletin->stepUsers(Object(XF\Import\StepState), Array, 8)
#7 src/XF/Import/Runner.php(74): XF\Import\Runner->runStep('users', Object(XF\Import\StepState), 8)
#8 src/XF/Admin/Controller/Import.php(232): XF\Import\Runner->run()
#9 src/XF/Mvc/Dispatcher.php(249): XF\Admin\Controller\Import->actionRun(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', 'html', Object(XF\Mvc\ParameterBag), 'importData', Object(XF\Admin\Controller\Import), NULL)
#11 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#12 src/XF/App.php(1889): XF\Mvc\Dispatcher->run()
#13 src/XF.php(328): XF\App->run()
#14 admin.php(13): XF::runApp('XF\\Admin\\App')
#15 {main}

Code:
Request state

array(4) {
  ["url"] => string(21) "/admin.php?import/run"
  ["referrer"] => string(43) "http://www.site.com/admin.php?import/run"
  ["_GET"] => array(1) {
    ["import/run"] => string(0) ""
  }
  ["_POST"] => array(1) {
    ["_xfToken"] => string(8) "********"
  }
}
 
Top Bottom