WordPress.org

Support

Support » Multisite » [Resolved] wpmu does not create a table in database

[Resolved] wpmu does not create a table in database

  • Hi

    I just install wp and crate a network. When i want to create a new site (in subdir) wpmu does not create any tables (ex. podk_4_options)for new sites, but add info about new sites in podk_blogs

    Database user have all grants

Viewing 15 replies - 1 through 15 (of 15 total)
  • and when I go to new site i see:
    http://www.example.com/test1
    Error establishing a database connection

    when i go to http://www.example.com/test1/wp-admin and repair databse

    podk_4_posts: Table ‘web13db9.podk_4_posts’ doesn’t exist
    podk_4_comments: Table ‘web13db9.podk_4_comments’ doesn’t exist
    podk_4_links: Table ‘web13db9.podk_4_links’ doesn’t exist
    podk_4_options: Table ‘web13db9.podk_4_options’ doesn’t exist
    podk_4_postmeta: Table ‘web13db9.podk_4_postmeta’ doesn’t exist
    podk_4_terms: Table ‘web13db9.podk_4_terms’ doesn’t exist
    podk_4_term_taxonomy: Table ‘web13db9.podk_4_term_taxonomy’ doesn’t exist
    podk_4_term_relationships: Table ‘web13db9.podk_4_term_relationships’ doesn’t exist
    podk_4_commentmeta: Table ‘web13db9.podk_4_commentmeta’ doesn’t exist

    anybody can pass me structure for this tables?

    If WordPress isn’t creating your tables, then there’s somethign wrong with your setup.

    Before you go ANY further, turn off ALL plugins.

    1) I know you said “Database user have all grants” but double check šŸ™‚ Remember, you need to make sure the ID listed in wp-config.php is the one with full access. Go the extra step and ask your host to check too, since sometimes they cripple you.

    2) What’s your database prefix (as defined in wp-config.php)?

    hi
    my prefix is “podk_”
    database user have full access.
    I host on my server (ubuntu server, apache2, php5, mysql)

    Andrea Rennick

    @andrea_r

    Customer Care at Copyblogger Media and Studiopress

    database user have full access.

    Full as in ALL permissions? šŸ™‚

    check:

    Did you turn off all plugins?

    when i turn off all plugin and i want to create new site, on site page i have “Error establishing a database connection” and on admin panel for new site i have repair databse and:

    (sory for my langue)

    The podk_users table is okay.
    
    The podk_usermeta table is okay.
    
    The podk_6_posts table is not okay. It is reporting the following error: Table 'web13db9.podk_6_posts' doesn't exist. WordPress will attempt to repair this tableā€¦
        Failed to repair the podk_6_posts table. Error: Table 'web13db9.podk_6_posts' doesn't exist
    
    The podk_6_comments table is not okay. It is reporting the following error: Table 'web13db9.podk_6_comments' doesn't exist. WordPress will attempt to repair this tableā€¦
        Failed to repair the podk_6_comments table. Error: Table 'web13db9.podk_6_comments' doesn't exist
    
    The podk_6_links table is not okay. It is reporting the following error: Table 'web13db9.podk_6_links' doesn't exist. WordPress will attempt to repair this tableā€¦
        Failed to repair the podk_6_links table. Error: Table 'web13db9.podk_6_links' doesn't exist
    
    The podk_6_options table is not okay. It is reporting the following error: Table 'web13db9.podk_6_options' doesn't exist. WordPress will attempt to repair this tableā€¦
        Failed to repair the podk_6_options table. Error: Table 'web13db9.podk_6_options' doesn't exist
    
    The podk_6_postmeta table is not okay. It is reporting the following error: Table 'web13db9.podk_6_postmeta' doesn't exist. WordPress will attempt to repair this tableā€¦
        Failed to repair the podk_6_postmeta table. Error: Table 'web13db9.podk_6_postmeta' doesn't exist
    
    The podk_6_terms table is not okay. It is reporting the following error: Table 'web13db9.podk_6_terms' doesn't exist. WordPress will attempt to repair this tableā€¦
        Failed to repair the podk_6_terms table. Error: Table 'web13db9.podk_6_terms' doesn't exist
    
    The podk_6_term_taxonomy table is not okay. It is reporting the following error: Table 'web13db9.podk_6_term_taxonomy' doesn't exist. WordPress will attempt to repair this tableā€¦
        Failed to repair the podk_6_term_taxonomy table. Error: Table 'web13db9.podk_6_term_taxonomy' doesn't exist
    
    The podk_6_term_relationships table is not okay. It is reporting the following error: Table 'web13db9.podk_6_term_relationships' doesn't exist. WordPress will attempt to repair this tableā€¦
        Failed to repair the podk_6_term_relationships table. Error: Table 'web13db9.podk_6_term_relationships' doesn't exist
    
    The podk_6_commentmeta table is not okay. It is reporting the following error: Table 'web13db9.podk_6_commentmeta' doesn't exist. WordPress will attempt to repair this tableā€¦
        Failed to repair the podk_6_commentmeta table. Error: Table 'web13db9.podk_6_commentmeta' doesn't exist
    
    The podk_blogs table is okay.
    
    The podk_signups table is okay.
    
    The podk_site table is okay.
    
    The podk_sitemeta table is okay.
    
    The podk_registration_log table is okay.
    
    The podk_blog_versions table is okay.
    
    podk_6_posts: Table 'web13db9.podk_6_posts' doesn't exist
    podk_6_comments: Table 'web13db9.podk_6_comments' doesn't exist
    podk_6_links: Table 'web13db9.podk_6_links' doesn't exist
    podk_6_options: Table 'web13db9.podk_6_options' doesn't exist
    podk_6_postmeta: Table 'web13db9.podk_6_postmeta' doesn't exist
    podk_6_terms: Table 'web13db9.podk_6_terms' doesn't exist
    podk_6_term_taxonomy: Table 'web13db9.podk_6_term_taxonomy' doesn't exist
    podk_6_term_relationships: Table 'web13db9.podk_6_term_relationships' doesn't exist
    podk_6_commentmeta: Table 'web13db9.podk_6_commentmeta' doesn't exist
    Andrea Rennick

    @andrea_r

    Customer Care at Copyblogger Media and Studiopress

    Can’t repair tables that don’t exist. Start reading server logs to see why it’s not creating new tables.

    i don’t see in server logs anything interesting

    Andrea Rennick

    @andrea_r

    Customer Care at Copyblogger Media and Studiopress

    Just verify for me how you’re creating a new site. Super Admin -> Sites -> Add New, yes?

    anybody can pass me sql structure for this tables:

    podk_4_posts
    podk_4_comments
    podk_4_links
    podk_4_options
    podk_4_postmeta
    podk_4_terms
    podk_4_term_taxonomy
    podk_4_term_relationships
    podk_4_commentmeta

    m0n085 – They’re the same as the tables sans the 4_ in the name, but that’s not going to help you solve the problem.

    my database was corrupted, I created a new and everything is ok

    m0n085, do you mean you started completely over with a new install> I’m asking because I have your symptoms, but I cannot start over.

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘[Resolved] wpmu does not create a table in database’ is closed to new replies.
Skip to toolbar