Viewing 11 posts - 1 through 11 (of 11 total)
  • Author
    Posts
  • January 17, 2019 at 10:06 pm #1055195
    fulanoinc

    Hi all,

    I’m running some database find and replace functions to update a name throughout an entire cloned Enfold website. After it processes, I check the Enfold pages and I still see the content display the same name I just replaced in the database. I emptied the cache on all fronts and it’s still the same.

    Please let me know if I’m looking in the wrong place.

    Thanks,
    Leyden

    January 18, 2019 at 10:27 pm #1055688
    fulanoinc

    Hi there,

    If anyone has an idea of how the Avia Theme Builder pages are stored and if they are a part of the database it would be appreciated. As I explained, I’m trying to find and replace one business name in the database for another.

    Thanks!

    January 19, 2019 at 10:32 am #1055824
    Rikard

    Hi,

    So you are trying to change something in the theme options pages? If so then what exactly are you looking to change?

    Best regards,
    Rikard

    January 19, 2019 at 5:49 pm #1055914
    fulanoinc

    Hi there,

    No. I do not want to make a change in the options pages.

    I just cloned a website. The content in all the pages is published using the Avia Page Builder. I want to change the business name all over the content to the new business name. I did a database SEARCH AND REPLACE to change the name anywhere it was used with the new one. After it was done, I check the content, and the name was not changed anywhere.

    Does the Avia Page Builder store content in the database?

    Thanks.

    January 19, 2019 at 5:53 pm #1055916
    fulanoinc

    I just conducted a dry run to scan the database for the old name, it does not appear anywhere—zero. But when I check the pages, the name is still there. So this tells me the content in the Avia built pages is not on the database. Where is this content stored?

    January 19, 2019 at 6:14 pm #1055922
    cg

    The WordPress Contents are stored in the Database with Enfold as the theme like with every other theme for WordPress.
    (with Enfold as the theme including the shortcodes for the Avia-Layout)

    But you have to consider that WordPress saves some contents as serialized data … a simple ‘search&replace’ with MySQL maybe won’t catch those contents or — even worse — corrupts the serialized entries.

    An option can be to use a ‘Search&Replace’-Plugin for WordPress Database Entries, for example “Better Search Replace”.

    Info: https://wpengine.com/de/support/wordpress-serialized-data/
    Plugin: https://de.wordpress.org/plugins/better-search-replace/

    • This reply was modified 5 years, 11 months ago by cg. Reason: Added link to the mentioned Wordpress Plugin
    January 19, 2019 at 6:18 pm #1055925
    fulanoinc

    That’s the plugin I’m using. I used Better Search and Replace to make the changes. Now I’m having to go through and manually change the names.

    January 19, 2019 at 6:37 pm #1055932
    cg

    That’s really odd … i can only assume, that you change the content in a different database than the frontend uses … or some mistake with a configuration option in your search&repleace-process … for example excluding the posts-table of the database by mistake or something similar …

    It “should” work … and worked for me before that way …
    Enfold can’t be the reason for this at least …

    To check the database in your case i would additionally use PHPMyAdmin to search inside the content entries.

    Edit: Are you sure you selected the correct database tables in the Better-Search-Replace-Options? You have to manually select them.
    For changing content entries it is the table “wp_posts” you have to select.

    • This reply was modified 5 years, 11 months ago by cg.
    January 19, 2019 at 7:28 pm #1055960
    Mike

    Hi,
    Some data is saved as a data attribute which is display with JS on page load, it depends on the element. This data may not match your search in Better-Search-Replace, also try searching all tables.

    Best regards,
    Mike

    January 20, 2019 at 8:11 pm #1056282
    fulanoinc

    Hi all,

    I chose all the database tables and conducted a “dry-run” to see how many instances per table. The dry-run showed 200 plus instances of the name throughout three database tables. Could not have been the wrong database since it showed 200 plus instances of that specific name. I initiated the actual search and replace and after it finished I ran another dry-run to see if anything showed up. Now there are zero occurrences of that name anywhere. I flushed the cache from Cloudflare, sever, and browser. When I check the website, the names are still present.

    The words I’m trying to change are in the text and title elements of the Avia builder, and in a footer widget.

    I am confused by this too.

    Thanks,
    Leyden

    January 20, 2019 at 9:18 pm #1056321
    Mike

    Hi,
    Does the title have a special character in it?
    I searched for “Free updates & support” in my database with PHPMyAdmin:
    2019-01-20-135505
    and this is how it’s stored in the database:
    2019-01-20-135413
    you can see that the shortcode of the page and the text is stored together, and since it’s a title, search & replace of this might work better:

    heading='Free Updates & Support'

    Your 200 hits could have been from revisions, so you can disable and remove Revisions from your database with one of these plugins

    Best regards,
    Mike

  • Author
    Posts
Viewing 11 posts - 1 through 11 (of 11 total)
  • You must be logged in to reply to this topic.