Hello! I'm doing the next query to add a resource after user registration in ABPro:
INSERT INTO jos_sv_apptpro2_resources (`id_resources`, `category_id`, `name`, `description`, `cost`, `ordering`, `resource_email`, `prevent_dupe_bookings`, `max_dupes`, `resource_admins`, `rate`, `rate_unit`, `default_calendar_category`, `default_calendar`, `allowSunday`, `allowMonday`, `allowTuesday`, `allowWednesday`, `allowThursday`, `allowFriday`, `allowSaturday`, `checked_out`, `checked_out_time`, `published`, `timeslots`, `disable_dates_before`, `disable_dates_before_days`, `min_lead_time`, `disable_dates_after`, `disable_dates_after_days`, `sms_phone`, `google_user`, `google_password`, `google_default_calendar_name`, `access`, `enable_coupons`, `max_seats`, `non_work_day_message`, `non_work_day_hide`, `paypal_account`) VALUES ('[user_id]', NULL, '[name]', '[cb_norazonsocial]', NULL, NULL, [email], 'Global', '0', '[user_id]', '0.00', 'Flat', 'General', 'Default', 'No', 'Yes', 'Yes', 'Yes', 'Yes', 'Yes', 'No', '0', NULL, '1', 'Global', 'Tomorrow', '0', '1', 'Not Set', '0', '[cb_telmovil1]', NULL, NULL, NULL, 'registered_only', 'No', '1', '', 'Yes', '');
The query run in the Trigger: onAfterUserApproval,onBeforeUserApproval
But after running the new registry isn't saved in the database and don't show any error. Can you tell me where is the error?
Thanks.