Cannot reproduce  Importing Problem

Im trying to import users from vbulletin, i have tried everything to try to find the duplicate entry but i can't.
Server Error

Mysqli statement execute error : Duplicate entry '22612' for key 'PRIMARY'
  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 Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1500
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1489
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1291
  7. XenForo_DataWriter->save() in XenForo/Model/Import.php at line 416
  8. XenForo_Model_Import->importUser() in XenForo/Importer/vBulletin.php at line 859
  9. XenForo_Importer_vBulletin->_importUser() in XenForo/Importer/vBulletin.php at line 678
  10. XenForo_Importer_vBulletin->_importOrMergeUser() in XenForo/Importer/vBulletin.php at line 469
  11. XenForo_Importer_vBulletin->stepUsers() in XenForo/Importer/Abstract.php at line 77
  12. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 161
  13. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 105
  14. XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 310
  15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
  16. XenForo_FrontController->run() in /Applications/MAMP/htdocs/hidemenow/admin.php at line 13


XenForo developer
Staff member
I can't see why this would happen unless something was messed up in the table itself. We don't set the target user_id, so MySQL should set itself to something that hasn't been allocated.

If you do a reinstall, can you reproduce it?


This problem came back when you run the import again? Basically a showstopper?
i impex it vbulletin to vbulletin now im converting vbulletin to xenforo users and everything imported fine but only thing i can't get to convert is the pm's i get the message below

is Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'last_message_username' at row 1 - library/Zend/Db/Statement/Mysqli.php:214



XenForo developer
Staff member
Regarding the first issue, is there any way I can get access to the data to do a test import? I really can't see what would cause this.