I have Joomla 3.8.11 and RSFORM 2.0.14.
I want to update the Community Builder fields of the logged-in user.
The main fields that I am trying to update are via some checkboxes:
The checkbox field from RSFORM has exactly the same values that the checkbox fields from Community Builder have.
I tried this method: https://www.rsjoomla.com/support/documentation/rsform-pro/custom-scripting/update-a-field-from-community-builder.html
And this method: https://www.rsjoomla.com/blog/view/314-rsformpro-user-profile-community-builder-and-mappings.html
But it doesn't work. When I go to see the profile, I don't see the fields updated and there is no error message.
Here is the code that I added in php option "Script called on form process":
$db = JFactory::getDBO();
$user = JFactory::getUser();
$db->setQuery("UPDATE njhggy_comprofiler SET cb_skills = '".$db->escape($_POST['form']['skills'])."' WHERE user_id = '".$db->escape($user->id)."'");
$db->query();
Does anyone know what I am doing wrong?