Issues migrating Wordpress site from local to live

Question

I've migrated a local test of a Wordpress site to a live server but I'm encountering a weird issue. Everything works fine, but one of the plugins that I'm using (NextGEN Gallery) is attempting to download a few CSS and JS files from the old location at 127.0.0.1/powwptest.1/.

I cannot figure this issue out for the life of me. I have done repeated searches for 127.0.0.1, localhost, and powwptest.1 or powwptest in the database through phpMyAdmin, I have manually searched the .SQL file with Sublime Text, and searched all 1600+ PHP files with Sublime Text to no avail. Absolutely nothing is found.

If there is no record of 127.0.0.1/powwptest.1 in the database or in any of the files, why is it still attempting to download from the local server?

A few of the calls, for an example:

http://127.0.0.1/powwptest.1/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/jquery.fancybox-1.3.4.css?ver=3.6
http://127.0.0.1/powwptest.1/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/jquery.easing-1.3.pack.js?ver=3.6
http://127.0.0.1/powwptest.1/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/jquery.fancybox-1.3.4.pack.js?ver=3.6
http://127.0.0.1/powwptest.1/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/nextgen_fancybox_init.js?ver=3.6
http://127.0.0.1/powwptest.1/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/jquery.fancybox-1.3.4.pack.js?ver=3.6
http://127.0.0.1/powwptest.1/wp-content/plugins/nextgen-gallery/products/photocrati_nextgen/modules/lightbox/static/fancybox/nextgen_fancybox_init.js?ver=3.6

I've cleared cache, cookies, tried in multiple browsers, and even used a third-party (Pingdom) to make sure I'm not crazy. They are all detecting the connection errors as well. I've tried updating the Wordpress plugin on the live server, to no avail. Any ideas?

Answer 1

I figured it out finally, hopefully this works for others having an issue with NextGen Gallery. From your WordPress dashboard, go to Gallery -> Other Options -> Lightbox Effects -> (Show Advanced Settings). At this point you can delete the http://127.0.0.1/ etc. entirely from each entry. You'll have to do this once for each type of Lightbox.

It seems to me that this information is stored on a 3rd party server, otherwise there is no reason it could reappear in the DB.

Answer 2

I've just spent 3 hours of solving same issue. Finally, I've found out, look into DB

select * from wp_postmeta where meta_value like '%127.0.0.1%';

Answer 3

The new team that's been developing NextGen Gallery seems to have broken a lot of things. I've ran into some crazy problems with this plugin and site moves.

Try resetting permalinks as well as the plugin settings (which, if I recall correctly, you can do from the plugin settings page in WordPress). This won't clear your galleries, only settings set in the plugin settings.