Forums

WordPress › Support » Multisite

12

[resolved] wordpress 3 network (multisite) on a local development site (53 posts)

  1. Andrea_r
    team pirate
    Posted 1 year ago #

    The URL is saved in far more tables. Do a search on the db.

  2. PopTopJosh
    Member
    Posted 1 year ago #

    Thanks, Andrea. Searched the full DB and replaced all instances, but I'm still not able to get this running. Set up a virtualhost this morning and if I drop an index.html file in the directory, it opens fine. Once I use index.php though things get wonky. Table prefixes I think are the problem. If I look at the DB in phpmyadmin, I have the following prefixes:
    wp_
    wp_1_
    wp_2_
    wp_3_

    When I use 'wp_' as the table prefix value in wpconfig, I get "Error establishing a database connection." If I use wp_1 as the prefix in wpconfig, I get to the site's 404 page with some plugin errors at the top. Trying to login to the WP backend doesn't work because usernames and passwords aren't being found, and the lost password functionality doesn't work either, it simply returns the email doesn't exist message. I've looked in all of the user tables and the username and email are in all of them.

    Any thoughts or help greatly appreciated.

  3. Andrea_r
    team pirate
    Posted 1 year ago #

    wp_
    wp_1_

    It's the presence of both of these that is confusing WP. One means it;s a single WP install that had the network enabled. (wp_) the other one (wp_1_ ) means it was an upgraded wpmu install.

    which was it?

  4. PopTopJosh
    Member
    Posted 1 year ago #

    It's an updated wpmu site. It's running live right now with no issues, and I've looked at wpconfig on the live site, and that's using wp_ as a prefix, so I'm pretty confused...Thanks for the guidance.

  5. Andrea_r
    team pirate
    Posted 1 year ago #

    Specify in "wp_" as the db prefix is *fine*.

    It's just in an upgraded mu install, you should *not* have wp_posts etc... tables. They should be wp_1_posts for the main blog.

    Did you rename them?

  6. PopTopJosh
    Member
    Posted 1 year ago #

    I didn't rename them, but I didn't do the upgrade. When the upgrade occurred the site was also moved to a different server, same domain. Needless to say I'm not sure what the guy did who moved the site and upgraded it, I'm coming in a bit late on this project. I just tried renaming the wp_ prefixes to wp_1_ and went through the process for doing this found in the codex, but still no luck. Just get the 404 page, no links working, and no ability to login to the backend.

  7. shmar77
    Member
    Posted 1 year ago #

    Hi,
    Any change someone can write up a quick guide on how to install wp3 multi site on localhost (using xampp)?

    I read throw the whole thread an got a bit lost :(

    THANKS :)

  8. boddhi
    Member
    Posted 1 year ago #

    Hi,
    like shmar77 you got me lost. What about a nice and clear tutorial? Anyone ?

    if my main domain is localhost/wp_multi/
    and my subdomain is localhost/wp_multi/dev what should i do ?

    Thanks

  9. Andrea_r
    team pirate
    Posted 1 year ago #

    You can't use wildcard subdomain on localhost for starters.

    Follow any tutorial out there for installing just wordpress locally. then create the network and use SUBFOLDERS.

  10. topracer6969
    Member
    Posted 1 year ago #

    So Andrea,

    My situation is that I've got a WordPress 3.0.1 installed at a hosting company (Dreamhost.com) with subdomain multiuser enabled, with buddypress running. You can see the site here: http://jobs.localjobs.com

    I want to establish a local host testing environment - what option do you think is the best - given that you said the subdomain approach won't work on local host testing environment:

    1. I've created a fresh local install of WordPress (I'm running Mac with OS X (latest version) and I"m using MAMP. Should I try to now configure this as a multi-user locally and then import my live site data via the EXPORT/IMPORT WP approach to populate a local database.

    2. Other....????

  11. Andrea_r
    team pirate
    Posted 1 year ago #

    Wildcard subdomains won't work locally... but you can put in individual subdomain records. ;)

    Yes, do #1. also put in your local address in the db with a search & replace.

  12. topracer6969
    Member
    Posted 1 year ago #

    Is it important that 'multiuser' be enabled on WP ....BEFORE.....we attempt the file mods changes noted in this thread, or not? I went ahead and did it, but didn't enable WP for multiuser yet.....doooopsss..

  13. Andrea_r
    team pirate
    Posted 1 year ago #

    You do not have to do any changes for multisite to work locally.

    (this is the hazard with posting about your particular issue in an ongoign theread - things get muddied)

  14. mandrill
    Member
    Posted 1 year ago #

    So does using subdomains on localhost work or not?

    Wild card subdomains don't, what if I don't use wildcards but set up specific subdomains? And how do I do that?

    I need to make sure the site I'm building works properly locally before updating it, with subdomains.

  15. Andrea_r
    team pirate
    Posted 1 year ago #

    So does using subdomains on localhost work or not?

    Not wildcards.

    Yes, you can set up subdomains manually. Set them us by making one in the hosts file the same way you do fake domains. Or a serveralis in your local apache.

  16. mandrill
    Member
    Posted 1 year ago #

    Thanks for clearing that up Andrea_r. XD

    I've got the subdomains set up in apache and they're working fine. Is there anything specific I have to do in WP (apart from the obvious)?

    eg. The dl zip has WP in its own directory. Do I copy that dir straight into my root or does that count as having WP in its own dir with regards to setting up a network with subdomains (ie it won't work). In which case should I ignore the top level 'wordpress' dir in the zip and just copy everything inside it straight to my root?

  17. Andrea_r
    team pirate
    Posted 1 year ago #

    In which case should I ignore the top level 'wordpress' dir in the zip and just copy everything inside it straight to my root?

    Yes, do this.

  18. mandrill
    Member
    Posted 1 year ago #

    Got it. many thanks.

  19. sgelbart
    Member
    Posted 1 year ago #

    Thanks everyone,
    After following this thread somehow I got a local wordpress mutisite install working with subdomains. I started out following the instructions at http://espositosmusings.wordpress.com/2010/07/28/installing-wordpress-multisite-with-mamp-on-os-x/ and had some problems connecting to the apache server and the article doesn't really apply to subdomains so I had to play with it a bit. In the end here's what worked using MAMP:

    • In MAMP Preferences clicked "Set to default Apache and MySQL ports" which set ports to 80 and 3306, and under Apache set my document root to the local folder I'm using for my website
    • For hosts I added two lines (add mysubdomain2, mysubdomain3 etc):
      <br />
127.0.0.1       localhost<br />
127.0.0.1       mydomain.dev<br />
127.0.0.1      mysubdomain1.mydomain.dev<br />
    • I noticed that I could access Mamp through mydomain.dev and mysubdomain1.mydomain.dev but it seemed like everyone was editing the httpd.conf file to include these so I went ahead and did it. Editing this originally is what was causing Apache to not connect, I must have been making a typo somewhere, but eventually this worked:
      <br />
[code redacted]

      Some of that I'm pretty sure is redundant but it seems to be working so far!

      • In general though, maybe we can put our conclusions from this thread into somewhere that's more accessible? Like http://codex.wordpress.org/Create_A_Networkk or a new article.

  20. ZaneMatthew
    Member
    Posted 1 year ago #

    I ran into alot of issues as well wanted to share my experince's. I've detailed it in this blog post: http://zanematthew.com/2011/01/23/wordpress-networking-on-mac-osx-part-ii/

    What I did was to use the apache2 from my macports install and not from MAMP or the default WebServer built into Mac OSX.

  21. ZaneMatthew
    Member
    Posted 1 year ago #

    You can actually put those lines in your host file on one line like the following:

    127.0.0.1 localhost pma.dev site1.dev site2.dev site3.dev cat.dev

    Also make sure you have permalinks enabled, and that AllowOverride All so WordPress can use the htaccess file.

    Combining this thread into 3 main sections (1. MAMP, 2. MacPorts, 3. Other) and possibly porting it into the codex I think would be a great idea, but setting up WordPress networking on Mac OSX is about 10% WordPress knowledge and 90% Unix/Apache knowledge/configuration. Not sure if WordPress is interested in having a whole section to configuring your local lamp environment.

  22. Andrea_r
    team pirate
    Posted 1 year ago #

    Check the codex to see if it exists already - it just might.

    If not, feel free to add it. Yes, you can, with the same login & username as the forums.

  23. derkoidus
    Member
    Posted 1 year ago #

    has anyone tried virtualxHost to change url instead of hardcoding in apache?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags