Not Finding Value in wp_postmeta Table

  • Resolved itsgotime

    (@itsgotime)


    1 year, 11 months ago

    For some reason, the plugin no longer finds the Unix time stamp in the post_meta table even when I go directly into the database and the value I am searching for is there. The meta value is numerical – 1767225600.

    What I don’t understand is, this same search and replace was working back in December, I believe that was before the latest update if I am correct?
    I am running version 1.4.2 of the plugin with WordPress 6.1.1 and PHP 7.4. I get now errors, it simply displays no results in a “dry run”.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter itsgotime

    (@itsgotime)

    P.S. I rolled the version back to 1.4.1 and tried the same search and replace with the same issue, a meta value in the correct table is not found when running the plugin despite it being there if I go directly into the table.

    Plugin Support Delicious Brains Support

    (@dbisupport)

    Hi @itsgotime ,

    Better Search Replace Support Team here. I tried replicating this issue on my local site by creating a custom postmeta record with meta_value 1767225600, then running a Search/Replace. However, I was not able to replicate the issue. BSR was able to find the Unix timestamp.

    See screen recording: https://share.getcloudapp.com/z8uGrp1X

    Not sure yet why BSR wasn’t able to find it on your postmeta table. Could you ensure that the search and replace parameters are different? When I accidentally run a search/replace with the same parameters, I got the message “DRY RUN: 1 tables were searched, 0 cells were found that need to be updated, and 0 changes were made.”

    Also, is the timestamp inside some serialized data? Maybe it only looks like that the values is 1767225600 but maybe there’s some hidden characters saved in the database.

    It’s also possible that there’s a plugin conflict. I would recommend temporarily switching your theme to a default WordPress theme like Twenty Twenty, or deactivating all your other plugins until the issue goes away.

    Let us know if you have any other questions.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Not Finding Value in wp_postmeta Table’ is closed to new replies.