XF 1.1 Import login problem

[Adam H]

Hi Guys, Im testing an import and got to the first stage lol.

Ive ticked the box to Retain imported content IDs and basically as soon as i start importing users it logs me out, I try to log back in and it says the account doesnt have admin permissions.

Ive tried changing the admin account email address and username to something totally random incase it was crossing with another user so the only thing i can think of is that the userid is being overwritten ?

If so is there a way to stop that from happening ?

 

[Adam H]

I can confirm that with out ticking the "Retain imported content IDs" the users import perfectly , Is there away around this ?

 

[Paul B]

Which importer are you using?

 

[Adam H]

VB 3 , However it is a VB4 board. Just didnt see a VB4 importer :S

 

[Paul B]

1.1 vB4 importer: http://xenforo.com/community/threads/vbulletin-4-importer-to-xenforo-1-1.23674/

1.0 vB4 importer: http://xenforo.com/community/threads/vbulletin-4-importer.5726/

 

[Adam H]

Haha , Thanks Brogan ill give that a shot

 

[Mike]

This happens if your user ID 1 in the source database exists but isn't an administrator -- otherwise, we wouldn't be able to maintain that user's ID. You should have another administrator, so you should be able to login with that and pick up the import.

 

[Adam H]

Thanks Mike that makes sense as the user id #1 on my board is no longer an admin.

 

[Adam H]

Sorry guys wasnt sure if i should start a new thread or not , Ive got to the importing of posts and threads and got this error :

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 1591
5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580
6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381
7. XenForo_DataWriter->save() in XenForo/Model/Import.php at line 580
8. XenForo_Model_Import->_importData() in XenForo/Model/Import.php at line 1462
9. XenForo_Model_Import->importThread() in XenForo/Importer/vBulletin.php at line 2300
10. XenForo_Importer_vBulletin->stepThreads() in XenForo/Importer/Abstract.php at line 77
11. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
12. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 232
13. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
14. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 310
15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
16. XenForo_FrontController->run() in /home/bretr/public_html/forum/xf/admin.php at line 13

 

[Paul B]

What's the first part of the error, the title?

 

[Adam H]

Sorry thought id copied that too : Mysqli statement execute error : Duplicate entry '1' for key 'PRIMARY'

 

[Jake Bunce]

The error you posted above is a collision on the thread_id. It looks like you have chosen to retain imported IDs but both the source and target databases have a thread_id 1.

 

[Adam H]

1. I am definitely using the VB4 importer.

2. Ok so does that mean the test thread i made on the xen board is what is causing the problem ?

 

[Adam H]

Yes deleting that test thread worked , knew i should of done that before lol.