Kunena and Joomdle Integration Issue

500 - An error has occurred. JDatabaseMySQL::query: 1062 - Duplicate entry '649-30' for key 'PRIMARY' SQL=INSERT INTO `tablename_user_usergroup_map` (`user_id`,`group_id`) VALUES ('649','30') Return to Control Panel Call stack # Function Location 1 JAdministrator->dispatch() /server_path/administrator/index.php:46 2 JComponentHelper::renderComponent() /server_path/administrator/includes/application.php:153 3 JComponentHelper::executeComponent() /server_path/libraries/joomla/application/component/helper.php:351 4 require_once() /server_path/libraries/joomla/application/component/helper.php:383 5 JController->execute() /server_path/administrator/components/com_joomdle/joomdle.php:44 6 JoomdleController->sync_to_kunena() /server_path/libraries/joomla/application/component/controller.php:761 7 JoomdleHelperForum->sync_forums() /server_path/administrator/components/com_joomdle/controller.php:690 8 JoomdleHelperForum->sync_course_forums() /server_path/administrator/components/com_joomdle/helpers/forum.php:440 9 JoomdleHelperJoomlagroups->sync_group_members() /server_path/administrator/components/com_joomdle/helpers/forum.php:450 10 JoomdleHelperJoomlagroups->add_group_member() /server_path/administrator/components/com_joomdle/helpers/joomlagroups.php:190 11 JDatabase->insertObject() /server_path/administrator/components/com_joomdle/helpers/joomlagroups.php:131 12 JDatabaseMySQL->execute() /server_path/libraries/joomla/database/database.php:841 13 JError::raiseError() /server_path/libraries/joomla/database/database/mysql.php:548 14 JError::raise() /server_path/libraries/joomla/error/error.php:251

function add_group_member ($course_id, $username, $type) { $db = JFactory::getDBO (); $user_id = JUserHelper::getUserId ($username); if (!$user_id) return; // Add to general group if needed $parent_id = JoomdleHelperJoomlagroups::get_parent_id ($type); $query = 'SELECT * ' . ' FROM #__user_usergroup_map' . " WHERE group_id = " . $db->Quote($parent_id) . " AND user_id = " . $db->Quote($user_id); $db->setQuery($query); $map = $db->loadAssocList(); if (!count ($map)) { $data->user_id = $user_id; $data->group_id = $parent_id; $db->insertObject( '#__user_usergroup_map', $data); } // Add to course group $group_id = JoomdleHelperJoomlagroups::get_course_group_id ($course_id, $type); if (!$group_id) return; $query = 'SELECT * ' . ' FROM #__user_usergroup_map' . " WHERE group_id = " . $db->Quote($group_id) . " AND user_id = " . $db->Quote($user_id); $db->setQuery($query); $map = $db->loadAssocList(); if (!count ($map)) { $data->user_id = $user_id; $data->group_id = $group_id; $db->insertObject( '#__user_usergroup_map', $data); } }