vB 4.2 import: out or range error

[thomas1]

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]

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/

 

[thomas1]

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]

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

UPDATE user
SET posts = 0;

Or run vB's rebuild utility:

Admin CP -> Maintenance -> Update Counters

 

[thomas1]

Or run vB's rebuild utility:

Admin CP -> Maintenance -> Update Counters

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