I wouldn’t like to guess why one user went AWOL but was probably unable to resolve for some reason.
Yes – you should be able to do what you want to do in the way you describe.

Hi Andy,

we emailed each other in August regarding importing from SMF in forum that has accented characters, do you remember?

I have seen that those user that has not been imported, have an accented letter in their profile, not in username but in real name, so may be…

You kindly fixed importing of posts with accented chars but may be this was hidden. Or may be there is another reason, impossible to investigate now and useless, too.

So, if that procedure is possible, as I’m not so skilled in MySql, may be, if and when you have time and want, could you kindly arrange a query for me? Would be greatly appreciated but of course this is something out of normal assistance, so I can only ask.

Or, at least, could you advice me which fields in which table have to change, to avoid mess?

Thanks in advance

Marco

The first question is can you identify this users posts? You may be able to do this with the guest_name column. We need to know we are only going to operate on this single users records so can you look in the sfposts table to determine if this is possible? Another column that may be unique is the ip address…

Yes, the value that have to find out is name in guest_name, basically I need a routine that finds all guest_name that fits with a string (lets say “Joshua”) and after fill the user_id field (unchecking null)  or whatever else need, with another given string (the new ID number).

Is it possible?

UPDATE wp_sfposts SET user_id = X, guest_name = '' WHERE guest_name='name';

Where X is the new User ID you want to assign and ‘name’ is the guest name you want to reassign to the new user ID.

Note also that I have set the table prefix to the default ‘wp_’ and yours may be different.

Thanks a lot, Andy

it worked well, I also modified this query to delete the guest_email and after worked on _sfposts I changed manually the post counter in users table, so now all posts seems correctly assigned to the right owner.

Really many thanks, guys, you are a great resource.

Marco

thanks for the kind words…  glad its resolved…