WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] wpmu does not create a table in database (16 posts)

  1. m0n085
    Member
    Posted 3 years ago #

    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

  2. m0n085
    Member
    Posted 3 years ago #

    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

  3. m0n085
    Member
    Posted 3 years ago #

    anybody can pass me structure for this tables?

  4. 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)?

  5. m0n085
    Member
    Posted 3 years ago #

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

  6. database user have full access.

    Full as in ALL permissions? :)

  7. m0n085
    Member
    Posted 3 years ago #

    check:

  8. Did you turn off all plugins?

  9. m0n085
    Member
    Posted 3 years ago #

    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
  10. Can't repair tables that don't exist. Start reading server logs to see why it's not creating new tables.

  11. m0n085
    Member
    Posted 3 years ago #

    i don't see in server logs anything interesting

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

  13. m0n085
    Member
    Posted 3 years ago #

    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

  14. 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.

  15. m0n085
    Member
    Posted 3 years ago #

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

  16. fredhag
    Member
    Posted 3 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags