• 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

    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)

    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)

    (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

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

    Thread Starter cityjohn

    (@cityjohn)

    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

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

    Thread Starter cityjohn

    (@cityjohn)

    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

    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)

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

    Thread Starter cityjohn

    (@cityjohn)

    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

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

    Thread Starter cityjohn

    (@cityjohn)

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.