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
-
and when I go to new site i see:
https://www.example.com/test1
Error establishing a database connectionwhen i go to https://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 existanybody 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)database user have full access.
Full as in ALL permissions? ??
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
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
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_commentmetam0n085 – 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.
- The topic ‘wpmu does not create a table in database’ is closed to new replies.