[TH] vBulletin Social Groups Importer [Deleted]

[Dok]

I have this error too, with ver. 1.0.0b
(Duplicate entry '22841-1' for key 'user_id_social_forum_id')

XF = Fresh install
ScouceDB = VB 3.8

I have in my testinstall import only userdata. (Step 1-3)

 

[DivokyMuz]

@Waindigo Just tried a new import in a complete new installation of 1.30beta and got an error.

Server Error

Mysqli statement execute error : Duplicate entry '42' for key 'PRIMARY'

    Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
    Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
    Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
    Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1612
    XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
    XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
    XenForo_DataWriter->save() in XenForo/Model/Import.php at line 599
    XenForo_Model_Import->_importData() in Waindigo/VbToSocGrp/Extend/XenForo/Model/Import.php at line 89
    Waindigo_VbToSocGrp_Extend_XenForo_Model_Import->importSocialForumThread() in Waindigo/VbToSocGrp/Extend/XenForo/Importer/vBulletin.php at line 322
    Waindigo_VbToSocGrp_Extend_XenForo_Importer_vBulletin->stepSocialGroupThreads() in XenForo/Importer/Abstract.php at line 97
    XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
    XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 239
    XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 182
    XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 347
    XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
    XenForo_FrontController->run() in /var/www/web1/html/xenforo130b/admin.php at line 13

 

[Alpha1]

Jon, I paid for the creation of this addon in October last year and it was supposed to be delivered a few weeks later. Its 5 months later now and this addon still does not work. Conversations stay unanswered.

I know you are very busy, but could you please reply to bug reports and complete this addon?

 

[Jon W]

Waindigo updated vBulletin Social Groups Importer by Waindigo with a new update entry:

Version 1.0.0c released

Bug fixes:

• Fixes some duplicate ID errors if "retain keys" options is selected.

Read the rest of this update entry...

 

[Alpha1]

Thank you!

 

[Alpha1]

Server Error
Mysqli statement execute error : Duplicate entry '3423-6' for key 'user_id_social_forum_id'

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 1624
5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
7. XenForo_DataWriter->save() in Waindigo/VbToSocGrp/Extend/XenForo/Model/Import.php at line 165
8. Waindigo_VbToSocGrp_Extend_XenForo_Model_Import->importSocialForumMember() in Waindigo/VbToSocGrp/Extend/XenForo/Importer/vBulletin.php at line 180
9. Waindigo_VbToSocGrp_Extend_XenForo_Importer_vBulletin->stepSocialGroups() in XenForo/Importer/Abstract.php at line 97
10. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
11. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 239
12. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 182
13. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 347
14. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
15. XenForo_FrontController->run() in /admin.php at line 13

I disabled all other addons, so it does not seem to be any conflict.

 

[Jon W]

Have you tried uninstalling and re-installing the Social Groups add-on before importing? It looks like you might have a partially completed import that is stopping it from completing.

 

[Alpha1]

I have now tried uninstalling and re-installing the Social Groups add-on before importing. Unfortunately I received this error:

Mysqli statement execute error : Duplicate entry '3423-1' for key 'user_id_social_forum_id'

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 1624
5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1613
6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1405
7. XenForo_DataWriter->save() in Waindigo/VbToSocGrp/Extend/XenForo/Model/Import.php at line 165
8. Waindigo_VbToSocGrp_Extend_XenForo_Model_Import->importSocialForumMember() in Waindigo/VbToSocGrp/Extend/XenForo/Importer/vBulletin.php at line 180
9. Waindigo_VbToSocGrp_Extend_XenForo_Importer_vBulletin->stepSocialGroups() in XenForo/Importer/Abstract.php at line 97
10. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
11. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 239
12. XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 182
13. XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 347
14. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
15. XenForo_FrontController->run() in /admin.php at line 13

 

[Jon W]

Think this is a bug with the Social Groups add-on. I have updated here:
http://xenforo.com/community/resources/social-groups-by-waindigo.891/update?update=8832

 

[Alpha1]

Indeed. Its importing now. Until I run into this error:

Server Error
Mysqli statement execute error : BIGINT UNSIGNED value is out of range in '(`databaseuser_dbname`.`social_forum`.`member_count` - 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 Waindigo/SocialGroups/DataWriter/SocialForumMember.php at line 199
4. Waindigo_SocialGroups_DataWriter_SocialForumMember->_postSave() in XenForo/DataWriter.php at line 1409
5. XenForo_DataWriter->save() in Waindigo/VbToSocGrp/Extend/XenForo/Model/Import.php at line 165
6. Waindigo_VbToSocGrp_Extend_XenForo_Model_Import->importSocialForumMember() in Waindigo/VbToSocGrp/Extend/XenForo/Importer/vBulletin.php at line 180
7. Waindigo_VbToSocGrp_Extend_XenForo_Importer_vBulletin->stepSocialGroups() in XenForo/Importer/Abstract.php at line 97
8. XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 187
9. XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 135
10. XenForo_ControllerAdmin_Import->actionImport() in Waindigo/ImportTools/Extend/XenForo/ControllerAdmin/Import.php at line 16
11. Waindigo_ImportTools_Extend_XenForo_ControllerAdmin_Import->actionImport() in XenForo/FrontController.php at line 347
12. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
13. XenForo_FrontController->run() in /admin.php at line 13

 

[Jon W]

Try rebuilding the social forum cache:
Admin CP -> Tools -> Rebuild Caches -> Rebuild Social Forums

 

[Alpha1]

After rebuilding the social forum cache, I tried importing again but immediately when I enter 'continue import' I get the same error.

 

[Jon W]

I have made another update to Social Groups that should hopefully stop this error:
http://xenforo.com/community/resources/social-groups-by-waindigo.891/update?update=8835

 

[Alpha1]

Fatal error: Call to undefined method XfAddOns_Blogs_Override_Model_Import::mapSocialGroupDiscussionId() in /library/Waindigo/VbToSocGrp/Extend/XenForo/Importer/vBulletin.php on line 279

Error Info
ErrorException: Fatal Error: Call to undefined method XfAddOns_Blogs_Override_Model_Import::mapSocialGroupDiscussionId() - library/Waindigo/VbToSocGrp/Extend/XenForo/Importer/vBulletin.php:279
Generated By: alfa, 9 minutes ago
Stack Trace

#0 [internal function]: XenForo_Application::handleFatalError()
#1 {main}

Request State

array(3) {
["url"] => string(57) "/admin.php?import/import"
["_GET"] => array(1) {
["import/import"] => string(0) ""
}
["_POST"] => array(1) {
["_xfToken"] => string(8) "********"
}
}

 

[Jon W]

Waindigo updated vBulletin Social Groups Importer by Waindigo with a new update entry:

Version 1.0.0d released

Bug fixes:

• Fixes "Call to undefined method mapSocialGroupDiscussionId()" bug.

Read the rest of this update entry...

 

[Alpha1]

The importer has run fine now. But the social forums do not show up anywhere. Except on profile. All groups are listed to have no discussions. The links from profile lead to an error:
Error
The requested forum could not be found.

 

[Jon W]

Try rebuilding the forum and social forum caches again. Make sure you have set up permissions correctly.

 

[Alpha1]

The groups are now listed as having discussions, but other than that, they can still not be found.
They do not show up in the node list either.
If I import again, then will it use the same IDs or will it duplicate content?

 

[Jon W]

The groups are now listed as having discussions, but other than that, they can still not be found.
They do not show up in the node list either.
If I import again, then will it use the same IDs or will it duplicate content?

Check the node list in the ACP. Can you see any social categories in there?

Importing again will duplicate content. If you uninstall and re-install Social Groups, you should then be able to import again.

 

[Alpha1]

There are no social categories in the node list in admincp.