Cant login to my site – Problem with the users table

  • 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

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

  • 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.
    Thread Starter Davenow

    (@davenow)

    Cheers for that unfortunately I haven’t done a backup again, keep on forgetting to do that – looks like I will learn my lesson ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Cant login to my site – Problem with the users table’ is closed to new replies.