IRD-dev

Sadly, this plugin failed to assist me, per my last feedback.

I did, however, use the “Dry Run” report as a reference, and swept the WPDB using phpMyAdmin.

For example, I used the following SQL command to update the list of WP tables below:

UPDATE wp_comments
SET comment_author_email = REPLACE(comment_author_email, 'clientname.net.temp.mydevhost.com', 'clientname.net')
WHERE comment_author_email LIKE '%clientname.net.temp.mydevhost.com%'

Tables : columns manually updated:

• wp_comments : comment_author_email
• wp_layerslider : data
• wp_options : option_value
• wp_postmeta : meta_value
• wp_posts : post_content
• wp_posts : guid

I am dismayed that, after your kind assistance and my own efforts, the plug-in was still having issues. I am hopeful that my feedback here will allow you to enhance the plug-in to work for people in my scenario.

Hmm. The Search & Replace feature seems to be confused – it throws this error:

Errors:
Your search contains your current site url.
Replacing your site url will most likely cause your site to break.
If you want to change the URL (and you know what you doing), please use the export function and make sure you backup your database before reimporting the changed SQL.

Is this triggered due to the fact that the search-for and replacement URLs are similar?

http:\\clientname.net.temp.mydevhost.com\
to
http:\\clientname.net\

I do not want to export / import, if I can avoid it. Just not comfortable proceeding in that manner.

Or, perhaps, this is due to the SETTINGS > GENERAL site values needing to FIRST be changed?

/wp-admin/options-general.php

• WordPress Address
• Site Address

While awaiting your feedback, I changed the two aforementioned General values and will continue to re-try your plug-in thereafter.

I promise to choose “5-stars”, once we’re done here!

(1) OK – plugin’s backup is not stored locally. That’s good and preferred, actually. Not sure why it did not download .. but no worry, as I took a backup using my Hosting Panel services.

(2) My Hosting Panel says the mySQL db is 5968 KB. It’s a small website, with a handful of pages and posts. The largest table size is wp_postmeta with a mere 4,000 records. The second largest record count is 600 in the wp_options table. What do you consider “large” ?

(3) Hence, it’s of no concern that “S” (serialization) info is changing?

Ja, es ist eine gro?e Hilfe! Stand by please!!

So far, I have not executed! I am grateful that you’re responsive on this weekend evening (2330 CEST)

A few points for you:
(1) After doing a backup, the button to download failed to do anything .. but disappeared after clicking. Where is the backup physically stored on the server? I’ll fetch it via FileZilla.

(2) The Search & Replace (dry run) located MANY instances. The report ran off the lower part of my Chrome browser and, despite the vertical scrollbar, it was still impossible to see the last few lines. Moreover, attempting to select-all unfortunately also included data from behind the non-modal pop-up. I merely wanted to keep a copy handy, for my own review.

Aside from that, it looks like it’s finding accurate data. My only remaining concern is that I noticed in the DRY RUN results the following changed values (other than my replacement text):

row	457	column	option_value	Old value:	a:1:{i:0;a:1:{i:0;s:35:"mydomain.com.temp.work.com/";}}	New value:	a:1:{i:0;a:1:{i:0;s:18:"mydomain.com/";}}

What is the value “S” and why would it change?

Vielen Dank, wieder, für Ihre freundliche Unterstützung!

Circling back on this topic, for those interested:

(1) In the Child Theme, I edited the footer template file as follows. I’ve also requested of the theme developer to incorporate shortcode support for this template and they gratefully agreed to comply:

Edited file: template-footer-bottom-bar.php
Instead of: echo $copyrights;
Changed to: echo do_shortcode( $copyrights );

(2) Wrote a custom shortcode “custom_copyright_shortcode”, using plugin “Code Snippets“:

function custom_copyright() {
   $date = getdate();
   return '? ' . $date['year'];
}
add_shortcode(‘custom_copyright_shortcode’, ‘custom_copyright’);

(3) Lastly, in the theme, under Branding > Copyright Text, I entered:

[custom_copyright_shortcode] Company name, Inc.

End result: Theme’s bottom bar now shows:

? 2016 Company name, Inc.

and it will automatically change each year, in sync with server date/time!

This is truly a DANGEROUS plugin. Highly recommend others do NOT use i

No response in 5 months?

This is truly a DANGEROUS plugin. Highly recommend others do NOT use it.

Thank you. I ended up using the FREE version of “Say What” plug-in, to accomplish this goal. I successfully renamed “SKU:” to “Product #:”, as mentioned above.

Hello. I have since moved this discussion to your Support queue.

Thanks. Haven’t tried that, as of yet.

Rene –

It seems the DRY RUN option is not available for the REPLACE DOMAIN/URL tab. It’s only on the SEARCH & REPLACE tab.

What is the difference between the two tabs, in regard to my intended purpose?

Danke!

Mike, I believe the error to be as follows:

[31-Mar-2016 15:58:29 UTC] PHP Fatal error: Call to undefined function wc_variation_attribute_name() in E:\HostingSpaces\myuser\mydomain.com\wwwroot\wp-content\plugins\woocommerce\includes\class-wc-product-variable.php on line 340

*bump*

Hallo und danke, Rene.

If I understood correctly, “Dry Run” will do the full search and report .. but not make any changes. Ist das wahr?

In regard to your 2nd point, this plugin is optionally able to replace *directly* to the database .. versus generating a SQL update script? Assuming this to be true, that would be precisely what I desire to do.

Please confirm!

If all is truth, I will do a DRY RUN first .. and thereafter do the Direct-to-Database update.

OK, thank you – That change eliminated one of the two errors / warnings.

Regarding the last remaining error/warning, as mentioned above:

FROM: [your-name] <[email protected]>
Error is shown in red: “This email address does not belong to the same domain as the site.”

Please comnfirm this is a non-issue. I presume this is due to the fact that website is presently on a development URL whose domain name is not “MyDomain2.com” at this time. It will be, however, once live.