Support » Fixing WordPress » Changing a previous post author, and/or press release. Database.

  • Hello,
    I have all these previous posts in a press release section. I would like to change the name of the contact person GLOBALLY (for all posts). Sometimes this is an option in WP Dashboard, however, in my case it is not. I believe it is pulling from a database (which I can log on to), but, wouldn’t have a clue how to find it.
    How would I go about finding where this information, and/or change this field?
    Here is an example:

    [Press Contact]

    Test Devices, Inc. introduces optical strain measurement service

    Thank you.

Viewing 12 replies - 1 through 12 (of 12 total)
  • Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    Given that the contact info is on the sidebar, it’s likely that it comes from a single widget. Check Appearances->Widget. If no, and it’s not a theme option, try this:

    Install the plugin “better search and replace”. Search for the old info and replace with the new info. (Be sure to backup your database before using it!)

    Sterndata, thanks for the suggestion.
    Wasn’t in the widget section, so no there.
    I installed the plug-in, but don’t have a clue what I’m looking at when I go into edit the php files. Seems like it would be easier to find this within the database.
    There’s 17 php files that the plug-in loads.
    Any other input or ideas? Thank you.

    Anybody have any suggestions on how to log into the database and swap the content?

    [Moderator note: Please, no bumping.]

    Moderator Steve Stern

    (@sterndata)

    Support Team Volunteer

    Edit the PHP files?

    I asked you to install Better Search and Replace. IIRC, it adds a menu item on the TOOLS menu. Use it to search and replace in the DB.

    Steve,
    Thanks again for responding. The search wasn’t able to find the data.
    I got this:

    DRY RUN: 28 tables were searched, 0 cells were found that need to be updated, and 0 changes were made.

    Thanks again for your input and suggestion.
    I was able to use the tool, just no luck.

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    What did you try searching?

    Taking a look over is shows that the section has an ID of side-menu. I’m guessing this is a custom-built theme? If so, try reaching out to the author for how that section was created.

    Jose,
    I tried searching: Tracie, Tracie Butler-Kurth, Kurth etc.
    Because THAT is the information I’m trying to change/swap-out. Yes, this is a custom built theme modified from the previous owner(s)(which can’t be reached). How the <aside id="side-menu"> is collected…. when the “POST” is created, there is an input section where you can put: author, contact etc. Test Devices doesn’t want the Tracie person to be listed anymore. They would like to swap it out with another contact person, ‘sigh’.
    Any other suggestions? Thank you.

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    This actually does shed a little more light on this. 🙂

    when the “POST” is created, there is an input section where you can put: author, contact etc

    I’m guessing it is using post meta. Are you able to go to the post and edit that directly? Or that what you would like to avoid as it does sound a bit time consuming. One way I can think of would be using phpMyAdmin’s ability to search and replace rather than relying on a plugin. I had to do that for my wife’s work site a few weeks back because the plugins just were not working for me.

    I’m guessing it is using post meta. Are you able to go to the post and edit that directly? Or that what you would like to avoid as it does sound a bit time consuming. One way I can think of would be using phpMyAdmin

    So YES, I’m able to get into the phpMyAdmin, but again.. I have NO IDEA what I’m looking at.
    Screenshot

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    Wow, super sorry about not getting back to this!

    If you still need help with this, what you can do is go to the tables. It may look something like:

    Phpmyadmin tables

    Odds are you may have to select from the dropdown and make sure it is the right one. You’ll want to go to the wp_postmeta or however your table is setup. It will be {prefix}meta or along those lines.

    Once you are there, you can go to the Search tab:

    Search replace

    You’ll go to Find and replace where you will choose to replace meta_value:

    Meta value

    From there you can replace all similar values without having to edit posts individually.

    Hope that helps you out!

    No, I’m really close.. (meaning in the right spot)
    Here’s what I’m seeing:
    mysql window

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Changing a previous post author, and/or press release. Database.’ is closed to new replies.