new user stays blank

  • Resolved feibuergerenergie

    (@feibuergerenergie)


    2 months, 4 weeks ago

    Hi folks,

    to be able to grant support agents temporary access to the (staging) site, I need (urgently) to add at least one more WP user. If I add one, the action is confirmed as successful. The new user doesn’t show up with the prior entered data but blank in the users list in WP, though. If I view/edit the user, my own (admin user) credentials appear instead of the new ones. In the database, I can see, the user’s got the ID 0, though the next ID would be 7.
    What can I do about it?

    Thx a lot for any hint
    Franz
    WP 6.5.4

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

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

    (@sterndata)

    Volunteer Forum Moderator

    This may indicate a corrupt database, at least in the wp_users table. Using PHPMYADMIN, try repairing that table. PHPMYADMIN is part of your hosting package.

    Thread Starter feibuergerenergie

    (@feibuergerenergie)

    Thank you for the quick reply!
    Well, I managed to delete the user with ID 0. That doesn’t help too much for the next intent, of course.
    What exactly do you mean with “reparing”?
    I roughly know how to survive in phpMyAdmin (and WebFTP and SQL language), basically, but what am I supposed to do …

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    https://www.thoughtco.com/repairing-mysql-database-with-phpmyadmin-2693966

    Thread Starter feibuergerenergie

    (@feibuergerenergie)

    Thanks.
    I get the result OK for all tables!
    I analyze the tables, some get “table is already up to date”, and some OK (like the users table).

    I tried optimize and repair, however. Both are not supported by (this) users table (and several others in the DB)!

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    There should be a field for that table that shows the next ID to be used. Set it to some number larger than the largest ID in that table.

    Thread Starter feibuergerenergie

    (@feibuergerenergie)

    [Without having seen your screen shot before writing and doing this:]
    Dunno where such a field may be hidden. I found the “A I” (auto increment) option and ticked it, however. And now it works perfectly.
    Solved!
    Thanks a lot anyways!!

Viewing 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.