WP needs db repairing when creating network

  • massayoshi

    (@massayoshi)


    14 years ago

    Using 3.0 beta
    I followed this guide: http://codex.wordpress.org/User:Andrea/Create_A_Network

    And at the end it says “…refresh your dashboard. You will now see a new menu section called Super Admin.”. But when I refreshed I got this error “One or more database tables are unavailable. The database may need to be repaired.” and then I found out that if I comment the line “define(‘VHOST’, ‘yes’);” it goes back to normal. Without the Network.

    My config.php

    /** MULTI USER! */
define('WP_ALLOW_MULTISITE', true);
define('VHOST', 'yes');
$base = '/';
define('DOMAIN_CURRENT_SITE', 'my.domain.com');
define('PATH_CURRENT_SITE', '/');
define('SITE_ID_CURRENT_SITE', 1);
define('BLOG_ID_CURRENT_SITE', 1);
define('WP_ALLOW_REPAIR', true);

Viewing 15 replies - 1 through 15 (of 29 total)
1 2
  • Thread Starter massayoshi

    (@massayoshi)

    14 years ago

    Just one small correction, VHOST was set to NO. I changed to see if it would work. It didn’t.

    Andrea Rennick

    (@andrea_r)

    14 years ago

    The VHOST setting is used to determine if you picked a subfolder (no) or a subdomain (yes) url structure for new sites.

    VHOST = virtual subdomains.

    you will probably need to check some settings and run the network install again. And please go to wherever you manage your database and see if it actually added any new tables.

    things to look for that WPMU was picky about that may have changed:
    – does the db user have ALL permissions on the db?
    – is the db user’s password 6 characters or more (I know…)

    Thread Starter massayoshi

    (@massayoshi)

    14 years ago

    Yeah I know about the vhost. I just pointed it out because this was causing the WP to “crash”.

    The db user’s pass has more than 6 chars and 2 tables were created I believe. wp_blogs and wp_blog_versions. Should’ve been more? And from what I know the db user can’t use drop.

    Thanks

    Thread Starter massayoshi

    (@massayoshi)

    14 years ago

    I’m an idiot. I forgot to add the first line on the config.php
    define( 'MULTISITE', true );

    When I read it I thought it was the same as “define(‘WP_ALLOW_MULTISITE’, true);” so I skipped.

    I’m on Super Admin!

    Thanks for your help!

    Thread Starter massayoshi

    (@massayoshi)

    14 years ago

    One last question, is it possible to allow a user to post just under one category?

    pswheeler

    (@pswheeler)

    14 years ago

    I tried to set up multi. And i have had no luck. Went to the same place as you but i guess it is missing infor for me.. Is there a way I could see a full copy of your config file with dp and pas info removed.

    pswheeler

    (@pswheeler)

    14 years ago

    I keep getting data base errors. I used what you have posted. not sure what i am doing wrong yet..

    Andrea Rennick

    (@andrea_r)

    14 years ago

    pswheeler – put define( ‘MULTISITE’, true ); in your config file FIRST.

    Then go visit the Network menu.

    “is it possible to allow a user to post just under one category? “

    Same as it would be for if it were just a single WP blog.

    pswheeler

    (@pswheeler)

    14 years ago

    this is what i got in the config file.

    define( ‘MULTISITE’, true );
    define(‘WP_ALLOW_MULTISITE’, true);
    define(‘VHOST’, ‘no’);
    $base = ‘/’;
    define(‘DOMAIN_CURRENT_SITE’, ‘gottabmine.com’);
    define(‘PATH_CURRENT_SITE’, ‘/’);
    define(‘SITE_ID_CURRENT_SITE’, 1);
    define(‘BLOG_ID_CURRENT_SITE’, 1);
    define(‘WP_ALLOW_REPAIR’, true);

    i did a fresh install and i get this error now.

    Parse error: syntax error, unexpected T_STRING in /home/wheeler3/public_html/blog/wp-config.php on line 4

    These are the first lines in the config file right after @package wordpress.

    Andrea Rennick

    (@andrea_r)

    14 years ago

    take them out.

    do not put them in when you are installing.

    Get WP installed & running first.

    then edit your config file again and place this one line in there:

    define( ‘MULTISITE’, true );

    Then go visit the Network menu item under Tools. Follow those directions.

    Can you confirm you did that?

    pswheeler

    (@pswheeler)

    14 years ago

    i was running. now i get can not concet to db.

    pswheeler

    (@pswheeler)

    14 years ago

    ok wordpress is up and running at http://www.gottabmine.com . the config file works. now i am ready to try for a 4th time lol.

    pswheeler

    (@pswheeler)

    14 years ago

    ok i have it added just like this.

    * @package WordPress
    */
    define( ‘MULTISITE’, true );

    but i get a error. i will leave the error up on the site for people to see.

    Thread Starter massayoshi

    (@massayoshi)

    14 years ago

    @pswheeler did you have any luck?

    pswheeler

    (@pswheeler)

    14 years ago

    no.. not yet. hope to get it up soon. but break time. kids need to be taken to school.

Viewing 15 replies - 1 through 15 (of 29 total)
1 2
  • The topic ‘WP needs db repairing when creating network’ is closed to new replies.

Tags