Hi,
This is strange that I've test the PHP plugin in my local site, everything was alright, but I when copied it to the server, I got this erroe message :
1110 Column 'group_id' specified twice SQL=INSERT INTO `#__user_usergroup_map` SET `user_id` = '571' , `group_id` = '26' , `user_id` = '' , `group_id` = ''
and following is my source code:
function newUser_UserGroupMap($juseid, $groupID, $db, $query){
$query->insert($db->quoteName('#__user_usergroup_map')) ->set($db->quoteName('user_id').' = ' . $db->quote($juseid)) ->set($db->quoteName('group_id').' = ' . $db->quote($groupID));
$db->setQuery($query);
$db->execute();
}
Can anyone give me a direction? Thanks
Best regards
Scott
This is strange that I've test the PHP plugin in my local site, everything was alright, but I when copied it to the server, I got this erroe message :
1110 Column 'group_id' specified twice SQL=INSERT INTO `#__user_usergroup_map` SET `user_id` = '571' , `group_id` = '26' , `user_id` = '' , `group_id` = ''
and following is my source code:
function newUser_UserGroupMap($juseid, $groupID, $db, $query){
$query->insert($db->quoteName('#__user_usergroup_map')) ->set($db->quoteName('user_id').' = ' . $db->quote($juseid)) ->set($db->quoteName('group_id').' = ' . $db->quote($groupID));
$db->setQuery($query);
$db->execute();
}
Can anyone give me a direction? Thanks
Best regards
Scott