Migration Problems

This topic contains 13 replies, has 4 voices, and was last updated by  Stiofan O’Connor 8 years, 10 months ago.

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

Open Support Ticket

Tagged: , ,

  • Author
    Posts
  • September 28, 2015 at 2:52 pm #54841

    Jen Thomson
    Buyer
    Post count: 145

    I’ve just transferred my site to it’s new domain from the development server and I have lost all of my custom place settings, prices, listing form.

    I backed up the database, changed the urls, exported it, changed the urls that hadn’t been changed and imported it so I though that would have worked ok.

    Any ideas on how to fix this? I don’t want to have to go through the whole setup process again if possible.

    September 28, 2015 at 2:53 pm #54842

    Jen Thomson
    Buyer
    Post count: 145
    This reply has been marked as private.
    September 28, 2015 at 9:29 pm #54915

    Guust
    Moderator
    Post count: 29970

    I guess you ran all the GD Tools, and have checked your permalinks at GD > Permalinks and Settings > Permalinks?
    Your permalinks do not seem correct:
    https://wpgeodirectory.com/docs/basic-installation/#postnames

    If you need us to have a look, post your WP admin details.

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

    September 28, 2015 at 9:41 pm #54920

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    how did you cahnge the URL.

    My procedure to get this right at 1st attempt is:

    1) Backup all files and transfer to new server
    2) Export the db to transfer
    3) Import it in the new database
    4) Upload this scirpt via FTP in the root of your website (where wp-admin, wp-content and wp-includes folders are)
    5) Run the script to find and replace the old domain with the new domain.

    Following this procedure you can’t go wrong.

    Let us know if you still have problems.

    Thanks

    September 28, 2015 at 9:46 pm #54922

    Jen Thomson
    Buyer
    Post count: 145
    This reply has been marked as private.
    September 28, 2015 at 11:18 pm #54949

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    your WordPress permalinks settings where wrong.

    Let us know if you still see problems.

    Thanks

    September 28, 2015 at 11:28 pm #54952

    Jen Thomson
    Buyer
    Post count: 145
    This reply has been marked as private.
    September 28, 2015 at 11:48 pm #54955

    Paolo
    Site Admin
    Post count: 31206

    I’m sorry, I confused the 2 website. It looks like the main CPT is gone. I don’t know Sequel Pro, I’ve never used it, but I fear it could have broken some serialized option.

    Could you please try reimporting the backup following the procudure I gave you? That is what I’d try to do.

    Thanks

    September 29, 2015 at 11:24 am #54983

    Jen Thomson
    Buyer
    Post count: 145

    That worked! Thank you Paolo.

    September 29, 2015 at 1:09 pm #54998

    Paolo
    Site Admin
    Post count: 31206

    🙂

    December 22, 2015 at 2:49 pm #64891

    Jen Thomson
    Buyer
    Post count: 145

    Hello. Sorry to revisit an old thread but I am trying to do this in reverse, so that I can back up and update plugins locally. Following your instructions Paolo…

    1) Backup all files and transfer to new server
    2) Export the db to transfer
    3) Import it in the new database
    4) Upload this scirpt via FTP in the root of your website (where wp-admin, wp-content and wp-includes folders are)
    5) Run the script to find and replace the old domain with the new domain.

    When I get to step 3 I get an error message saying

    Error

    SQL query:
    INSERT INTO wp_geodir_attachments VALUES(“”,””,””,””,””,””,””,””,””,””,””,””);

    MySQL said: Documentation
    #1062 – Duplicate entry ‘0’ for key ‘PRIMARY’

    Any ideas?

    December 22, 2015 at 6:27 pm #64939

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    is the new database where you are trying to import an empty database?

    Let us know,

    Thanks

    December 22, 2015 at 6:50 pm #64950

    Jen Thomson
    Buyer
    Post count: 145

    Yes it is.

    December 23, 2015 at 5:14 pm #65120

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Jen, This is a common issue when transfering DB’s, there are many solutions depending on what stage you are at, please find the one most appropriate from stackoverflow: https://www.google.co.uk/search?q=Duplicate+entry+‘0’+for+key+‘PRIMARY’

    Thanks,

    Stiofan

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

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount