Jump to content


Photo
- - - - -

Site URL changed but PageLines Framework settings have been lost


  • Please log in to reply
13 replies to this topic

#1 Elizabeth

Elizabeth

    Advanced Member

  • Members
  • 44 posts
  • Country: Country Flag

Posted 27 February 2012 - 12:20 PM

Hi, I'm developing several sites at the moment and yesterday my web host's servers completely broke and a new server had to be set up and the backups restored. This is fine except that the new server has a different IP address. I had a couple of sites that I was still developing and so I was still using the IP address as their URL rather than their domain name. I've changed the sites' URLs (have done this many times before and am confident about making the SQL changes etc.). Everything is fine except that the PageLines settings have been lost. I haven't got another copy of the site (I've got back ups of the Wordpress files and database but not an export of the Pagelines settings). Is there anything I can do? This is a problem I have experienced every time I've published a website (and therefore had to change the URL from the IP address to the domain name) but I've always had a copy of the site to refer back to before so although it's been irritating and off-putting I've managed to get away with it. By the way, it's a PageLines Framework 2.0 site. Thanks, Elizabeth

#2 Rob

Rob

    One Smart Egg

  • Members
  • 13575 posts
  • LocationEast Coast, USA
  • Framework Version:The Latest, of course
  • Country: Country Flag

Posted 27 February 2012 - 05:37 PM

Elizabeth, I'm not quite sure how to help here. Without a backup of the PageLines settings, there's really not much to restore. If the host is providing a backup from the previous server, theoretically, all you should need to do is CHMOD .htaccess to 777 and go to Dashboard > Settings > Permalinks and save the settings without making any changes. That would globally update every link to the new IP. But things like the layouts, templates etc., would likely have to be edited, checked or redone, I'm very sorry to say. At the bottom of every tab in Dashboard > PageLines > Settings you'll find an "Export" option that creates a file with all your PageLines settings. When you make backups of WP content, I'd suggest making the additional backup of your PageLines settings as well.

#3 Elizabeth

Elizabeth

    Advanced Member

  • Members
  • 44 posts
  • Country: Country Flag

Posted 27 February 2012 - 10:41 PM

Well thanks for replying. I have scheduled backups of my files and database. Anyway of scheduling a backup of the PageLines settings? Have to say I've never had much luck in importing the PageLines settings once the URL has changed.

#4 Simon_P

Simon_P

    Messer

  • Administrators
  • 8388607 posts
  • LocationDevon
  • Framework Version:2.0
  • Country: Country Flag

Posted 27 February 2012 - 10:45 PM

If you have the original database, optin in in phpmyadmin or whatever and under wp-options search for %pagelines% there will be about 5 results, copy those to your new db.

#5 Elizabeth

Elizabeth

    Advanced Member

  • Members
  • 44 posts
  • Country: Country Flag

Posted 29 February 2012 - 10:25 AM

Thanks pross. I have a backup of the original database. I've had a look at the search results but can't understand why copying those to the new db will help as it will still have links to the old IP address. Sorry if I'm being slow here. Am I not understanding something?

#6 Simon_P

Simon_P

    Messer

  • Administrators
  • 8388607 posts
  • LocationDevon
  • Framework Version:2.0
  • Country: Country Flag

Posted 29 February 2012 - 10:29 AM

Well thats where the settings are stored, there will only be a couple of urls in there like header image etc.

#7 Elizabeth

Elizabeth

    Advanced Member

  • Members
  • 44 posts
  • Country: Country Flag

Posted 29 February 2012 - 10:42 AM

I understand and I think this is why I'm so confused; if that makes sense! If the settings are stored there in the database then how could restoring the original database and then changing the urls of things like images that have been uploaded (such as a custom logo and favicon image) mean that other settings are lost (such as the global content width, whether to hide the search bar, enable drop down navigation etc.) as this is what had happened. Incidentally, changing the url of the custom logo and favicon image didn't work. I had to re-upload the images before it would recognise them. Hope I'm making sense. Thank you so much for your help so far.

#8 Simon_P

Simon_P

    Messer

  • Administrators
  • 8388607 posts
  • LocationDevon
  • Framework Version:2.0
  • Country: Country Flag

Posted 29 February 2012 - 10:47 AM

I dont know why the import failed, thats why i suggested expoting the pagelines db entries manually then importing them into your new database, at least you know you have ALL the settings then even if some usrls are busted, thats easy to fix as you said.

#9 Elizabeth

Elizabeth

    Advanced Member

  • Members
  • 44 posts
  • Country: Country Flag

Posted 29 February 2012 - 10:54 AM

Ok. I'll give it a go but I feel very nervous about it. Don't go far away, I may need some more hand-holding.

#10 Simon_P

Simon_P

    Messer

  • Administrators
  • 8388607 posts
  • LocationDevon
  • Framework Version:2.0
  • Country: Country Flag

Posted 29 February 2012 - 11:01 AM

Posted Image

#11 Elizabeth

Elizabeth

    Advanced Member

  • Members
  • 44 posts
  • Country: Country Flag

Posted 29 February 2012 - 11:50 AM

Ooo, I think that's worked! Thank you! Thank you! Thank you! Do you think I must have run a dodgy SQL query when I replaced the URL first time? These are the queries I'd run: UPDATE wp_posts SET guid = replace(guid, 'http://olddomain.com','http://newdomain.com'); UPDATE wp_posts SET post_content = replace(post_content, 'http://olddomain.com', 'http://newdomain.com'); UPDATE wp_links SET link_url = replace(link_url, 'http://olddomain.com', 'http://newdomain.com'); UPDATE wp_links SET link_image = replace(link_image, 'http://olddomain.com', 'http://newdomain.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://olddomain.com', 'http://newdomain.com'); UPDATE wp_usermeta SET meta_value = replace(meta_value, 'http://olddomain.com', 'http://newdomain.com'); UPDATE wp_options SET option_value = replace(option_value, 'http://olddomain.com', 'http://newdomain.com');

#12 Simon_P

Simon_P

    Messer

  • Administrators
  • 8388607 posts
  • LocationDevon
  • Framework Version:2.0
  • Country: Country Flag

Posted 29 February 2012 - 11:51 AM

Maybe you had a typo the first time, any glad you have it sorted.

#13 Elizabeth

Elizabeth

    Advanced Member

  • Members
  • 44 posts
  • Country: Country Flag

Posted 29 February 2012 - 11:53 AM

I'm so, so grateful for your help. Will go and officially thank all your messages now.

#14 Jenny

Jenny

    Owned by PageLines

  • Unicorn Store Dev

  • 2917 posts
  • LocationWV
  • Country: Country Flag

Posted 29 February 2012 - 04:26 PM

Glad Simon was able to help. :) If you consider this issue resolved, please accept an answer. Thanks!