TOPIC: Need to change Values of active Custom Field

Hello Nathan and all!

We are using three dropdown custom fields to be able to register which sessions on an event a registrant wants to attend.

Now, a few sessions need to change time and day. So, for instance "Sat 09:30 Risk Management|Sat 09:30 Advanced rescues|..." would need to change into "Sun 09:30 Risk Management|Sat 09:30 Advanced Rescues|... ".

The problem is, doing this would zero the count of persons who have registered to the first session. Would replacing (in the SQL database) all "Sat 09:30 Risk Management" to "Sun 09:30 Risk Management" work? Which tables are in use for the operation; only dtregister_user and dtregister_fields ?

Regards, Ben

Yes, if you change the values, you will need to update the database directly. Update these tables:
jos_dtregister_user
jos_dtregister_group_member

Replace any occurrence of the old value with the new value.