Problems after moving server

This topic contains 7 replies, has 3 voices, and was last updated by  Guust 8 years, 4 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • January 8, 2016 at 4:10 am #67398

    adele
    Expired Member
    Post count: 65

    Hi, we have just moved our site to a new server and the Listings menu item containing all the listings has disappeared. As well as switching servers, the site was moved from a subdirectory to the root. I have updated the database to fix all the file paths and the rest of the site is working fine, it’s just the listings that aren’t showing.

    The directory home page is now a 404 page (http://www.plasticsurgeryhub.com.au/psh-directory) but the actual listing urls are still there (http://www.plasticsurgeryhub.com.au/psh-directory/plastic-surgeons-nsw/dr-lisa-friederich/) but the content from the listing details is not there (only images and comments).

    I considered using the GD import & export tool but I’m not sure if this is necessary?

    January 8, 2016 at 6:17 am #67408

    Guust
    Moderator
    Post count: 29970

    WP admin details please.

    January 8, 2016 at 6:38 am #67411

    adele
    Expired Member
    Post count: 65
    This reply has been marked as private.
    January 8, 2016 at 4:28 pm #67470

    Paolo
    Site Admin
    Post count: 31206

    Hi Adele,

    which tool did you use to export/import the database from the old to the new server?

    There seems to be options missing from the wp_options table.

    How did you change the URLs path in the DB? Via notepad or txt file editor? That would break serialized options.

    You should use a tool like this: https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

    Let us know,

    Thanks

    January 9, 2016 at 1:49 am #67513

    adele
    Expired Member
    Post count: 65

    Hi Paolo

    I did everything in PhpMyAdmin – imported the existing database then used the following SQL to find/replace the url paths:

    UPDATE wp_posts SET post_content = REPLACE (
    post_content,
    ‘Item to replace here’,
    ‘Replacement text here’);

    January 9, 2016 at 3:47 am #67518

    Guust
    Moderator
    Post count: 29970

    From https://codex.wordpress.org/Moving_WordPress#Changing_Your_Domain_Name_and_URLs:

    If you do a search and replace on your entire database to change the URLs, you can cause issues with data serialization, due to the fact that some themes and widgets store values with the length of your URL marked. When this changes, things break.

    You need to use the tool Paolo linked.

    January 9, 2016 at 5:15 am #67526

    adele
    Expired Member
    Post count: 65

    Ok, I’ve now used the tool and it worked perfectly!

    January 9, 2016 at 5:22 am #67527

    Guust
    Moderator
    Post count: 29970

    Well done ! 🙂

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket