I can't add new sites

  • Hi guys,

    I’m begginer in wordpress.

    My problem is that, I can’t create new sites in Network Admin. When I Click on Add New, the system show that the site is created but when I visit it show a message:
    Error establishing a database connection

    Then, I go to /site/wp-admin and the system request me that repair the database. I click in the link of repair and this is the message:

    wp_39_posts: Table ‘wordpress.wp_39_posts’ doesn’t exist
    wp_39_comments: Table ‘wordpress.wp_39_comments’ doesn’t exist
    wp_39_links: Table ‘wordpress.wp_39_links’ doesn’t exist
    wp_39_options: Table ‘wordpress.wp_39_options’ doesn’t exist
    wp_39_postmeta: Table ‘wordpress.wp_39_postmeta’ doesn’t exist
    wp_39_terms: Table ‘wordpress.wp_39_terms’ doesn’t exist
    wp_39_term_taxonomy: Table ‘wordpress.wp_39_term_taxonomy’ doesn’t exist
    wp_39_term_relationships: Table ‘wordpress.wp_39_term_relationships’ doesn’t exist
    wp_39_commentmeta: Table ‘wordpress.wp_39_commentmeta’ doesn’t exist

    the lines of my .htaccess:

    # BEGIN WordPress
    RewriteEngine On
    RewriteBase /wordpress/
    RewriteRule ^index\.php$ – [L]

    # uploaded files
    RewriteRule ^([_0-9a-zA-Z-]+/)?files/(.+) wp-includes/ms-files.php?file=$2 [L]

    # add a trailing slash to /wp-admin
    RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]

    RewriteCond %{REQUEST_FILENAME} -f [OR]
    RewriteCond %{REQUEST_FILENAME} -d
    RewriteRule ^ – [L]
    RewriteRule ^[_0-9a-zA-Z-]+/(wp-(content|admin|includes).*) $1 [L]
    RewriteRule ^[_0-9a-zA-Z-]+/(.*\.php)$ $1 [L]
    RewriteRule . index.php [L]
    # END WordPress

    the lines of my wp-config.php:

    ….
    define(‘WP_ALLOW_MULTISITE’, true);

    define( ‘MULTISITE’, true );
    define( ‘SUBDOMAIN_INSTALL’, false );
    $base = ‘/wordpress/’;
    define( ‘DOMAIN_CURRENT_SITE’, ‘blogjavevirtual.puj.edu.co’ );
    define( ‘PATH_CURRENT_SITE’, ‘/wordpress/’ );
    define( ‘SITE_ID_CURRENT_SITE’, 1 );
    define( ‘BLOG_ID_CURRENT_SITE’, 1 );
    ….

    All my pluggins are disable from the network admin.
    All my themes are disable from the network admin.

    I don’t know to do. Help me, please.

    Excuse Me for my bad English.

    Thanks a lot.

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

    (@ipstenu)

    ?????? Advisor and Activist

    Go check your database and see if the tables exist or not.

    Also you should run a repair of your DB directly (via phpMyAdmin or command line).

    Thread Starter jamespayan

    (@jamespayan)

    Hi Ipstenu, thanks.

    Really, in the database the table don’t exist.
    Also, I check the privileges of my user and it have grants to create tables.
    In my wordpress site, I have more sites that works. The problem is when I create new sites. The new sites don’t work.

    I have a hunch that the problem began since wordpress was updated, but I don′t sure, I don’t know how to check that.

    Anew, Thanks so much.

    James

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Also you should run a repair of your DB directly (via phpMyAdmin or command line).

    Did you do that?

    Thread Starter jamespayan

    (@jamespayan)

    Hi,

    Yes, I do. The messagge:

    Table Op Msg_type Msg_text
    wordpress.blcap_ips repair status OK
    wordpress.blcap_log repair status OK
    wordpress.blcap_sessions repair status OK
    ….
    All tables are OK and wordpress don’t create sites yet.

    I think that the problem is not in database, the problem is with the system, that no creates the tables when I add new sites.

    Thanks Ipstenu (Mika E.).

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    The problem is WP is unable to create the tables, so in a way, it’s ALWAYS a problem with your DB.

    But you understand how I can magically tell you ‘Aha, this!’ right?

    It’s a complex situation.

    Now looking at your site, blogjavevirtual.puj.edu.co reidrects to a login page, so it’s very possible that whatever you did to do that is a problem. Turn it off an test.

    If that fails, you’ll need to start thinking about what you changed recently, when was the last time it worked, and so on.

    Thread Starter jamespayan

    (@jamespayan)

    hehe, ??
    Yes, it’s a complex situation.
    I don’t know what are changed in WP. I’m new here. ??

    The above manager of site, only say that he updated WP to version 3.4.2. I don’t know wich was the above versión. I don’t know when did the update. I don’t know if he could add new sites after he update the WP.

    Actually, I need know where see to discovery the problem. Well, I know, it’s enough with get a solotion, but, it’s frustrating that I don’t understand. hehe ??

    Also, I feel afraid to have to install all WP and have to recreate the old sites with your blogs. I don’t know if there are a way (magical way) to migrate sites from an WP to other.

    Thanks,

    JP

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Well you’re adding “I’m on an old version of WP” into an already complex mix. Multisite is not for beginners, and it’s really not for people who aren’t comfortable with WordPress already :/

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘I can't add new sites’ is closed to new replies.

Tags