Problems with importing users from vB

[Mine-Play]

I have a problem with importing users from vB 4.x to xF 2.0.4 (I also tried to import to 1.5.18).

In last time all was be ok (there were ~450000 users) but now I have this error (at now ~950000 users):

XF\Db\InvalidQueryException: MySQL query error [1104]: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay in src/XF/Db/AbstractStatement.php at line 212
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 77
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->fetchAll() in src/addons/XFI/Import/Importer/vBulletin.php at line 996
XFI\Import\Importer\vBulletin->stepUsers() in src/XF/Import/Runner.php at line 160
XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 74
XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line 232
XF\Admin\Controller\Import->actionRun() in src/XF/Mvc/Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1891
XF\App->run() in src/XF.php at line 328
XF::runApp() in admin.php at line 13

I tried to change MySQL settings and downgrade forum to 1.5.x but it doesn't help. How to fix it?

 

[Chris D]

If you ask your host to set sql_big_selects to 1 (probably just temporarily while the import takes place) then that should sort it.