DB tables for new subdomain site fail to get created

  • I’ve got WP 3.0.5 running in a subdomain install, with the domain mapping plugin. It’s been working fine. I created up 5 blogs initially, and then installed the subdomain mapping plugin, and got it working fine. Several weeks passed, with writing and plugin isntallation/removal and all the other little changes that take place over time, and now I’m trying to create another new site, and it’s failing.

    When I look at the DB tables, the information for the new site is showing up in the Network wide tables (wp_blogs, etc) but it’s failing to create the new wp_N_posts, wp_N_comments, (etc) tables that would hold the content for that particular blog. The DB user has all privileges on the table of the blog DB, and I don’t see any explicit errors showing up in the debug.log pertaining to the table creation — though a huge number of them appear when it tries to actually *do* anything with those (non-existent) tables.

    Any ideas?

Viewing 14 replies - 46 through 59 (of 59 total)

  • ive located the file and added the code but it hasnt seemed to have any effect, im receiving the confirmation emal but no files are being created

    Are you sure that you added it correctly, it’s a diff patch.

    i opened it up in dreamweaver and added in the lines ???

    what do you mean by diff patch ???

    apologies

    mrcherry, open ms-functions.php and add
    global $wpdb, $wp_queries;
    at the first line of function body
    and

    if($wp_queries){
            $pattern = $wpdb->base_prefix;
            $prefix = $wpdb->base_prefix . $blog_id . '_';
            $wp_queries = str_replace($pattern, $prefix, $wp_queries);
 	}

    between lines
    switch_to_blog($blog_id);
    and
    install_blog($blog_id, $title);

    THat still hasnt seemed to work, can anyone tell me how to find the database and check the permissions.

    Ive opened up the cpanel and i cannot seem work out which file i am looking for/ or what the correct permission should be ???

    So i worked out that through the php admin i can identity the database, but which files do i need to check permissions on and what are the correct permissions?

    heeeelp

    please can anyone list me the tables required in the database so i can see if any are missing ??

    im really stuck any help would be appreciated.

    also im using php myadmin but i dont know how to check the permissions as previously
    stated

    thanks

    – you don;t check permissiosn on databssdee files. You need to check the permissions fo the database *user*. they are the one given permissiosn to do things to the database.

    If you do not know how to do that, ask your host.

    the database tables are listed in the codex.
    https://codex.www.ads-software.com/Database_Description#Multisite_Table_Overview

    And no – you cannot just go add them.

    thanks ever so much

    All the tables are present, also when i view the wp_registration_log table it shows me
    that new site are being registered.

    Also the blog dir, is not creating a new folder for the site as per normal

    I’ve noticed that my domain mapping screen looks odd;
    the first line used to display the original subdomain i.e officialanisa.mrcherry.co.uk
    domain mapping screen image

    i really dont understand why has happened, after it was working so well before.

    thanks for your help andrea i really appreciate it

    ive also just had all user permissions re-granted by my host ???

    Dunno if it helps anyone above or anybody looking ahead:

    Same problem as above, when creating a new MU/network site, tables are not created.

    Checked first the network plugins – only 3. Nope.

    Then I beat my head to check db permissions/quotas (even though those are never touched, but it seemed an obvious check) I turned to updates, updating WP3.1 to WP3.1.3, then the WordPress MU Domain Mapping from 0.5.3 to 0.5.4 on the suggestion of this thread. Nope.

    I don’t know the cause, but found the problem in a highly unsuspecting place: the newly installed/tested WordPress Simple Survey 2.0.3 plugin (root site-activated, not network-activated). I didn’t do any error debugging (bit drained after all that), but did find complaints about that plugin using generic/conflicting function calls.

    I went ahead and removed WordPress MU Domain Mapping and site-activated the WordPress Simple Survey – same problem, so in my case at least, had nothing to do with WordPress MU Domain Mapping.

    You may not have WordPress Simple Survey, but maybe this helps anyone who has another unsuspecting site-activated (non-network) plugin that is lacking with generic function calls.

    I have similar problem. Previously on 2.9.2 and upgraded to current version per instructions and without any problems. Created a new site and only 6 tables were created: wp_xx_terms, wp_xx_term_taxonomy, wp_xx_term_relationships, wp_xx_postmeta, wp_xx_options, and wp_xx_commentmeta. Tried everything that was posted here and had same results.

    Found a Fix to my missing tables problem.. hope this will help others!

    I just recalled a previous problem where my db (MySQL) would not take a date time value:’0000-00-00 00:00:00′ since it is in Strict mode. I found a fix from this forum about a year ago (https://www.ads-software.com/support/topic/mysql-5-stricttraditional-fix-requesting-feedback?replies=4) This fixed my problem ..again!

Viewing 14 replies - 46 through 59 (of 59 total)
  • The topic ‘DB tables for new subdomain site fail to get created’ is closed to new replies.