I'm running a multi-site installation of 4.6.9 with shared users.
I thought it was running smoothly, until today when I discovered a problem with my current set-up. Basically, users who've created an account on one site have had a NULL .rid value inserted in the users_roles table on the other sites.
Note that this isn't a bug in Drupal ... I know exactly what I did wrong in the set-up ... it was my fault ... I'll admit it.
Anyway, my question is, how can I do a mass update of users_roles.rid using MySQL?
What I'd like to do is search each users.uid to see if the corresponding users_roles.rid is NULL. If it is, I want to change it to "2" (Authenticated User).
My SQL skills are limited. I've been able to do a SELECT FROM that properly pulls out all the NULL users, but as for changing the values? I'm lost.
Any help would be appreciated.