Database issues

sagai14
(@sagai14)

8 years, 3 months ago

wp_posts: Table ‘odishaassociation.wp_posts’ doesn’t exist
wp_comments: Table ‘odishaassociation.wp_comments’ doesn’t exist
wp_links: Table ‘odishaassociation.wp_links’ doesn’t exist
wp_options: Table ‘odishaassociation.wp_options’ doesn’t exist
wp_postmeta: Table ‘odishaassociation.wp_postmeta’ doesn’t exist
wp_terms: Table ‘odishaassociation.wp_terms’ doesn’t exist
wp_term_taxonomy: Table ‘odishaassociation.wp_term_taxonomy’ doesn’t exist
wp_term_relationships: Table ‘odishaassociation.wp_term_relationships’ doesn’t exist
wp_termmeta: Table ‘odishaassociation.wp_termmeta’ doesn’t exist
wp_commentmeta: Table ‘odishaassociation.wp_commentmeta’ doesn’t exist

The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

8 years, 3 months ago

If you have PHPMYADMIN installed, use it to view your database. Select all the tables and choose “check and repair” at the bottom.

If you do not have PHPMYADMIN installed, you can use mysqlcheck from the command line to check and repair your database. mysqlcheck -A --auto-repair

Thread Starter sagai14
(@sagai14)

8 years, 3 months ago

I did as you had suggested but i am still facing the problem. Please find below the entire error report

The wp_users table is okay.

The wp_usermeta table is okay.

The wp_posts table is not okay. It is reporting the following error: Table ‘oaug.wp_posts’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_posts table. Error: Table ‘oaug.wp_posts’ doesn’t exist

The wp_comments table is not okay. It is reporting the following error: Table ‘oaug.wp_comments’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_comments table. Error: Table ‘oaug.wp_comments’ doesn’t exist

The wp_links table is not okay. It is reporting the following error: Table ‘oaug.wp_links’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_links table. Error: Table ‘oaug.wp_links’ doesn’t exist

The wp_options table is not okay. It is reporting the following error: Table ‘oaug.wp_options’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_options table. Error: Table ‘oaug.wp_options’ doesn’t exist

The wp_postmeta table is not okay. It is reporting the following error: Table ‘oaug.wp_postmeta’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_postmeta table. Error: Table ‘oaug.wp_postmeta’ doesn’t exist

The wp_terms table is not okay. It is reporting the following error: Table ‘oaug.wp_terms’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_terms table. Error: Table ‘oaug.wp_terms’ doesn’t exist

The wp_term_taxonomy table is not okay. It is reporting the following error: Table ‘oaug.wp_term_taxonomy’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_term_taxonomy table. Error: Table ‘oaug.wp_term_taxonomy’ doesn’t exist

The wp_term_relationships table is not okay. It is reporting the following error: Table ‘oaug.wp_term_relationships’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_term_relationships table. Error: Table ‘oaug.wp_term_relationships’ doesn’t exist

The wp_termmeta table is not okay. It is reporting the following error: Table ‘oaug.wp_termmeta’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_termmeta table. Error: Table ‘oaug.wp_termmeta’ doesn’t exist

The wp_commentmeta table is not okay. It is reporting the following error: Table ‘oaug.wp_commentmeta’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_commentmeta table. Error: Table ‘oaug.wp_commentmeta’ doesn’t exist

Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

wp_posts: Table ‘oaug.wp_posts’ doesn’t exist
wp_comments: Table ‘oaug.wp_comments’ doesn’t exist
wp_links: Table ‘oaug.wp_links’ doesn’t exist
wp_options: Table ‘oaug.wp_options’ doesn’t exist
wp_postmeta: Table ‘oaug.wp_postmeta’ doesn’t exist
wp_terms: Table ‘oaug.wp_terms’ doesn’t exist
wp_term_taxonomy: Table ‘oaug.wp_term_taxonomy’ doesn’t exist
wp_term_relationships: Table ‘oaug.wp_term_relationships’ doesn’t exist
wp_termmeta: Table ‘oaug.wp_termmeta’ doesn’t exist
wp_commentmeta: Table ‘oaug.wp_commentmeta’ doesn’t exist

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

8 years, 3 months ago

I wrote

If you have PHPMYADMIN installed, use it to view your database. Select all the tables and choose “check and repair” at the bottom.

It appears you tried to repair from within WordPress. Please use phpmyadmin as noted.

claudiacecilia
(@claudiacecilia)

7 years, 11 months ago

Hi!

How did you fix the problem?

twilliamsa
(@twilliamsa)

7 years, 11 months ago

I’m also having the same issue. Tried to fix through PhpMyAdmin and also tried MySQL but no luck. Not sure what else to do. Can I just delete it if it states it does not exist?

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

7 years, 11 months ago

@twilliamsa, if you need support then per the forum welcome please create your own new forum post. Thanks.

aquib1995
(@aquib1995)

7 years, 11 months ago

Even I have the same issue and I tried repairing the tables but it didn’t work? Is there any other solution please let me know! @sterndata

aquib1995
(@aquib1995)

7 years, 11 months ago

The wp_users table is okay.

Failed to optimize the wp_users table. Error: Table does not support optimize, doing recreate + analyze instead

The wp_usermeta table is okay.

Failed to optimize the wp_usermeta table. Error: Table does not support optimize, doing recreate + analyze instead

The wp_posts table is not okay. It is reporting the following error: Table ‘thefengshui.wp_posts’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_posts table. Error: Table ‘thefengshui.wp_posts’ doesn’t exist

The wp_comments table is not okay. It is reporting the following error: Table ‘thefengshui.wp_comments’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_comments table. Error: Table ‘thefengshui.wp_comments’ doesn’t exist

The wp_links table is not okay. It is reporting the following error: Table ‘thefengshui.wp_links’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_links table. Error: Table ‘thefengshui.wp_links’ doesn’t exist

The wp_options table is not okay. It is reporting the following error: Table ‘thefengshui.wp_options’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_options table. Error: Table ‘thefengshui.wp_options’ doesn’t exist

The wp_postmeta table is not okay. It is reporting the following error: Table ‘thefengshui.wp_postmeta’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_postmeta table. Error: Table ‘thefengshui.wp_postmeta’ doesn’t exist

The wp_terms table is not okay. It is reporting the following error: Table ‘thefengshui.wp_terms’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_terms table. Error: Table ‘thefengshui.wp_terms’ doesn’t exist

The wp_term_taxonomy table is not okay. It is reporting the following error: Table ‘thefengshui.wp_term_taxonomy’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_term_taxonomy table. Error: Table ‘thefengshui.wp_term_taxonomy’ doesn’t exist

The wp_term_relationships table is not okay. It is reporting the following error: Table ‘thefengshui.wp_term_relationships’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_term_relationships table. Error: Table ‘thefengshui.wp_term_relationships’ doesn’t exist

The wp_termmeta table is not okay. It is reporting the following error: Table ‘thefengshui.wp_termmeta’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_termmeta table. Error: Table ‘thefengshui.wp_termmeta’ doesn’t exist

The wp_commentmeta table is not okay. It is reporting the following error: Table ‘thefengshui.wp_commentmeta’ doesn’t exist. WordPress will attempt to repair this table…
Failed to repair the wp_commentmeta table. Error: Table ‘thefengshui.wp_commentmeta’ doesn’t exist

Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

wp_posts: Table ‘thefengshui.wp_posts’ doesn’t exist
wp_comments: Table ‘thefengshui.wp_comments’ doesn’t exist
wp_links: Table ‘thefengshui.wp_links’ doesn’t exist
wp_options: Table ‘thefengshui.wp_options’ doesn’t exist
wp_postmeta: Table ‘thefengshui.wp_postmeta’ doesn’t exist
wp_terms: Table ‘thefengshui.wp_terms’ doesn’t exist
wp_term_taxonomy: Table ‘thefengshui.wp_term_taxonomy’ doesn’t exist
wp_term_relationships: Table ‘thefengshui.wp_term_relationships’ doesn’t exist
wp_termmeta: Table ‘thefengshui.wp_termmeta’ doesn’t exist
wp_commentmeta: Table ‘thefengshui.wp_commentmeta’ doesn’t exist

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

7 years, 11 months ago

@aquib1995, if you need support then per the forum welcome please create your own new forum post. Thanks.