I'm sorry for my English)) I tried to move the blog to a new domain. Gave an error: "The script encountered an error while running an AJAX request.If you are using your hosts file to map a domain try browsing via the IP address directly.If you are still running into problems we recommend trying the CLI script bundled with this package.See the README for details." What am I doing wrong? Where can I read about it? Thank you!

Using version 3.1 on PHP 5.5.38. When I run dry or live run it reports: 2: Class __PHP_Incomplete_Class has no unserializer in /srdb/srdb.class.php on line 735

This line is in recursive_unserialize_replace() function.

As far as I can tell the changes are still correctly made.

I am happy to help debug this issue.

Ran into this issue when attempting to S/R a wordpress install (staging to www) via CLI.

wp_oauth_clients: 0 rows, 0 changes found, 0 updates made in 0.00028396 seconds
wp_oauth_refresh_tokens: replacing staging.community.newmessage.org with community.newmessage.org
wp_oauth_refresh_tokens: 0 rows, 0 changes found, 0 updates made in 0.00022697 seconds
wp_oauth_scopes: replacing staging.community.newmessage.org with community.newmessage.org
wp_oauth_scopes: 0 rows, 0 changes found, 0 updates made in 0.00022101 seconds
wp_options: replacing staging.community.newmessage.org with community.newmessage.org
syntax error, unexpected '\' (T_NS_SEPARATOR), expecting '{'
$

Any idea what could be wrong here?

Thanks!

Hello I appear to be getting an error using this program. The error appears to happen half way through the trial run: The dry-run option was selected. No replacements will be made. 2: Class __PHP_Incomplete_Class has no unserializer in /home/nomadthe/public_html/SReplace/srdb.class.php on line 735

Has anyone seen this ?

I've tried different browsers, I've disabled caching both on the browser and the host. The same program appears to work on a different website by the same hosting company - siteground. This suggests to that it's something specific to my database.

I've also disabled Wordfence and Yoast SEO ... because I've seen mentions else where that this has happened with Yoast.

Any ideas? Any help would be much appreciated.

Regards Stuart

The script encountered an error while running an AJAX request.
If you are using your hosts file to map a domain try browsing via the IP address directly.
If you are still running into problems we recommend trying the CLI script bundled with this package.
See the README for details.

This appears when trying to do anything dry run / live run, etc. Running on PHP 7.0, tried troubleshooting in README but no solution.

I also noticed when it POST's to itself, it's returned a 404 from the server

Every time I try to find and replace something on a Wordpress Database, I get the same error on the wp_options table, which is:

syntax error, unexpected '\' (T_NS_SEPARATOR), expecting '{'

This is not allowing me to find and replace on the wp_options table, as the script gets interrupted. Any idea why this is happening and how to fix it?

Thanks

Hi, I've got these 2 notices appearing since I've been using PHP 7 :

PHP Notice:  A non well formed numeric value encountered in srdb.cli.php on line 197
PHP Notice:  A non well formed numeric value encountered in srdb.cli.php on line 202

Casting the variables inside number_format function as float values solves the problem :

line 197 : $time = number_format( (float)  $report[ 'end' ] - (float) $report[ 'start' ], 8 );
line 202 : $time = number_format( (float) $report[ 'end' ] - (float) $report[ 'start' ], 8 );

Hi, I'm getting the following error when running the CLI locally:

host: localhost database: yamuna user: root pass: mypass charset: utf-8 search: mywebsite.com replace: dev.mywebsite.com

MySQL Connection Error: Array ( [0] => No such file or directory ) PHP Warning: mysql_set_charset() expects parameter 2 to be resource, boolean given in /Users/myusername/Sites/dev.mywebsite.com/.bak/searchreplacedb2cli.php on line 113 MySQL Table Error: Array ( [0] => No such file or directory [1] => No such file or directory )

Using those identical login credentials I'm able to log into mysql no problem. Any idea what the problem could be? Thanks in advance.

I'm attempting to use it to migrate from a development environment (http://dev.truenorth.com) to a staging environment (http://truenorth.brandedclever.com). My goal is to search and replace the URLs and when I run the script, it completes successfully. However, when I load the page on the staging server it renders incorrectly.

Based on my testing, I've narrowed it down to an 'option_name' in 'wp_options' called 'udesign_options'. I've included pasties to the before and after versions of the contents of that field so that you could see a diff of the two. From what I can tell, it doesn't seem to be updating the length of certain fields, which might be the issue.

Any suggestions would be hugely appreciated since this is the only site I can't get working.

Before search and replace: http://pastie.org/private/w5wqplpt17ujjqnydkavq After search and replace: http://pastie.org/private/drvedkwf55gjcackqrkhw

General Info

• Search/Replace String: http://dev.truenorth.com and http://truenorth.brandedclever.com
• Search-Replace-DB Version: 2.1.1

Development Environment

• WordPress: 3.4.1
• Theme: U-Design (http://themeforest.net/item/udesign-wordpress-theme/253220)
• OS: Mac OS X 10.8 Mountain Lion
• DB: MySQL 5.5.25a
• PHP: 5.5.13

Staging Environment

• WordPress: 3.4.1
• Theme: U-Design (http://themeforest.net/item/udesign-wordpress-theme/253220)
• OS: Ubuntu 12.04 LTS
• DB: MySQL 5.5.25
• PHP: 5.3.10-1ubuntu3.2

Thanks in advance!

This isn't actually an issue which needs addressing (or can even be addressed), but I wanted to get a record out there for Google to pick up, in case somebody else runs into this problem, since it manifests quite bizarrely and doesn't respond to the other usual suggestions.

Basically, if you're trying to use Search-Replace-DB on a GoDaddy shared hosting account, and getting that AJAX error whenever you try to do anything, it's because some security stuff on GoDaddy's side is purposefully blocking it. I was finally able to get a support person to call over to a sysadmin type who verified that it was getting purposefully blocked. Presumably due to this being a tool one could conceivably use maliciously if a site was hacked, or if you had database creds for someone else on the shared server, though in either of those cases it's hard to see why they'd single it out.

Regardless, this can be partially worked around. Whatever their security stuff does, it seems to at least partially depend on a checksum or something of the file being run. If you literally make any change to Search-Replace-DB's index.php file, including, say, adding a newline, or adding a letter/word/whatever inside the comments, you'll likely be able to use it for at least a little while. (Reverting your edit will get you right back to AJAX errors.) Unfortunately even after doing that, it'll probably run afoul of some more dynamic blocking, which'll cotton on to the activity within a few runs, most likely.

As suggested by other Issues about these AJAX errors, so long as you've got SSH enabled on the account, you can go in and use the CLI option, which will work without problems.

A little bit more info about how the blocking manifests, just FYI, is that the AJAX POST will return literally nothing from the server - not even a 404 or any other error. You can verify in your browser's Network monitor (via F12, generally), or even with a packet sniffer if you're getting ambitious. It's easiest to do the sniffing over just HTTP, so don't use real DB creds with it in that mode, but you'll be able to see the POST go out, an ACK from the server, and then immediately a FIN from the server - no data response whatsoever. (This is one thing which differentiates it from some other cases where a 404 gets generated.)

Anyway, as I say, I just wanted to get this out there somewhere in case someone else runs into the problem. I'd been wondering for awhile if PHP bytecode caching or something was getting in the way, but in the end it was the security stuff.

I need to add -d memory_limit -1 to execute search & replace command. I get a lot of messagges like these until php killes the process:

PHP Notice: icit_srdb::recursive_unserialize_replace(): The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "WPML_Notices" of the object you are trying to operate on was loaded before unserialize() gets called or provide an autoloader to load the class definition in srdb.class.php on line 755

PHP Notice: icit_srdb::recursive_unserialize_replace(): The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "WPML_Notice" of the object you are trying to operate on was loaded before unserialize() gets called or provide an autoloader to load the class definition in srdb.class.php on line 755

PHP Notice: icit_srdb::recursive_unserialize_replace(): The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "WPML_Taxonomy_Translation_Help_Notice" of the object you are trying to operate on was loaded before unserialize() gets called or provide an autoloader to load the class definition in srdb.class.php on line 755

Is there any bug with php 7.2 or newest WordPress, plugins, etc. versions?

I got the same error as described in issue #368. I read this note and simply added the number 2 after continue (except where VS Code marked that as an error). Disclaimer: PHP is not my favourite programming language and I don't know much about it. But I tested the changes and for me, it worked. Anyway, someone more knowledgable should check these.

I needed a way to provide password without having it in command argument (which could then be read from user users from the server in /proc) to use it in a script. First approach would have been to accept it from STDIN when using an option, but that approach would be incompatible with any other STDIN usage, and .my.cnf files are common enough so that would probably be helpful to someone else.

I tried to match your coding style but it is probably not close enough, sorry about that.

Hello there :)

First of all, thank you for your great script! I'm trying to use the CLI version for the first time but can't make it work… I'm using MAMP Pro on a Macbook. Here is the configuration of the ports on MAMP Pro:

Here is the command I used: /Applications/MAMP/bin/php/php7.4.2/bin/php ./srdb.cli.php -h 127.0.0.1 -n mydbname -u root -proot --port 3306 -c utf8mb4 -s "olddomain" -r "newdomain" With this command, I got this: db: SQLSTATE[HY000] [2002] Connection refused And we're done!

Could you pease tell me what's wrong?

Kind regards, Cedric

It's not a problem that I had for my case, (I just wanted to test the extension, still valid after the last WordPress update).

If you want to use it in localhost to practice using it, it may happen that the connection to the database is refused.

Getting the following errors on PHP 8.1.

[php:error] [pid 24] [client 172.19.0.1:48538] PHP Fatal error:  Uncaught mysqli_sql_exception: No such file or directory in /var/www/html/dbtool/srdb.class.php:523\nStack trace:\n#0 /var/www/html/dbtool/srdb.class.php(523): mysqli_real_connect(Object(mysqli), NULL, NULL, NULL, NULL, NULL)\n#1 /var/www/html/dbtool/srdb.class.php(475): icit_srdb->connect_mysqli()\n#2 /var/www/html/dbtool/srdb.class.php(461): icit_srdb->connect('mysqli')\n#3 /var/www/html/dbtool/index.php(318): icit_srdb->db_setup()\n#4 /var/www/html/dbtool/index.php(89): icit_srdb_ui->response()\n#5 /var/www/html/dbtool/index.php(5477): icit_srdb_ui->__construct()\n#6 {main}\n  thrown in /var/www/html/dbtool/srdb.class.php on line 523
[php:error] [pid 24] [client 172.19.0.1:48538] PHP Fatal error:  Uncaught mysqli_sql_exception: No such file or directory in /var/www/html/dbtool/srdb.class.php:523\nStack trace:\n#0 /var/www/html/dbtool/srdb.class.php(523): mysqli_real_connect(Object(mysqli), NULL, NULL, NULL, NULL, NULL)\n#1 /var/www/html/dbtool/srdb.class.php(475): icit_srdb->connect_mysqli()\n#2 /var/www/html/dbtool/srdb.class.php(461): icit_srdb->connect('mysqli')\n#3 /var/www/html/dbtool/index.php(318): icit_srdb->db_setup()\n#4 /var/www/html/dbtool/index.php(385): icit_srdb_ui->response()\n#5 [internal function]: icit_srdb_ui->fatal_handler()\n#6 {main}\n  thrown in /var/www/html/dbtool/srdb.class.php on line 523
"GET /dbtool/ HTTP/1.1" 500 210 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36"

On PHP 7.4 Search-Replace-DB works as expected.

This is not a bug report or malfunction.

I thought highlighting was such crucial and useful feature of this tool.

Currently, I am doing SR on local environment and the highlight is no longer there.

Will we see the come back of this feature?