1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

vB 4.2 import: out or range error

Discussion in 'Installation, Upgrade, and Import Support' started by thomas1, Mar 28, 2013.

  1. thomas1

    thomas1 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
     
  2. Jake Bunce

    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:

    http://xenforo.com/community/resources/rebuild-user-post-counts-query.363/
     
  3. thomas1

    thomas1 Member

    Thanks Jake.

    I have just found a post stating that this was caused by an old vB3 bug. We actually have 256 users with a post count of 4,294,967,295.
     
    Jake Bunce likes this.
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    You can run this query on your vB database to nuke the post counts:

    Code:
    UPDATE user
    SET posts = 0;
    
    Or run vB's rebuild utility:

    Admin CP -> Maintenance -> Update Counters
     
  5. thomas1

    thomas1 Member

    That's what I did in the end. Our DB is 11 years old, time for a good spring cleaning.
     

Share This Page