Widgets not showing on live site

UPDATE

I just remembered that I had used this process on a previous WP move. The widgets transferred fine on that site. So I have just gone through the process again on the above site to make sure I hadn’t gone wrong and its still the same…

I have read articles about longer url lengths affecting the transfer, but again the other site had a much longer url, and this was fine.

Anyone any ideas?

Wayne

UPDATE 2

After a bit of searching, it seems its to do with the length of the urls being different between local and live. The main response is to have your lengths the same, but as I’m already over 50% into the site with a lot of widgets I’m not sure what to do…

Looking in my database dump the following line says;

INSERT INTOwp_optionsVALUES(89, 0, 'widget_text', 'a:7:{i:2;a:3:{s:5:"title";s:0:"";s:4:"text";s:0:"";s:6: etc.etc....

And I think the a:7 is the reference to my local url length (it was 7), so if I do a find and replace for a:7 and change it to a:30 (live url length), should this work, or will I be screwing up other bits of the site?

What do you think?

Wayne

I know it’s a couple months later, but I wanted to post that I ran into this issue too and figured out a solution. You need to edit the “s” parameter before each URL with the new URL length. For example:

…;s:25:”https://wp.old-site.com/wp”;…

will have to become:

…;s:22:”https://new-site.com/wp”;…

It’s a pain, but if you get them all, it should work.

For what it’s worth, I also moved the site twice. The first move was to longer URLs and I had no problems just using a MySQL replace. The second move was to shorter ones, and that’s what broke everything.

Best of luck!

– Drew

Hi Drew

This reminded me I was supposed to come back and update that my way doesn’t work.

Thanks for your findings, I will definitely try this next time, I do a find and replace on the urls by taking the database export into Coda so that should be easy enough to replace.

I couldn’t find an answer before so I just re-did the widgets on the live version… there weren’t too many so it wasn’t the worst job.

Thanks again, this is going to make future WP sites a lot less painful!

Wayne

The widgets I drag into the r side bar don’t show up. Is there any help without having to edit code?

i”m using Twenty Eleven theme. Safari Mac OS Snow Leopard

Please post your own topic instead of posting to a resolved thread.