Changing a User’s Email Address

You can change a user’s email address. Email addresses are created when a user registers as a Developer Portal user from the self registration interface. Using the User Manager interface in the Joomla back-end, you can change a user’s email address as needed.

Procedure 

1.

In the Joomla Administrator, go to Users > User Manager.

2.

Locate the record for the user whose email you wish to change, and note the user’s ID. For example, for the Host Administrator, this ID is 129.

3.

Click on the user's name to go to the Edit page for their Joomla user record.

4.

Update the user’s email address and click Save. If the user’s user name is an email address, change it to the new email address at this time.

5.

In the MySQL database, locate the record ID for this user by using the following query:

SELECT `record_id` FROM `openapi_js_res_record_values` WHERE `field_id`=77 AND `field_value`=<ID_FROM_STEP_2>

where <ID_FROM_STEP_2> is the ID of the Joomla user record identified in Step 2.

For the Host Administrator, this should return 219 as the record_id.

6.

Locate the actual record for the user profile with the following query:

SELECT `fields` FROM `openapi_js_res_record` WHERE `id`=<ID_FROM_STEP_4>

where <ID_FROM_STEP_4> is the record_id returned as the result of the query in step 4.

This returns JSON code that looks similar to the following code:

{"77":"129","88":["Manager"],"113":null,"101":"admin","102":"admin@local.host","121":{"country":"1","region":"650","tel":"8461000","ext":""},"45":"Host","46":"SuperAdmin","47":"68","50":["68"]}

7.

Change the value of field '102' in the JSON code from its current email address to the new email address.

8.

Locate the record for the email address of the user profile with the following query:

SELECT * FROM `openapi_js_res_record_values` WHERE `field_id`=102 AND `record_id`=<ID_FROM_STEP_4>

where <ID_FROM_STEP_4> is the result of the query in Step 4.

9.

Change that record's 'field_value' column from the old email address to the new email address.

10.

Locate the record for the user name of the user profile with the following query:

SELECT * FROM `openapi_js_res_record_values` WHERE `field_id`=101 AND `record_id`=<ID_FROM_STEP_4>

where <ID_FROM_STEP_4> is the result of the query in step 4.

11.

If the 'field_value' for this record is an email address, change the 'field_value' from the old email address to the new email address.