Support Forum
Support Forum
Offline
Hey there,
I have a member account that I need to recreate (problems with the current wordpress account syncing properly to our membership plugin), and that would mean that the user's forum posts are deleted.
When a user is deleted in Wordpress, there's the option to attribute their posts to another user account. Does this apply to Simple-Press posts as well as the default wordpress posts/pages?
Offline
No, not yet... but it will in the next version... Currently, the only option is for posts to get assigned to a guest user with the same name as the original user/poster... but when SP 5.5.2 releases (late October), you will be able to delete them, have them assigned to guest or have them reassigned to a new user...
Visit Cruise Talk Central and Mr Papa's World
Offline
Okay, cool. Thanks for the reply.
If I'm not able to wait until late October to take advantage of the new feature, is there any other way to reassign all posts from one user to another? I know this is possible on an individual post basis already...
Offline
Two ways, I guess... one as you say post by post... or if you are going to reassign them all to same user, you might could do it from the db via mysql script... would have to think on latter to make sure everything gets updated right - might be a couple gotchas...
Visit Cruise Talk Central and Mr Papa's World
Offline
I figured it might be an SQL query. They'll all be reassigned to the same user, which will make it a bit simpler. She has 1,113 posts though, which is less simple (i.e. no first option)
Offline
yeah... changing the user id of the post is very straight forward in db query... problem is that if the user started a topic, then you also have to change user id in the topic... and after one or both, you have to reset the forum indexes...
Visit Cruise Talk Central and Mr Papa's World
Offline
So...
Step 1 is to change the user ID column in the posts table from X to Y?
Step 2 is change the user ID in topic table from X to Y?
Step 3 is reset forum indexes?
I'm not the most savvy with mysql queries (and wouldn't want to butcher the site or its hundred thousand other posts) - do you know what those specific queries would be (assuming my table prefix is wp_)?
Offline
I will take a look shortly to see if I can find out, but I don't have much experience with the database, so we may have to wait for Mr Papa when he is free later on.
Offline
afraid no time this morning, but can see about some example queries this evening when home from work..
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)