WordPress.org

1. Davenow
   Member
   Posted 1 year ago #

   Hi

   I was uploading a new theme and got a message stating that: Error establishing a database connection and went on to repair the tables by adding a line of code to the wp-config file and ran the repair database script, the results are below:

   wp_users: Table 'web126-a-wor-829.wp_users' doesn't exist
   wp_usermeta: Table 'web126-a-wor-829.wp_usermeta' doesn't exist
   wp_7_posts: Table 'web126-a-wor-829.wp_7_posts' doesn't exist
   wp_7_comments: Table 'web126-a-wor-829.wp_7_comments' doesn't exist
   wp_7_links: Table 'web126-a-wor-829.wp_7_links' doesn't exist
   wp_7_options: Table 'web126-a-wor-829.wp_7_options' doesn't exist
   wp_7_postmeta: Table 'web126-a-wor-829.wp_7_postmeta' doesn't exist
   wp_7_terms: Table 'web126-a-wor-829.wp_7_terms' doesn't exist
   wp_7_term_taxonomy: Table 'web126-a-wor-829.wp_7_term_taxonomy' doesn't exist
   wp_7_term_relationships: Table 'web126-a-wor-829.wp_7_term_relationships' doesn't exist

   Does anyone know how fix this as I cant login to the backend.

   Cheers

2. pkenjora
   Member
   Posted 1 year ago #

   In your config file there is a prefix you can set for all the databases tables. It defaults to wp_. If you made a change to the prefix all your tables will look like they are missing. Change it back to the default.

   If you log into the database and do a:

   use web126-a-wor-829;
   show tables;

   Do the tables above exist?

   1. If no, then try restoring the DB from a backup or unfortunately you have to start over.
   2. If yes but they are named wrong change your prefix to match.

3. Davenow
   Member
   Posted 1 year ago #

   Cheers for that unfortunately I haven't done a backup again, keep on forgetting to do that - looks like I will learn my lesson :)

Topic Closed

This topic has been closed to new replies.