Support » Fixing WordPress » Old URL and wrong snippet in wp_postmeta

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator bcworkz

    (@bcworkz)

    Ha, my Serbian is a LOT worse than your English (which is more than good enough) 🙂

    The Better S&R plugin is a lot better at finding strings in the DB than the phpMyAdmin search tool. If you don’t qualify the phpMyAdmin search correctly, it will not return the expected results. If simply searching and replacing will fix the problem, use the plugin to make the changes and call it good.

    I suspect it’s not that easy or else you would have done so already. You need to examine the surrounding context of the example dry run search and replace to ensure you are asking phpMyAdmin to search in the right places. Minimize what you are searching for, perhaps just “aloe vera”? Just “santaclausoffice”? In the phpMyAdmin search, use the LIKE %..% operator so the above fragments match in full content.

    Once you find something, note the post_id and check the corresponding post in the posts table to verify it’s something safe to delete. You should use WP functions to delete posts though. There can be related entries in taxonomy tables that are difficult to manually remove. If you know the post ID but cannot find the entry in the list table, open any other post for editing, then substitute in the address field that post’s ID with the ID you know. Once the target post loads for editing, you can then trash it.

    Once the sources are removed from your site, Google will eventually demote the links until they no longer are used at all. There is a way to disavow links in Google Search Console if you need to hasten the link’s demise.

    Hi bcworkz
    thanks for answer and thanks for compliments 🙂

    The Better S&R plugin is a lot better at finding strings in the DB than the phpMyAdmin search tool.

    I guessed that’s the point.

    I tried all in phpmyadmin, but i don’t have any resault.

    I forget write one observation in first post. I was do one test. Actualy, i try find santaclausoffice.us with Better S&R plugin and i have 29 matches all in wp_postmeta. After that, i try replace santaclausoffice.us with MickeyMouse and Better S&R tell me all 29 was replaced in wp_postmeta. After that, i try find MickeyMouse or just Mickey or just Mouse but 0 matches. Nothing. Little strange.

    Maybe this points means something?

    I can use Better S&R for search and replace santaclausoffice.us with aloa-vera.com probably there is no problem. But, i am not sure if i try replace FOREVER LIVING SRBIJA – aloe vera proizvodi with just FOREVER LIVING SRBIJA can be there any problem?

    My question is how Better S&R actualy work. If i put FOREVER LIVING SRBIJA – aloe vera proizvodi in search box, and FOREVER LIVING SRBIJA in replace box, will in that case Better S&R will replaced exact match “FOREVER LIVING SRBIJA – aloe vera proizvodi” with exact match “FOREVER LIVING SRBIJA”?

    Actualy, is Better S&R see this match FOREVER LIVNIG SRBIJA – aloe vera proizvodi like complete phrase?

    I hope you understand me?

    Also one information. Now i must change my site name from FOREVER LIVING SRBIJA to ALOE VERA SRB.

    After changes I go to Better S&R and check next.

    – search ALOE VERA SRB – forever living proizvodi – resault 29 times in wp_postmeta

    – search FOREVER LIVING SRBIJA – aloe vera proizvodi – resault 29 times in wp_postmeta

    – search FOREVER LIVING SRBIJA – resault 37 times in wp_postmeta and 3 times in wp_options

    – search ALOE VERA SRB – resault 29 times in wp_postmeta and 3 times in wp_options

    After this i don’t understand anything. What’s happening here? Maybe some plugin in problem? Cache?

    Best option was been if i can update wp_metadata with fresh information. Something like reset – delete all from wp_postmet and write new information. I try find some instruction but nothing.

    I am starting to crazy slowly. Please help me.

    Moderator bcworkz

    (@bcworkz)

    I don’t see the results in your last post as inconsistent, but I’m not familiar with your data. What’s strange is the replacement “MickeyMouse” could not be found earlier. More on this in a bit.

    Actualy, is Better S&R see this match FOREVER LIVING SRBIJA – aloe vera proizvodi like complete phrase?

    You mean will only entire string matches will be found, that partial matches like “LIVING SRBIJA” only will not be matched? Yes, that’s right. The matches are case insensitive by default. I believe there is a checkbox to require case sensitive matches if you prefer.

    Disclaimer — my experience is in using the plugin’s underlying search engine from interconnect/it. While that experience is extensive, I’ve hardly used the plugin at all. FWICT the only difference is the UI, functionality is identical.

    i am not sure if i try replace FOREVER LIVING SRBIJA – aloe vera proizvodi with just FOREVER LIVING SRBIJA can be there any problem?

    Probably not, but I’m not sure why it is in post meta in the first place. Custom field perhaps?

    i try find MickeyMouse or just Mickey or just Mouse but 0 matches.

    Now that’s odd. It seems like the DB user used does not have edit capabilities, but that can’t be right because it’s the same user as what WP uses. It could be a caching artifact, but surely it would have been regenerated by now. It’s not productive to do searches if replacements are ineffective.

    Thanks for answer. I try write in Astra theme and Beaver Builder support maybe somebody have same problem.

    Thanks for help.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.