vB 4.2 import: out or range error


Well-known member
Hi everyone,

we are currently trying to convert our vB 4.2 installation to XF and are running into the error below on our test server.

Your help is appreciated. :)

Server Error

Mysqli statement execute error : Out of range value adjusted for column 'message_count' at row 1
  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in XenForo/Importer/vBulletin.php at line 1287
  4. XenForo_Importer_vBulletin->_mergeUser() in XenForo/Importer/vBulletin.php at line 963
  5. XenForo_Importer_vBulletin->_importOrMergeUser() in XenForo/Importer/vBulletin.php at line 783
  6. XenForo_Importer_vBulletin->stepUsers() in XenForo/Importer/Abstract.php at line 77
  7. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
  8. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 132
  9. XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 310
  10. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  11. XenForo_FrontController->run() in /home/jrefme/public_html/forum/admin.php at line 13

Jake Bunce

XenForo moderator
Staff member
The line numbers indicate that you are using the vB 3.7/3.8 importer. The vB4 importer has you replace the library/XenForo/Importer/vBulletin.php file. Make sure you replaced that file. But that is not the cause of this error.

It appears that one of your users has an extremely high post count. The field should accept values up to 4.2 billion. Check your user records in both vB and XF for extremely high post counts. Such a post count is likely wrong. Manually editing and decreasing the value should avoid this error. You can rebuild the post counts afterwards:


Jake Bunce

XenForo moderator
Staff member
You can run this query on your vB database to nuke the post counts:

SET posts = 0;

Or run vB's rebuild utility:

Admin CP -> Maintenance -> Update Counters