Trying to use a simple SQL statement to update affiliate id field, it appears to be firing when used, however the update to affiliate id is not happening.
Version info: 4.20.20.0 / 6.2.5


Debug shows this: Executing SQL Event
SQL Query: UPDATE dnn_users SET AffiliateId = 49 WHERE UserId = 1


Completion Event has this entry (LMS-ORGID is defaulted to 49 as a hidden field. This user's hidden field is correctly set to 49):

UPDATE dnn_users
SET AffiliateId = $(LMS-ORGID)
WHERE UserId = $(UserID)

What am I missing?

Thanks,
Matt

Figured it out -- going after the wrong table name. Should have been just Users not dnn_Users

Sometimes it requires a forum post to resolve your own issue.

Hope you have a great day!

-Ryan