Hey,
I need to be able to add users to several usergroups when they subscribe to a specific Subscription. In order to do this, I added the following query to the SQL Actions tab:
INSERT INTO `#__user_usergroup_map` ( `user_id`, `group_id` ) VALUES ( [user_id], 14 ), ( [user_id], group_id ), ( [user_id], group_id ), ( [user_id], group_id ), ( [user_id], group_id ), ( [user_id], group_id );
When I use the joomla debug mode, the query appears in the list of queries executed (I tried it both with the ; and without it). The thing is that the user is never added to the groups but if i copy the query from the debug message and run it directly in the database, the query runs fine.
Any help is appreciated.