Change author quick edit bulk works, but not in phpMyAdmin

  • This is such a strange one.

    I can change the author for multiple posts by using the Quick Edit feature on the Posts page, but something weird happens on the Activity pages.

    FYI:
    Admin – post_author ID 1 in phpMyAdmin
    Connie – post_author ID 8 in phpMyAdmin

    I switched all 196 posts from Admin to Connie using Quick Edit. It worked.

    On Connie’s Activity page, where I was expecting to see a long page of all 196 posts, it only shows 1 post.

    On Connie’s /posts it shows all 196, but one on each page even though I selected 30 posts to be visible per load. Who wants to click through 196 pages?

    On Admin’s Activity page, all 196 posts are visible on one long page, if you scroll far enough. Why? I changed them all to Connie.

    On Admin’s /posts it is empty.

    In phpMyAdmin, no matter what I do in WP with quick Edit, the wpap_posts > post_author always stays as 1 (Admin). It does not change to (8) Connie.

    Question 1 – Does anyone know of a way to bulk change the author ID using phpMyAdmin?

    Question 2 – Why is my database like this? My hosts won’t help me because it’s not what they do; they said it is a WordPress issue, but I don’t entirely believe them.

    Thanks in advance for all of your replies and suggestions ??

    • This topic was modified 3 years, 5 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic
Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter rigsbyx

    (@rigsbyx)

    PS – I forgot to mention that I found this page:

    https://webhostinghero.org/quickly-batch-change-the-author-of-wordpress-posts/

    And they advised this:

    UPDATE wp_posts SET post_author=id_new_author WHERE post_author=id_old_author;

    …but it doesn’t quite make sense to me. Where do I type “1” and “8”?

    Thread Starter rigsbyx

    (@rigsbyx)

    I found it, and it worked..!

    UPDATE wpap_posts SET post_author=’8′ WHERE post_author=’1′;

    Please note: You might have to change wpap_posts to wp_posts

    It all depends on what the posts table is called.

    Thread Starter rigsbyx

    (@rigsbyx)

    I’m back, again!

    Unfortunately, it didn’t fix the frontend issue of what happens in the Activity and /post pages. Nothing changed on that front.

    Bummer!

    The query flushed out the issue of not changing the post_author ID because whenever I now use the bulk Quick Edit method, it changes in phpMyAdmin whereas it didn’t on previous attempts.

    What to do?

    What’s this “Activity page” you mentioned?

    WordPress doesn’t have such a thing, and this is likely coming from some 3rd-party plugin you installed.

    Can you please clarify what’s giving you this “Activity Page”?

    Thread Starter rigsbyx

    (@rigsbyx)

    It’s just BuddyPress.

    But by the time I find a solution I could have rebuilt the site, and so that’s what I am going to do because then I won’t have that niggling thought in the back on my mind about something potentially being wrong.

    Going forward with a new build will save time and unwanted stress.

    Thanks ??

    It’s just BuddyPress.

    That’s still a plugin and not part of WordPress.

    If you continue to have an issue with this, please post in the BuddyPress project’s own support forum, so that the BuddyPress developers and user community can help you out:

    BuddyPress Support Forum: https://buddypress.org/support/

    Good luck with your project!

    Thread Starter rigsbyx

    (@rigsbyx)

    Thanks, George, I have already posted on there. Without WordPress there wouldn’t be any communities like these which bring people together. I was hoping that someone just might see this post on here, too ??

    Thanks, yes, I am enjoying creating this project. Good luck, too

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Change author quick edit bulk works, but not in phpMyAdmin’ is closed to new replies.