Another Gotcha! Permissions and a SQL Solution

I’ve just realised that there is a consequence to the loss of Author (where blank = Anonymous) in the online D6 site when it is upgraded. Anonymous users can at the least change the outline configuration. I need to ‘craft’ some SQL code to ‘inject a user’ into the blank fields in the database.

So looked in W3Schools and will try this on the live database.

UPDATE node_revisions
SET uid=175
WHERE uid=0;

This has set the uid field to 175 when it is 0, which is the anonymous uid and 175 is the uid of a new user account I have set up for this exercise. But that didn’t work, so tried it again using:

UPDATE node
SET uid=175
WHERE uid=0;

And now if the node / revision isn’t set to me or Lynne it is now set to C-N-U, which means that it isn’t Anonymous and therefore editable by anonymous users after the upgrade.