Support Forum
Support Forum
Offline
Somehow, half the posts I made suddenly became "guest." I know I can reassign them one at a time, but I really would rather do it all at once. There is no WP user "guest." There is no simple-press user "guest." Is there a way to simple take all those posts back under my name?
Offline
one at a time... did you delete the wp user that had made the posts? or change it some way where it would get a new user id? the only way for posts to become from guest is for the user id to go away...
if you know the exact criteria, ie the display name of all posts, you might could write a mysql query to change user id column in sfmembers table of the database...
Visit Cruise Talk Central and Mr Papa's World
Offline
Hi! I haven't deleted anything, so you can see why this is puzzling. If you know an query, I'll run it. Any ideas?
Offline
cannot be specific, but something like this:
UPDATE wp_sfposts SET user_id=XXXXX WHERE guest_name="YYYYY"
you would replace XXXXX with your user id in the wp database...
you would replace YYYYY with the display name being shown for your posts (assume this is not actually guest, but your display name)...
your wp prefix might be other than wp_ too...
be sure to make a db backup before doing this in case it goes south...
does that make sense?
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)