Multisite setup on subdomain but using subdirectories?

  • Resolved pouipouidesign

    (@pouipouidesign)


    14 years, 2 months ago

    Hi everyone,

    I’ve searched the forums for an answer to my question, but to no avail…
    I hope I didn’t miss it, and if so I’m sorry and thankful in advance for your pointing me to it.

    I’m having trouble activating multisite and can’t understand if it comes from my host, my setup, or is just “normal” (eg. “not supposed to work”).
    I get the (in)famous “One or more database tables are unavailable. The database may need to be repaired.” message described in http://codex.wordpress.org/Debugging_a_WordPress_Network

    I have installed my “first” wp in http://clients.domain.com/xyz
    When I installed multisite (mods to config.php and htaccess), tables where created, wp didn’t squeal any error message at me and just asked me to chose modes and check settings.
    I have chosen “sud directories” mode as it was the only one (I can’t be using subdomains obviously?).
    Then things went awry with the quoted message above when trying to reach the website again.

    Important thing to note : I have an app (Pancake Payments) installed in the root directory above xyz (at http://clients.domain.com), I don’t know if that causes problems (but am guessing it could).

    So, anyway, that’s my setup, hosted on a shared server at OVH (french host), and my problem with multisite.
    Any advice on how to proceed and get this working?
    – should I move pancake in a subdir alongside xyz or is it unrelated?
    – should I have pancake on a subdomain, my wp sites on another (and in subdir mode)?
    – another way of setting things up?

    I’d be ok with tidying things up differently, although I do like the idea of having everything client-related in a specific subdomain as I had originally planned…

    Thanks a lot in advance for your help, getting frustrated here ^^
    Marie

Viewing 10 replies - 1 through 10 (of 10 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    14 years, 2 months ago

    Leave everything where it is.

    WordPress is installed in http://clients.domain.com/xyz

    You turned on Multisite, updated the wp-config.php and the .htaccess in the xyz folder.

    Check your WordPress database and see if the tables wp_blog or wp_sites were created. If NOT, you may not have admin access to the DB, and cannot create tables.

    Thread Starter pouipouidesign

    (@pouipouidesign)

    14 years, 2 months ago

    Hello,

    Thanks a lot for your quick answer!

    As it is, the required tables listed in the codex page for debugging network installations were indeed created.

    If it can help: my web server is indeed a shared hosting, but my sql server is supposed to be “private” (as opposed to the ones they “give” with the hosting) and I have all admin rights/root accesses to it, at least AFAIK…

    Any idea what else could be wrong?
    Thanks again for your help!

    Marie

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    14 years, 2 months ago

    Can you try running a repair in phpMyAdmin?

    Thread Starter pouipouidesign

    (@pouipouidesign)

    14 years, 2 months ago

    Hello,

    Sorry I couldn’t get back to you earlier, was in the train without a connection.
    Anyway, I repaired each table one by one (ie. “repair table wp_blogs”) and it said “ok” for each.

    –Should I retry setting multisite now (wp-config.php and .htaccess)?–

    Ok, so I remodified the wp-config and htaccess files, still the same problem.

    -> If I try to access clients.domain.com/xyz/wp_admin I get “One or more database tables are unavailable. The database may need to be repaired.”

    -> If I try to access clients.domain.com/xyz I get “Error during database connexion” (roughly translated from french)

    I’m completely lost… ^^

    Thanks again,
    Marie

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    14 years, 2 months ago

    Error during database connexion

    That sounds like when you’re editing the wp-config, you’re not doing it right.

    What lines are you adding into that file?

    Thread Starter pouipouidesign

    (@pouipouidesign)

    14 years, 2 months ago

    Hello again,

    I followed the tutorial on the Codex, as well as the “debugging a wp network” guide to check on what I did and didn’t find any errors, but here is what I copy-pasted from the instructions that wordpress gave me while setting up multisite :

    define('WP_ALLOW_MULTISITE', true);
define( 'SUBDOMAIN_INSTALL', false );
$base = '/xyz/';
define( 'DOMAIN_CURRENT_SITE', 'clients.domain.com' );
define( 'PATH_CURRENT_SITE', '/xyz/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );

    I added that at the end before “/* That’s all, stop editing! Happy blogging. */”

    Thanks again for your help !!

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    14 years, 2 months ago

    You’re missing a line…

    Where did define( 'MULTISITE', true ); go?

    Thread Starter pouipouidesign

    (@pouipouidesign)

    14 years, 2 months ago

    Sorry, I thought it was obvious but I didn’t copy-paste it here again since it was already there in the file from the first manipulation as per the codex.

    So the full “multisite” block does currently read :

    /** Multisite **/
define('WP_ALLOW_MULTISITE', true);
define( 'SUBDOMAIN_INSTALL', false );
$base = '/xyz/';
define( 'DOMAIN_CURRENT_SITE', 'clients.domain.com' );
define( 'PATH_CURRENT_SITE', '/xyz/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );

    Is that correct?

    Thanks again, hope we can make it work! 🙂

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    14 years, 2 months ago

    You are still missing this:
    define( 'MULTISITE', true );

    That is not the same as this:
    define('WP_ALLOW_MULTISITE', true);

    You need both.

    Thread Starter pouipouidesign

    (@pouipouidesign)

    14 years, 2 months ago

    Huh ^^
    I can’t believe I didn’t see this! oO

    I’ve been re-reading those lines so often that I didn’t even see the difference and when I glanced “multisite” in the wp-admin instructions I thought I saw “allow multisite”…

    Anyway, I feel very silly, and enormously grateful, as it works perfectly… \o/

    As it is I still have to test creating more “sub sites” and everything, but I can access my main site and the network menu, etc., which is a giant step forward.

    So thank you very VERY much for your time and patience, I’ll mark that topic as resolved!

    Marie

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Multisite setup on subdomain but using subdirectories?’ is closed to new replies.

Tags