Jump to content

Archived

This topic is now archived and is closed to further replies.

webmktco

Migrating from staging to live site... serialized URLs in JSON

Recommended Posts

webmktco

I'm in the midst of launching a staging site to live and I'm running into issues with textboxes having the wrong URL structure.

For example, it has domain.com instead of www.domain.com... this only happens in textboxes. 

My migration process is:

  1. Migrate using BackupBuddy
  2. I also use the Advanced: Database Mass Text Replacement feature.
  3. Download pl-config JSON file, search/replace http:\/\/domain.com with http:\/\/www.domain.com

But I still see the non-www URLs in the text boxes.

Can you please help? Here's the debug info: http://www.jenningsortho.com/?pldebug=1.

 

Share this post


Link to post
Share on other sites
Simon

your advanced database replacement feature probably isnt looking at where dms stores the section data, its a db table called pl_data_sections

After you manualy edit the db dont forget to flush your hosts cache if its WPEngine for example.

Are you editing serialized data directly?

Can you post a snippet? 

Share this post


Link to post
Share on other sites
webmktco

Thanks, Simon for the help. According to BackupBuddy it search/replaces in all of the tables, just not the standard wp_ table.

I did edit the JSON file and search/replaced... then uploaded/imported the JSON file in the DMS config panel in the DMS editor. I also made sure to flush/clear any caching (I use SiteGround's cloud hosting).

Here's the domain: http://www.jenningsortho.com/.

 

Share this post


Link to post
Share on other sites
webmktco

I also should note that the JSON file had numerous instances of code from a previous website that I developed for another client. 

Obviously when I imported the DMS config file from the other site to the new client's site, it added all the code from the old site in the JSON file. Is there a way to not include this when I'm importing config files for new sites?
 

Share this post


Link to post
Share on other sites
Simon

The JSON file will include all post/page and section data from the donor site.

Where in the backupbuddy docs does it mention custom tables?

Share this post


Link to post
Share on other sites
webmktco

Are you familiar with BB? In the WP dashboard, go to BackupBuddy > Database > scroll down to Advanced: Database Mass Text Replacement.

2016-04-05_15-21-22.png

Share this post


Link to post
Share on other sites
Simon

if you are using a backup plugin to migrate the entire site with all the db tables.. you shouldnt ever need a pl config file as you have already imported all the data within the database.

Share this post


Link to post
Share on other sites
webmktco

Agreed, but for some reason BB isn't properly updating the URL (except of the menu and loop).

Where exactly can I find the pl-config in the wp database?

Share this post


Link to post
Share on other sites
Simon

pl_data_sections is where all sections options data is stored.

Share this post


Link to post
Share on other sites

  • Similar Content

    • layasamadhi
      By layasamadhi
      See image attached.
      I click on 'Ok', the popup closes and nothing happens. Why?
      I also try with a website from scratch (without plugins).
      My DMS version is 2.1.9.5

    • swoda
      By swoda
      When I attempt to export a single template, I actually receive an export of the entire site and every template.
       
      I have Deselected All Templates, and then simply chosen the correct templates, but it is not working.
       
      Unfortunately, that means I can't import a single template into my site without overwriting every other template.
       
      Any suggestions?
    • BBKing
      By BBKing
      Hi,
       
      I hope i can explain the topic correctly, but I am trying to find out how to make output generated by the JSON-API usable/readable. Some of the output generated by the Json-APi is like expected but the part with the actual content (see code starting form pl-settings) is not what I expected form JSON output. I am afraid a filter or controller is needed to sanitise the pagelines content. 
      Hopefully somebody can help me. Even an answer that  it's not possible to get the content of the pagelines DMS website would be helpful.
       
      I need the clean content for a project on an Iphone (native Objective C app)
       
      Thanks.
      { id: 1, slug: "bbking", name: "BBKing", first_name: "", last_name: "", nickname: "BBKing", url: "", description: "" }, comments: [ ], attachments: [ ], comment_count: 0, comment_status: "open", custom_fields: { pl-settings: [ "a:2:{s:4:"live";a:9:{s:10:"custom-map";a:1:{s:8:"template";a:3:{i:0;a:7:{s:4:"name";s:0:"";s:5:"class";s:0:"";s:2:"id";s:14:"pl_areauxyzci5";s:6:"object";s:13:"PLSectionArea";s:3:"sid";s:7:"pl_area";s:5:"clone";s:7:"uxyzci5";s:7:"content";a:1:{i:0;a:6:{s:6:"object";s:10:"PLMasthead";s:5:"clone";s:7:"ueydv4r";s:3:"sid";s:8:"masthead";s:4:"span";s:1:"8";s:6:"offset";s:1:"0";s:6:"newrow";s:5:"false";}}}i:1;a:7:{s:4:"name";s:0:"";s:5:"class";s:0:"";s:2:"id";s:14:"pl_areau0tde47";s:6:"object";s:13:"PLSectionArea";s:3:"sid";s:7:"pl_area";s:5:"clone";s:7:"u0tde47";s:7:"content";a:2:{i:0;a:6:{s:6:"object";s:9:"PLNextBox";s:5:"clone";s:7:"u0r1nzn";s:3:"sid";s:10:"pl-nextbox";s:4:"span";s:1:"6";s:6:"offset";s:1:"0";s:6:"newrow";s:5:"false";}i:1;a:6:{s:6:"object";s:17:"PageLinesMediaBox";s:5:"clone";s:7:"ut3ye3v";s:3:"sid";s:8:"mediabox";s:4:"span";s:1:"4";s:6:"offset";s:1:"1";s:6:"newrow";s:5:"false";}}}i:2;a:7:{s:4:"name";s:0:"";s:5:"class";s:0:"";s:2:"id";s:14:"pl_areauj13a4a";s:6:"object";s:13:"PLSectionArea";s:3:"sid";s:7:"pl_area";s:5:"clone";s:7:"uj13a4a";s:7:"content";a:1:{i:0;a:6:{s:6:"object";s:10:"PLICallout";s:5:"clone";s:7:"um5nfjw";s:3:"sid";s:8:"icallout";s:4:"span";s:2:"10";s:6:"offset";s:1:"1";s:6:"newrow";s:5:"false";}}}}}s:7:"uio3h1v";a:7:{s:11:"pl_area_pad";s:3:"0px";s:14:"pl_area_height";s:3:"325";s:16:"pl_area_parallax";s:11:"pl-parallax";s:18:"pl_area_background";s:49:"[pl_site_url]/wp-content/uploads/2014/05/Band.jpg";s:28:"pl_area_background_attach_id";s:2:"44";s:14:"pl_area_repeat";s:1:"0";s:20:"pl_area_color_enable";s:1:"0";}s:7:"uv7hznf";a:11:{s:18:"pl_standard_styles";s:15:"color: #de1f42;";s:24:"pagelines_masthead_title";s:10:"Onze Bands";s:26:"pagelines_masthead_tagline";s:46:"Guilty records is op zoek naar vergeten muziek";s:22:"masthead_button_link_1";s:21:"www.teamtreehouse.com";s:22:"masthead_button_text_1";s:10:"Meer weten";s:24:"masthead_button_target_1";s:1:"0";s:23:"masthead_button_theme_1";s:11:"btn-success";s:22:"masthead_button_link_2";s:9:"www.nu.nl";s:22:"masthead_button_text_2";s:11:"Meld je aan";s:24:"masthead_button_target_2";s:1:"0";s:23:"masthead_button_theme_2";s:12:"btn-ol-white";}s:7:"ueydv4r";a:14:{s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:18:"pl_standard_styles";s:15:"color: #de1f42;";s:24:"pagelines_masthead_title";s:10:"Onze Bands";s:26:"pagelines_masthead_tagline";s:46:"Guilty records is op zoek naar vergeten muziek";s:22:"masthead_button_link_1";s:11:"?page_id=68";s:22:"masthead_button_text_1";s:10:"Meer weten";s:24:"masthead_button_target_1";s:1:"0";s:23:"masthead_button_theme_1";s:12:"btn-ol-white";s:22:"masthead_button_link_2";s:9:"www.nu.nl";s:22:"masthead_button_text_2";s:11:"Meld je aan";s:24:"masthead_button_target_2";s:1:"0";}s:7:"uofcxbm";a:12:{s:24:"pagelines_herounit_title";s:13:"Secret Sounds";s:24:"pagelines_herounit_image";s:55:"[pl_site_url]/wp-content/uploads/2014/05/SS-CR-Fr03.jpg";s:34:"pagelines_herounit_image_attach_id";s:2:"66";s:16:"herounit_reverse";s:1:"0";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:19:"herounit_left_width";s:5:"span8";s:20:"herounit_right_width";s:5:"span4";s:22:"herounit_button_target";s:1:"0";s:21:"herounit_button_theme";s:7:"primary";}s:7:"um5nfjw";a:12:{s:15:"icallout_format";s:6:"inline";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:18:"pl_standard_styles";s:15:"color: #FFFFFF;";s:13:"icallout_text";s:38:"Secret Sounds Complete Remasters op CD";s:18:"icallout_text_wrap";s:2:"h4";s:13:"icallout_link";s:10:"page_id=62";s:15:"icallout_target";s:1:"0";s:18:"icallout_link_text";s:16:"Direct bestellen";s:18:"icallout_btn_theme";s:12:"btn-ol-white";}s:7:"uj13a4a";a:9:{s:14:"pl_area_height";s:2:"60";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:16:"pl_area_parallax";s:11:"pl-parallax";s:14:"pl_area_repeat";s:1:"0";s:20:"pl_area_color_enable";s:1:"1";s:13:"pl_area_color";s:6:"D81C3B";}s:7:"ut3ye3v";a:10:{s:14:"mediabox_image";s:55:"[pl_site_url]/wp-content/uploads/2014/05/SS-CR-Fr03.jpg";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:18:"pl_standard_styles";s:34:"margin-top: 4%; margin-bottom: 2%;";s:14:"mediabox_align";s:4:"left";s:15:"mediabox_height";s:3:"200";s:17:"disable_centering";s:1:"0";s:6:"no_pad";s:1:"0";}s:7:"u0r1nzn";a:10:{s:15:"nextbox_content";s:918:"<h3>Secret Sound</h3> <p>Secret Sounds besloot in 1983 haar debuut plaat in eigen beheer uit te brengen. Het was het begin van het platenlabel Guilty Records. In die tijd niet ongebruikelijk bij minder op de hitparade gerichte bands. Het gaf muzikanten meer artistieke vrijheid en er was zeker een markt voor. <br />Wat nieuw was, was dat de band betrokken was bij alle facetten van ieder project van pre-poductie tot persing, van drukwerk tot promotie. Het label bleef door de band ook gehandhaafd bij gelimiteerde speciale releases en later bij in licentie door major labels uitgebrachte platen.<br />Guilty Records werd nieuw leven ingeblazen toen voorjaar 2013 de eerste Secret Sounds muziek als downloads verkrijgbaar werd op iTunes, Bandcamp.com en andere online stores. Met de uitgave van Secret Sounds Complete Remasters op CD, los en als Box-set, herwint Guilty nu ook zijn ode glans met fysieke releases.</p>";s:17:"nextbox_shortcode";s:1:"0";s:15:"nextbox_wpautop";s:1:"0";s:11:"nextbox_php";s:1:"0";s:12:"nextbox_divs";s:1:"0";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:18:"pl_standard_styles";s:16:"margin-left: 5%;";}}s:5:"draft";a:9:{s:10:"custom-map";a:1:{s:8:"template";a:3:{i:0;a:7:{s:4:"name";s:0:"";s:5:"class";s:0:"";s:2:"id";s:14:"pl_areauxyzci5";s:6:"object";s:13:"PLSectionArea";s:3:"sid";s:7:"pl_area";s:5:"clone";s:7:"uxyzci5";s:7:"content";a:1:{i:0;a:6:{s:6:"object";s:10:"PLMasthead";s:5:"clone";s:7:"ueydv4r";s:3:"sid";s:8:"masthead";s:4:"span";s:1:"8";s:6:"offset";s:1:"0";s:6:"newrow";s:5:"false";}}}i:1;a:7:{s:4:"name";s:0:"";s:5:"class";s:0:"";s:2:"id";s:14:"pl_areau0tde47";s:6:"object";s:13:"PLSectionArea";s:3:"sid";s:7:"pl_area";s:5:"clone";s:7:"u0tde47";s:7:"content";a:2:{i:0;a:6:{s:6:"object";s:9:"PLNextBox";s:5:"clone";s:7:"u0r1nzn";s:3:"sid";s:10:"pl-nextbox";s:4:"span";s:1:"6";s:6:"offset";s:1:"0";s:6:"newrow";s:5:"false";}i:1;a:6:{s:6:"object";s:17:"PageLinesMediaBox";s:5:"clone";s:7:"ut3ye3v";s:3:"sid";s:8:"mediabox";s:4:"span";s:1:"4";s:6:"offset";s:1:"1";s:6:"newrow";s:5:"false";}}}i:2;a:7:{s:4:"name";s:0:"";s:5:"class";s:0:"";s:2:"id";s:14:"pl_areauj13a4a";s:6:"object";s:13:"PLSectionArea";s:3:"sid";s:7:"pl_area";s:5:"clone";s:7:"uj13a4a";s:7:"content";a:1:{i:0;a:6:{s:6:"object";s:10:"PLICallout";s:5:"clone";s:7:"um5nfjw";s:3:"sid";s:8:"icallout";s:4:"span";s:2:"10";s:6:"offset";s:1:"1";s:6:"newrow";s:5:"false";}}}}}s:7:"uio3h1v";a:7:{s:11:"pl_area_pad";s:3:"0px";s:14:"pl_area_height";s:3:"325";s:16:"pl_area_parallax";s:11:"pl-parallax";s:18:"pl_area_background";s:49:"[pl_site_url]/wp-content/uploads/2014/05/Band.jpg";s:28:"pl_area_background_attach_id";s:2:"44";s:14:"pl_area_repeat";s:1:"0";s:20:"pl_area_color_enable";s:1:"0";}s:7:"uv7hznf";a:11:{s:18:"pl_standard_styles";s:15:"color: #de1f42;";s:24:"pagelines_masthead_title";s:10:"Onze Bands";s:26:"pagelines_masthead_tagline";s:46:"Guilty records is op zoek naar vergeten muziek";s:22:"masthead_button_link_1";s:21:"www.teamtreehouse.com";s:22:"masthead_button_text_1";s:10:"Meer weten";s:24:"masthead_button_target_1";s:1:"0";s:23:"masthead_button_theme_1";s:11:"btn-success";s:22:"masthead_button_link_2";s:9:"www.nu.nl";s:22:"masthead_button_text_2";s:11:"Meld je aan";s:24:"masthead_button_target_2";s:1:"0";s:23:"masthead_button_theme_2";s:12:"btn-ol-white";}s:7:"ueydv4r";a:14:{s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:18:"pl_standard_styles";s:15:"color: #de1f42;";s:24:"pagelines_masthead_title";s:10:"Onze Bands";s:26:"pagelines_masthead_tagline";s:46:"Guilty records is op zoek naar vergeten muziek";s:22:"masthead_button_link_1";s:11:"?page_id=68";s:22:"masthead_button_text_1";s:10:"Meer weten";s:24:"masthead_button_target_1";s:1:"0";s:23:"masthead_button_theme_1";s:12:"btn-ol-white";s:22:"masthead_button_link_2";s:9:"www.nu.nl";s:22:"masthead_button_text_2";s:11:"Meld je aan";s:24:"masthead_button_target_2";s:1:"0";}s:7:"uofcxbm";a:12:{s:24:"pagelines_herounit_title";s:13:"Secret Sounds";s:24:"pagelines_herounit_image";s:55:"[pl_site_url]/wp-content/uploads/2014/05/SS-CR-Fr03.jpg";s:34:"pagelines_herounit_image_attach_id";s:2:"66";s:16:"herounit_reverse";s:1:"0";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:19:"herounit_left_width";s:5:"span8";s:20:"herounit_right_width";s:5:"span4";s:22:"herounit_button_target";s:1:"0";s:21:"herounit_button_theme";s:7:"primary";}s:7:"um5nfjw";a:12:{s:15:"icallout_format";s:6:"inline";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:18:"pl_standard_styles";s:15:"color: #FFFFFF;";s:13:"icallout_text";s:38:"Secret Sounds Complete Remasters op CD";s:18:"icallout_text_wrap";s:2:"h4";s:13:"icallout_link";s:10:"page_id=62";s:15:"icallout_target";s:1:"0";s:18:"icallout_link_text";s:16:"Direct bestellen";s:18:"icallout_btn_theme";s:12:"btn-ol-white";}s:7:"uj13a4a";a:9:{s:14:"pl_area_height";s:2:"60";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:16:"pl_area_parallax";s:11:"pl-parallax";s:14:"pl_area_repeat";s:1:"0";s:20:"pl_area_color_enable";s:1:"1";s:13:"pl_area_color";s:6:"D81C3B";}s:7:"ut3ye3v";a:10:{s:14:"mediabox_image";s:55:"[pl_site_url]/wp-content/uploads/2014/05/SS-CR-Fr03.jpg";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:18:"pl_standard_styles";s:34:"margin-top: 4%; margin-bottom: 2%;";s:14:"mediabox_align";s:4:"left";s:15:"mediabox_height";s:3:"200";s:17:"disable_centering";s:1:"0";s:6:"no_pad";s:1:"0";}s:7:"u0r1nzn";a:10:{s:15:"nextbox_content";s:918:"<h3>Secret Sound</h3> <p>Secret Sounds besloot in 1983 haar debuut plaat in eigen beheer uit te brengen. Het was het begin van het platenlabel Guilty Records. In die tijd niet ongebruikelijk bij minder op de hitparade gerichte bands. Het gaf muzikanten meer artistieke vrijheid en er was zeker een markt voor. <br />Wat nieuw was, was dat de band betrokken was bij alle facetten van ieder project van pre-poductie tot persing, van drukwerk tot promotie. Het label bleef door de band ook gehandhaafd bij gelimiteerde speciale releases en later bij in licentie door major labels uitgebrachte platen.<br />Guilty Records werd nieuw leven ingeblazen toen voorjaar 2013 de eerste Secret Sounds muziek als downloads verkrijgbaar werd op iTunes, Bandcamp.com en andere online stores. Met de uitgave van Secret Sounds Complete Remasters op CD, los en als Box-set, herwint Guilty nu ook zijn ode glans met fysieke releases.</p>";s:17:"nextbox_shortcode";s:1:"0";s:15:"nextbox_wpautop";s:1:"0";s:11:"nextbox_php";s:1:"0";s:12:"nextbox_divs";s:1:"0";s:23:"pl_standard_nouser_hide";s:1:"0";s:21:"pl_standard_user_hide";s:1:"0";s:23:"pl_standard_mobile_hide";s:1:"0";s:24:"pl_standard_desktop_hide";s:1:"0";s:18:"pl_standard_styles";s:16:"margin-left: 5%;";}}}" ] 
    • dbrowne02
      By dbrowne02+
      Hi,
       
      I created a dummy site to design my website. Once I got it close to the way I wanted it, I used the import/export function to get the settings from the dummy site to the real site. Everything worked great except for two issues.
       
      1) The custom CSS in the DMS editor transferred over, which is great. However, I am unable to make any changes to that custom css. In fact, I even tried to temporarily remove all custom css (saving in a text editor), published with no custom css in the DMS editor, but when I refresh the site, all of the original custom CSS comes back. I have tried to edit, delete, change, remove custom css--no matter what I do, all custom css stays the same way it was when I imported it. I am publishing after I make change. I tried flushing the caches...Not sure what else to do.
       
      2) When I load my imported templates onto various pages, they work great for a little while, then after a few refreshes, the site seems to decide that it no longer wants to use the template that I have chosen for that particular page.
       
      Does anyone have any idea of how I can fix this?
       
      Great product, have really enjoyed it so far. Thanks in advance for your help!
       
       
       
       
×