WordPress.org

Support

Support » Alpha/Beta » WP needs db repairing when creating network

WP needs db repairing when creating network

  • 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)
  • Just one small correction, VHOST was set to NO. I changed to see if it would work. It didn’t.

    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…)

    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

    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!

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

    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.

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

    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.

    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.

    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?

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

    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.

    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.

    @pswheeler did you have any luck?

    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)
  • The topic ‘WP needs db repairing when creating network’ is closed to new replies.