After relocating multisite – domain name is repeated in path

  • brianwbates

    (@brianwbates)


    13 years, 1 month ago

    After successfully setting up a multisite on my laptop after giving up with 1and1 hosting, I needed to make it visible to selective remote users.
    I started with virtual hosts and a pseudo domain: flapajack.local which worked fine with two child blogs on the same machine. I then set up a dynamic IP account with dyndns and set my real domain name at 123-reg to forward to dyndns dynamic IP service which correctly forwarded to my laptop. I then followed the tips for moving wordpress to a new URL, but must have made a mistake somewhere as the main site appears without images and style sheets. This is because some links contain a copy of the domain name as the name of first directory in the path, but most links are correct, please see the output from httpfox below:

    04:33:46.595	0.801	662	4967	GET	200	text/html	http://wordpress304.local/

04:33:47.241	0.216	733	478	GET	404	text/html	http://wordpress304.local/wordpress304.local/wp-content/plugins/buddypress/bp-themes/bp-default/style.css

04:33:47.261	0.270	745	3970	GET	200	text/css	http://wordpress304.local/wp-content/plugins/google-custom-search/css/smoothness/jquery-ui-1.7.3.custom.css?ver=3.0.4

...
04:33:47.337	0.426	725	405	GET	200	text/css	http://wordpress304.local/wp-content/plugins/buddypress-ajax-chat/bp-chat/css/nifty.css?ver=3.0.4

    I tried to fix the problem by dumping the database to sql, then search and replace all references to old-domain with new-domain, then reloading the database. However, I still have the same problem.

    I would like to understand how to fix this because I will eventually have to move development work to VPS on a different domain name and do not want to risk a repeat occurrence of this problem.

    If I new where to look I could add some debugging code into to the relevant section of php.

    Any tips on how to proceed would be much appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Andrea Rennick

    (@andrea_r)

    13 years, 1 month ago

    Look in your wp-config.php file & htaccess. those are the only files that contain domain name references.

    Thread Starter brianwbates

    (@brianwbates)

    13 years, 1 month ago

    Thanks for the quick response.

    I have abandoned the first installation and went through a similar exercise with a second installation and had different but similar issues.

    Like many other posters who have moved their sites…

    There are several places where tables contain old domains:
    (some being more important than others)

    When I got the message saying wp could not connect to the database, it didn’t mean the credentials were faulty, the real cause was a problem accessing certain tables.

    These are the ones I found containing the old domain:
    tables:
    wp_options
    wp_2_options
    wp_3_options
    wp_xxx_options
    wp_blogs

    fields:
    option_name option_value
    siteurl
    admin_email
    home
    fileupload_url
    new_admin_email
    ftp_credentials

    As well as these places I found hard-coded/stored old domain name in additional places. In buddypress’s config file (bb-config.php) for example.

    It took me a long time to find the subtle error in .htaccess file but you were spot on!

    The second site is working again but would fail if the old domain was not directed to the new domain, so there is still more work to be done to know which fields can be safely changed.

    It would be useful to have something like a phpmyadmin page which lists the tables containing the domain name.

    I may end up writing a script to pick through the database.

    Thanks again for helping!

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    13 years, 1 month ago

    It would be useful to have something like a phpmyadmin page which lists the tables containing the domain name.

    You mean like the search function?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘After relocating multisite – domain name is repeated in path’ is closed to new replies.