XF 2.1 Importer Error

[whtevrwt]

Hi.

I'm trying to import my Invision Community to XenForo using the Importer. I enter the details correctly but when I start the importing process, I get this error:

XF\Db\Exception: MySQL query error [1265]: Data truncated for column 'permission_value' at row 12 src/XF/Db/AbstractStatement.php:217
   
     INSERT  INTO `xf_permission_entry` (`user_group_id`, `user_id`, `permission_group_id`, `permission_id`, `permission_value`, `permission_value_int`) VALUES (14,0,'general','view','allow',0),
(14,0,'general','viewNode','allow',0),
(14,0,'general','viewProfile','allow',0),
(14,0,'general','viewMemberList','allow',0),
(14,0,'general','search','allow',0),
(14,0,'forum','viewAttachment','allow',0),
(14,0,'forum','viewContent','allow',0),
(14,0,'forum','viewOthers','allow',0),
(14,0,'forum','react','allow',0),
(14,0,'forum','deleteOwnPost','allow',0),
(14,0,'forum','editOwnPost','allow',0),
(14,0,'forum','editOwnPostTimeLimit',0,0),
(14,0,'forum','uploadAttachment','allow',0),
(14,0,'forum','votePoll','allow',0),
(14,0,'profilePost','view','allow',0),
(14,0,'profilePost','post','allow',0),
(14,0,'profilePost','comment','allow',0),
(14,0,'profilePost','react','allow',0),
(14,0,'conversation','start','allow',0),
(14,0,'conversation','receive','allow',0),
(14,0,'conversation','maxRecipients',0,0),
(14,0,'avatar','allowed','allow',0) ON DUPLICATE KEY UPDATE permission_value = VALUES(permission_value), permission_value_int = VALUES(permission_value_int)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1265, '01000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1265, '01000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(274): XF\Db\AbstractAdapter->query('INSERT  INTO `x...')
#4 src/XF/Import/DataHelper/Permission.php(152): XF\Db\AbstractAdapter->insertBulk('xf_permission_e...', Array, false, 'permission_valu...')
#5 src/XF/Import/DataHelper/Permission.php(12): XF\Import\DataHelper\Permission->insertPermissionsInternal('group', 14, Array, false)
#6 src/XF/Import/Data/UserGroup.php(30): XF\Import\DataHelper\Permission->insertUserGroupPermissions(14, Array)
#7 src/XF/Import/Data/AbstractData.php(136): XF\Import\Data\UserGroup->postSave(14, 14)
#8 src/addons/XFI/Import/Importer/IpsForums.php(407): XF\Import\Data\AbstractData->save(14)
#9 src/XF/Import/Runner.php(231): XFI\Import\Importer\IpsForums->stepUserGroups(Object(XF\Import\StepState), Array, 8)
#10 src/XF/Import/Runner.php(59): XF\Import\Runner->runStep('userGroups', Object(XF\Import\StepState), 8)
#11 src/XF/Admin/Controller/Import.php(234): XF\Import\Runner->run()
#12 src/XF/Mvc/Dispatcher.php(321): XF\Admin\Controller\Import->actionRun(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Import), NULL)
#14 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Import), NULL)
#15 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#17 src/XF.php(390): XF\App->run()
#18 admin.php(13): XF::runApp('XF\\Admin\\App')
#19 {main}

And this is the Request state I get with it:

array(4) {
  ["url"] => string(29) "/xenforo/admin.php?import/run"
  ["referrer"] => string(45) "https://domain.com/xenforo/admin.php?import/"
  ["_GET"] => array(1) {
    ["import/run"] => string(0) ""
  }
  ["_POST"] => array(1) {
    ["_xfToken"] => string(8) "********"
  }
}

Anyone able to help me with this?

 

[PrettyPixels]

I got a similar error and was referred here: https://xenforo.com/community/threads/ips-permissions-import-bug.165336/