Skip to:
Content
Pages
Categories
Search
Top
Bottom

MySQL Query to change author after import?


  • angeljs
    Participant

    @angeljs

    I’ve just imported my SMF forum to bbPress with little trouble. However, all of my posts are now showing as being written by anonymous. Is there a simple MySQL query I can run that would change all of my topics and replies to myself instead of having to trawl through hundreds of posts to do it manually? 🙂

Viewing 1 replies (of 1 total)

  • Robin W
    Moderator

    @robin-w

    yes is the short answer, but I am lousy with sql

    if you look in wp_posts – what is author_id set to for the anonymous posts?

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.
Skip to toolbar