the only way for a post to be reassigned to a guest is if the wp user is deleted…  remember, all users are wp users not forum users…

as to the reassign, what are you entering for new user?  it should be the user id (a number)…  and assume you running 5.3.1?

I appreciate the prompt reply, thanks for your assistance.

I am using SP 5.3.1

My bad, I was using the user name, it allowed me to reassign via user id.
Should have read the sign.

Can you think of why this happened? The users weren’t deleted as I am still qualakon with the same user id and can post with new posts going to my name. I’m just curious so I can prevent it from happening to other users. So far it’s hit three different members.

well, as I said, we dont have a facility for changing them like that short of deleting the user…

for a post in question, what is the user id of the poster (look in sfposts table – you can get the post id via the forum tools properties)?  does that user id match the user id of the poster in sfmembers table?

guess you could also make sure the the users match up in wp users table vs sfmembers table…  you didnt import users or anything did you?

Well I’m not too sure how it happened, but I was able to change all the NULL posts back to the appropriate user id. It only happened to some posts, not all. And only to three users, Admin, Mod and a prominent user.

It simply converted the post to a Guest post, copied the appropriate data back into Guest name and email so it was easy to fix. Hard to say what caused it though.

Regardless I appreciate the support. Thanks for that.

glad you are back where you want.  please let us know if you see it happen again…

I changed the admin for security reasons and I deleted the admin before I reassigned the forum postings. Now the admin is a guest but doesn’t show the forum posts associated with it to reassign them. There are over 3000 to change the user id on and doing this one by one with phpmyadmin will take forever. Are there any solutions to make this go quicker?

Thanks

Deleting an active admin account is a really bad idea…. if you can select all of the posts that were once the this users and are now classed as guests then you can perform a single update query to change the user_id for all of them in one go.  As long as you have suitable criteria to select them in the first place.

@yellow-swordfish 

Thank you for your reply.

Yes I can get them all to come up. They are the only ones in the user id column to have a null value. But I don’t know how to write the update sql and replace with new text id number in phpmyadmin.

BTW I have done this manually for about 500 so far. Very tedious and time consuming work. I have noticed though that the number of posts under my new profile isn’t changing at all when I change to my new profile id through sql. Any help and suggestions would be GREATLY appreciated.

If the value in the column is truly NULL then you can use a query such as:

UPDATE wp_sfposts SET user_id = XXX WHERE user_id IS NULL AND guest_name='';

Note:

1. If your table prefix is NOT the default ‘wp_’ then change the table name accordingly.
2. Replace XXX with your user ID.
3. I have added the check for an empty guest_name in case any previous guest posts exist as they too have a user_id of NULL. Note these are two single quotes at the end NOT one double quote.

Assuming this is successful then when run go to the forum admin > toolbox > housekeeping and run the task to clean up the post counts.

Before doing the above make a BACKUP of your database!

@yellow-swordfish 

You are da man!! As always I might add. Someday I will buy you a beer or coffee or something. Thank you SO much for your help and support. You saved me a lot of time.

I have one more quick question. My new profile shows member since and the new date. Is there a way to change this date to reflect the date that the old one had? That way it corresponds to all the older postings from years back that are now under this new profile. BTW I am using WishList Member on my site.

That ls the date the user was registered. It is held in the WordPress ‘Users’ table and can be manually edited with care.