WordPress.org

1. Rollercoasterider
   Member
   Posted 10 months ago #

   I think 3.2.1 is my version--unless that has come out in the last 9 days, then it is the previous version.

   I have just had to switch hosts. Due to a convoluted multihost set up with my main website, the process has taken over a week and the new host has been doing all of the work; he has moved everything for me while I have just had to sit back and wait—very nice of him.
   I finally had to change domains. I registered a new domain and put my blog on a subdomain. That propagated two days ago and the host transferred the files yesterday...he said it should be up by evening yesterday.
   It wasn't, but this morning I can get to it without the theme, so progress.

   But I cannot get to wp-admin at all. I tried adding that to the end of my new address and got a that link must be broken page.

   So what do I need to do to get my wp-admin to the new name?
   ALl of my article urls are still pointed to the old url, is there somewhere/way I can change those in a switf move, or do I need to doe ach individually?
   And after that, what other things will I need to change?

2. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 10 months ago #

   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.

3. Rollercoasterider
   Member
   Posted 10 months ago #

   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.

4. esmi
   Theme Diva & Forum Moderator
   Posted 10 months ago #

   Search & Replace: http://wordpress.org/extend/plugins/search-and-replace/

5. Rollercoasterider
   Member
   Posted 10 months ago #

   Looks good, but it says it has not been tested for my version.

6. Rollercoasterider
   Member
   Posted 10 months ago #

   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.

7. esmi
   Theme Diva & Forum Moderator
   Posted 10 months ago #

   Try increasing the memory available to PHP:
   http://wordpress.org/support/topic/253495#post-1017842

   Or temporarily deactivating some of your other plugins.

8. Rollercoasterider
   Member
   Posted 10 months ago #

   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?

9. esmi
   Theme Diva & Forum Moderator
   Posted 10 months ago #

   Not all hosts allow you to increase the available memory via php.ini. Could you try temporarily deactivating a couple of your other plugins?.

10. Rollercoasterider
    Member
    Posted 10 months ago #

    I deactivated all and that did not help...sorry, should mentioned that too.

11. Ipstenu
    Half-Elf Support Rogue & Mod
    Posted 10 months ago #

    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/

12. Rollercoasterider
    Member
    Posted 10 months ago #

    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?

13. Rollercoasterider
    Member
    Posted 10 months ago #

    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.

14. Rollercoasterider
    Member
    Posted 10 months ago #

    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?

Reply

You must log in to post.