Bug Error on import

Bijou

Bijou

Customer
Any help would be appreciated! :) the groups have been made and they seem to have all their members but all are giving me the error that they're private and are lacking any messages in theri respective discussion areas
  • XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '4741-0' for key 'xf_dbtech_social_groups_group_member.user_id_group_id'
  • src/XF/Db/AbstractStatement.php:230
  • Jun 2, 2024 at 2:18 PM

Stack trace​

INSERT INTO xf_dbtech_social_groups_group_member (group_member_id, user_id, group_id, join_date, is_supervisor, member_state, album_count, permissions, reason) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Import/Data/EntityEmulator.php(329): XF\Db\AbstractAdapter->insert('xf_dbtech_socia...', Array)
#5 src/XF/Import/Data/AbstractEmulatedData.php(71): XF\Import\Data\EntityEmulator->insert(1050, Object(XF\Db\Mysqli\Adapter))
#6 src/XF/Import/Data/AbstractData.php(129): XF\Import\Data\AbstractEmulatedData->write(1050)
#7 src/addons/DBTech/SocialGroups/Import/Importer/NobitaSocialGroups.php(747): XF\Import\Data\AbstractData->save(1050)
#8 src/XF/Import/Runner.php(244): DBTech\SocialGroups\Import\Importer\NobitaSocialGroups->stepGroupMembers(Object(XF\Import\StepState), Array, 8)
#9 src/XF/Import/Runner.php(61): XF\Import\Runner->runStep('groupMembers', Object(XF\Import\StepState), 8)
#10 src/XF/Admin/Controller/Import.php(234): XF\Import\Runner->run()
#11 src/XF/Mvc/Dispatcher.php(352): XF\Admin\Controller\Import->actionRun(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Import), NULL)
#13 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Import), NULL)
#14 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#16 src/XF.php(524): XF\App->run()
#17 admin.php(13): XF::runApp('XF\\Admin\\App')
#18 {main}

Request state​

array(4) {
["url"] => string(21) "/admin.php?import/run"
["referrer"] => string(43) "/admin.php?import/run"
["_GET"] => array(1) {
["import/run"] => string(0) ""
}
["_POST"] => array(1) {
["_xfToken"] => string(8) "********"
}
}
 

Attachments

  • 1717363358572.webp
    1717363358572.webp
    123.6 KB · Views: 1
the former error only occurs when importing Members, and then the following error is hitting me when I import attachments:

RuntimeException: Unable to copy file /internal_data/attachments/269/269719-f9020c30a7655e9a2cdfb751f3ddd986.data to internal-data://attachments/677/677497-f9020c30a7655e9a2cdfb751f3ddd986.data in src/XF/Util/File.php at line 217
  1. XF\Util\File::copyFileToAbstractedPath() in src/XF/Service/Attachment/Preparer.php at line 78
  2. XF\Service\Attachment\Preparer->insertDataFromFile() in src/XF/Import/Data/Attachment.php at line 87
  3. XF\Import\Data\Attachment->write() in src/XF/Import/Data/AbstractData.php at line 129
  4. XF\Import\Data\AbstractData->save() in src/addons/DBTech/SocialGroups/Import/Importer/NobitaSocialGroups.php at line 1551
  5. DBTech\SocialGroups\Import\Importer\NobitaSocialGroups->stepMessageAttachments() in src/XF/Import/Runner.php at line 244
  6. XF\Import\Runner->runStep() in src/XF/Import/Runner.php at line 61
  7. XF\Import\Runner->run() in src/XF/Admin/Controller/Import.php at line 234
  8. XF\Admin\Controller\Import->actionRun() in src/XF/Mvc/Dispatcher.php at line 352
  9. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
  10. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
  11. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
  12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
  13. XF\App->run() in src/XF.php at line 524
  14. XF::runApp() in admin.php at line 13

okay I'm just dumb and ended up importing the attachments like 5 times which ended up overloading my disc storage space so this error is irrelevant sorry
 
Last edited:
Bijou said:
Any help would be appreciated! :) the groups have been made and they seem to have all their members but all are giving me the error that they're private and are lacking any messages in theri respective discussion areas
  • XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry '4741-0' for key 'xf_dbtech_social_groups_group_member.user_id_group_id'
  • src/XF/Db/AbstractStatement.php:230
  • Jun 2, 2024 at 2:18 PM

Stack trace​

INSERT INTO xf_dbtech_social_groups_group_member (group_member_id, user_id, group_id, join_date, is_supervisor, member_state, album_count, permissions, reason) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1062, '23000')
#1 src/XF/Db/Mysqli/Statement.php(79): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1062, '23000')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(220): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#4 src/XF/Import/Data/EntityEmulator.php(329): XF\Db\AbstractAdapter->insert('xf_dbtech_socia...', Array)
#5 src/XF/Import/Data/AbstractEmulatedData.php(71): XF\Import\Data\EntityEmulator->insert(1050, Object(XF\Db\Mysqli\Adapter))
#6 src/XF/Import/Data/AbstractData.php(129): XF\Import\Data\AbstractEmulatedData->write(1050)
#7 src/addons/DBTech/SocialGroups/Import/Importer/NobitaSocialGroups.php(747): XF\Import\Data\AbstractData->save(1050)
#8 src/XF/Import/Runner.php(244): DBTech\SocialGroups\Import\Importer\NobitaSocialGroups->stepGroupMembers(Object(XF\Import\StepState), Array, 8)
#9 src/XF/Import/Runner.php(61): XF\Import\Runner->runStep('groupMembers', Object(XF\Import\StepState), 8)
#10 src/XF/Admin/Controller/Import.php(234): XF\Import\Runner->run()
#11 src/XF/Mvc/Dispatcher.php(352): XF\Admin\Controller\Import->actionRun(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('XF:Import', 'Run', Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Import), NULL)
#13 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XF\Admin\Controller\Import), NULL)
#14 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#15 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#16 src/XF.php(524): XF\App->run()
#17 admin.php(13): XF::runApp('XF\\Admin\\App')
#18 {main}

Request state​

array(4) {
["url"] => string(21) "/admin.php?import/run"
["referrer"] => string(43) "/admin.php?import/run"
["_GET"] => array(1) {
["import/run"] => string(0) ""
}
["_POST"] => array(1) {
["_xfToken"] => string(8) "********"
}
}
Click to expand...
If you look in xf_tl_group_member, do you have any entries that has 0 for its group_id column? I think that may be the problem here.
 
I ended up skipping that and asking everyone to rejoin the groups they prefer!
Fillip H. said:
If you look in xf_tl_group_member, do you have any entries that has 0 for its group_id column? I think that may be the problem here.
Click to expand...

however on trying to edit messages my users and I are getting this error

Error: Typed property DBTech\SocialGroups\Service\Message\Editor::$oldMessage must not be accessed before initialization in src/addons/DBTech/SocialGroups/Service/Message/Editor.php at line 245
  1. DBTech\SocialGroups\Service\Message\Editor->_save() in src/XF/Service/ValidateAndSavableTrait.php at line 42
  2. DBTech\SocialGroups\Service\Message\Editor->save() in src/addons/DBTech/SocialGroups/Pub/Controller/Message.php at line 159
  3. DBTech\SocialGroups\Pub\Controller\Message->actionEdit() in src/XF/Mvc/Dispatcher.php at line 352
  4. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
  5. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
  6. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
  7. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
  8. XF\App->run() in src/XF.php at line 524
  9. XF::runApp() in index.php at line 20
 
I’ll look into that as soon as I can and hotfix it, I’ll post back when a fix is available :)
 
Update: I've applied a hotfix to v1.3.0, if you re-download it and re-import the zip file this should now be resolved :)
 
Hello @Bijou,

We hope your ticket regarding DragonByte Social Groups has been addressed to your satisfaction. This ticket has now been scheduled to be closed.

If your ticket has not been resolved, you can reply to this thread at any point in the next 7 days in order to reopen the ticket, afterwards this thread will be closed.

Please do not reply to this thread if your ticket has been resolved.

Thank you.


- DragonByte Technologies, Ltd.
 
You must log in or register to reply here.

Similar threads

J
  • Support ticket Support ticket
Question Import Error
Replies
6
Views
90
DragonByte Technologies
DragonByte Technologies
R
  • Support ticket Support ticket
Bug First post is missing after import from OzzModz
Replies
16
Views
183
DragonByte Technologies
DragonByte Technologies
McAvoy77
  • Support ticket Support ticket
Bug Social Groups Server Error: Cannot delete a non-saved entity
Replies
10
Views
145
DragonByte Technologies
DragonByte Technologies
S
  • Support ticket Support ticket
Bug Server error joining group
Replies
8
Views
209
DragonByte Technologies
DragonByte Technologies
S
  • Support ticket Support ticket
Bug New server error
Replies
5
Views
182
DragonByte Technologies
DragonByte Technologies

DragonByte Social Groups

XenForo 2.2.x XenForo 2.3.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
222
Customer rating
0.00 star(s) 0 ratings
Back
Top