From your host’s control panel, go to PHPMYADMIN. Find the two tables wp_users and wp_usermeta. Check them and at the bottom, where it says “with checked” choose “check” or “check and repair”. See if that fixes it.
I have found no check or check and repair option. However, I added two new users directly into the database in wp_users and that solves the problem for now, thank you very much. When I try to add a new user in the dashboard it still gives me the message ‘new user created’ with no user added, redirecting me to wp-admin/users.php?id=0 For some reason it gives id=0 and I don’t know how to fix it. When I manually added the users I gave them ids 2 and 3 respectively and they work fine. Is there a fix for that wrong id attribution?
>> added two new users directly into the database in wp_users <<
You’re probably creating more problems doing that. Don’t.
https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin
Oh I see… I was in wp_users that is why I hadn’t found the ‘check’ and ‘repair’ option. So ok, I followed your instructions and checked the tables, their status was ‘OK’. After hiting ‘repair’ I got a message ‘The storage engine for the table doesn’t support r…’. After a few trials in the dashboard, I saw that every new user is attributed id=0, which is already in use by a blank user and opens MY user (that has id=1). If I delete the user with id=0 then after ‘add new user’ a new blank user appears and editing it brings my user again.
Anyway, this is far beyond my understanding and your very kind help with the tip to check my wp_users table has solved my problem. My new users work perfectly, I can edit them and everything is perfect. I can’t thank you enough for your accurate and immediate response!
