WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]

  • cityjohn

    (@cityjohn)


    6 years, 1 month ago

    I’m getting a strange error while trying to register on my website that looks like this:

    WordPress database error: [Table 'wp_Dest.wp_users' doesn't exist]
INSERT INTO <code>wpDusers</code> (<code>user_pass</code>, <code>user_nicename</code>, <code>user_email</code>, <code>user_url</code>, <code>user_registered</code>, <code>user_activation_key</code>, <code>display_name</code>, <code>user_login</code>) VALUES ('$P$BGyqjbeHyWXxBWUvokHoOUjaQ780hg0', 'leerling', '[email protected]', '', '2020-04-04 13:27:34', '', 'leerling', 'leerling')

    I admit I used a really shitty plugin to change my table prefix and then had to change it back because my website was showing the installation again but everything works except this.

    The weird thing is that when I changed it from wpD to wp_ It gave an error that wpD didn’t exist, and now that I changed it back to wpD it gives the error that wp_users doesnt exist… what the heck is going on?

Viewing 12 replies - 1 through 12 (of 12 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 1 month ago

    Look at your database using PHPMYADMIN. Does the table exist?

    Why did you feel the need to change your table prefix? When you look at your DB with PHPMYADMIN, are the prefixes consistent and do they match the prefix set in wp-config.php?

    Thread Starter cityjohn

    (@cityjohn)

    6 years, 1 month ago

    Well as I mentioned I changed the prefix with a plugin from wpD to wp_, which returned the error that wpD doesn’t exist which was correct even though config.php CLEARLY had the prefix wp_ set. Then I changed it back and the error it gave was that wp_ didn’t exist which is also true although the config.php CLEARLY had wpD as a prefix.

    I thought it was a server caching issue so I waited a while after which I was able to register a user. Then I thought my problems were over but 5 minutes later I got this error:

    WordPress database error: [Unknown column ‘wpdusers.ID’ in ‘field list’]

    Now this table does exist 100%, I’m looking at it now.

    Thread Starter cityjohn

    (@cityjohn)

    6 years, 1 month ago

    (I wanted to change the prefix because I’m building an application on top of wordpress and I need my own tables so I wanted to clean up the messy prefix.)

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 1 month ago

    Make sure that the prefix is consisent across all tables and matches wp-config.php.

    Thread Starter cityjohn

    (@cityjohn)

    6 years, 1 month ago

    Jep, checked the entire database, they all match the prefix set in config. I’m quite astounded by the register form wanting to send something to the wrong table that doesn’t exist.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 1 month ago

    It may be that the table wp_users is corrupt. Use phpmyadmin to repair it.

    Thread Starter cityjohn

    (@cityjohn)

    6 years, 1 month ago

    Hmm I got this error:

    “The storage engine for the table doesn’t support r…”

    I don’t know if it matters but I have only 2 registered admins.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 1 month ago

    That’s fine. That’s just advisory.

    Let’s review.

    EVERY SINGLE TABLE in the database starts with “wp_”, as in “wp_posts”, “wp_postmeta”, etc.?

    The table prefix set in wp-config.php is “wp_”.

    Correct?

    Thread Starter cityjohn

    (@cityjohn)

    6 years, 1 month ago

    No no, every one of them right now starts with ‘wpD’, and the prefix set in config.php is ‘wpD’.

    Thread Starter cityjohn

    (@cityjohn)

    6 years, 1 month ago

    Wait no that’s not correct, I have a plugin called WPdatatables that makes its own tables without a the wpD prefix and simple uses wp.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 1 month ago

    That’s wrong. ALL tables for a given site MUST have the same prefix.

    Thread Starter cityjohn

    (@cityjohn)

    6 years, 1 month ago

    Ok, I’ve told them.

    https://ww.wp.xz.cn/support/topic/database-prefix-missing-in-tables/#new-topic-0

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

The topic ‘WordPress database error: [Table ‘wp_Dest.wp_users’ doesn’t exist]’ is closed to new replies.