You need to edit your database and change all instances of olddomain to newdomain.
If you can’t get your themes to show, check that the wp-content/themes folders came over and have the right permissions.
Strange, the response and question I posted yesterday morning did not post.
You need to edit your database and change all instances of olddomain to newdomain.
How?
I did find some youtube tutorials. One recommended using the script from this page here.
http://interconnectit.com/124/search-and-replace-for-wordpress-databases/
But that comes with dire warnings–it’s not a for dummies version. I made a back ups but the warnings have me scared away.
I hjave got the theme back but my blog is like a painted but empty egg. You can see the main page but try clicking on a link to an article/post and…http 404
I am willing to try the script but I think I’m just trying to find some reassurance first.
Looks good, but it says it has not been tested for my version.
Well, I got brave and tried the plugin and got this.
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 5779 bytes) in [plugin pathway] on line 612
I tried it first selecting it to search all. AFter that I tried selecting it to search only a single checked item. The results were the same.
Also, would this take care of the serialized issue where the character numbers in the address are listed just before the address? That is what the page about that script said…that a standard search and replace or just replacing by hand does not take into account that the character number also needs changing.
Try increasing the memory available to PHP:
http://wordpress.org/support/topic/253495#post-1017842
Or temporarily deactivating some of your other plugins.
Instructiopns from that thread you linked me to
1. If you have access to your PHP.ini file, change the line in PHP.ini
If your line shows 16M try 32M:
memory_limit = 32M ; Maximum amount of memory a script may consume (32MB)
2. If you don’t have access to PHP.ini try adding this to an .htaccess file:
php_value memory_limit 32M
3. Try adding this line to your wp-config.php file:
Increasing memory allocated to PHP
define(‘WP_MEMORY_LIMIT’, ’32M’);
4. Talk to your host.
I edited php.ini
Originally it had this: memory_limit = 64M ; Maximum amount of memory a script may consume (16MB)
and running the plugin I got this error:
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 5779 bytes) in /home/rollerc3/public_html/loveanyway/wp-content/plugins/search-and-replace/search-and-replace.php on line 612
I changed it to this: memory_limit = 64M ; Maximum amount of memory a script may consume (32MB)
and got this error:
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 128 bytes) in /home/rollerc3/public_html/loveanyway/wp-content/plugins/search-and-replace/search-and-replace.php on line 612
I changed it again to this: memory_limit = 64M ; Maximum amount of memory a script may consume (64MB)
and got this error
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 80 bytes) in /home/rollerc3/public_html/loveanyway/wp-content/plugins/search-and-replace/search-and-replace.php on line 612
So it is getting closer. But can I change it more? My host is also helping me with issues at my forum due to the migration and though I asked about this issue with wordpress he has not answered–he only answered my forum related issue even though I was asking for memory rather than for information about how to do something. (He is not familiar with wordpress and is familiar with the forum.)
I then tried the advice about editing wp-config.php. But the line to search for and change (define(‘WP_MEMORY_LIMIT’, ’32M’);) was not in my file. I did a search for the word ‘memory’ and it’s not in there.
Then there was the advice about .htaccess.
There is not a .htaccess file in my wordpress folders. There is one in public but it’s empty.
So can I continue to increase the php.ini?
If so, to what?
Not all hosts allow you to increase the available memory via php.ini. Could you try temporarily deactivating a couple of your other plugins?.
I deactivated all and that did not help…sorry, should mentioned that too.
Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 5779 bytes) in [plugin pathway] on line 612
Alas, if you don’t have the memory to run the plugin, you will have to do it manually in phpMyAdmin.
ETA: Link for how to: http://www.lancelhoff.com/phpmyadmin-sql-search-and-replace/
Thanks, I had already been doing that even more manually. I was doing a search but did not know how to globally replace and was thus pasting the new url by hand. So those intructions are an improvement.
A few concerns.
1. I have been going through the tables slowly and just tried to access my site. Link broke. Uh Oh. I did something!
2. Reading about this over the lsat few days I read that there is an issue with serialization. The urls are often preceded by a character count in that url and the typical search and replace does not change the character count. Do you know anything about this and what to do about it?
3. I tried the seach and replace instructions a few times for the wp_commentmeta and it didn’t remove them. The first time it said it did, but when I did a search of tables that one still came up with the same amount. Now when I try it just says it finds 0.
Thoughts?
Solutions?
Update
I decided to reverse one of my search and replaces…each one and test the blog to see which caused the problem.
The first I tried gave results.
the table wp_posts in the field guid was what I reversed–I changed the urls back to the old just to see.
Of course I need to change those, but clearly more needs to be done…maybe that has something to do with the serialization issue. I replaced 319 instance of the url.
I have completed all of the serach and replaces. I even redid the one that I reversed and this time it did not cause the same problem.
In fact nothing has changed at the blog. The links look like they point correctly, but they only go to an http 404 error
The table wp_commentmeta had the character counts I discussed above–that was the table where I noticed it, I could have missed it in other places.
For that table I went through and changed the character counts by hand. Actually search and replace function didn’t work with that table and I made the changes in notepad and MSWord–I kept a copy of the before as well as the after in a change log I created.
But as I said, nothing has changed when I check the blog.
So what else might the problem be? Somewhere the path to the urls after the index page are just not working.
I have access to my wp-admin. Is there somewhere in there I can go to check that everything is set up properly?
