• Hi, i have problem that i cannot add user from wp-amin panel and/or using the /myaccount page to create a new user. For example when i use the Add Account button and i put all data (name, surnema, username, email, etc.), after i click add user, i get response the user is create, but the user is not see in the user list page, the number of users remain the same, the user doesn’t receive the email and i, as administrator, receive that a new user is registered but the username and the email are blanks.

    I download the health check & troubleshooting plugin and i run the diagnostic. Also if all plugins are disabled i get the same problem.

    Please can you help me? Many thanks.

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

Viewing 8 replies - 1 through 8 (of 8 total)
  • Hi,
    /myaccount is not a native WordPress page. Are you using a plugin for membership or user management? If so, which one? Email sending is another issue but not related to the user creation problem. If you as the administrator are receiving emails then the problem could be that you do not have the proper DNS for email. In addition to MX, you should also have an SPF TXT record, DKIM and ideally a DMARC record.

    I recommend contacting your web host about DNS configuration.

    Thread Starter giorgiopeschier

    (@giorgiopeschier)

    Hi,

    as i wrote, the same problem is using wp-admin panel and i attempt to add a new account. When i add the user (the email is my email where i receive all message from my site), i get the response that a new user is added, but the user is not seen in the account list. The user is not created. The site automatically send to the administrator email that say a nuew user is registered, but in the object the email and the user name are blank.

    Another thing, i install healht check & troubleshooting plugin and i put my site in diagnostic mode with plugin disabled… i get the same problem. the user wasn’t created.

    Is not an email problem, is a problem that i cannot add users to my site.

    Many Thanks

    • This reply was modified 1 year, 1 month ago by giorgiopeschier. Reason: Put other rows to detail the problem/test made

    Have you tried testing with all plugins disabled AND a default theme activated (e.g. Twenty-Twenty-Two)?

    try looking in the error log files if you have access. You can also look in the user table of your database to see if anything was created.

    Thread Starter giorgiopeschier

    (@giorgiopeschier)

    to @pidengmor: yes when i used Health Check & troubleshooting, it downloaded the Twenty Twenty-three theme and in diagnostic mode i use this theme.

    Thread Starter giorgiopeschier

    (@giorgiopeschier)

    to @mrtom414 : I used wP-phpMyAdmin to see the db tables… under wpxxx_users the user that i would like to create doesn’t exist. I also found a db table wpxxx_users_xx (that seems a copy of the wpxxx_users) and there is not the account.

    I don’t know how to view the error log files. Can you help me and the tables i have seen are correct?

    Many Thanks

    Thread Starter giorgiopeschier

    (@giorgiopeschier)

    Maybe I found the problem/bug. I enabled debugging with the debug log manager plugin. When I tried to create the user I got the error: “Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp893_users (user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, display_name, user_login) VALUES (‘$P$BWJmatThzeWGrCiSStryPT3HH69iLr0’, ‘abbaqueen’, ‘[email protected]’, ”, ‘2023-09-30 08:57: 22’, ”, ‘abba queen’, ‘Abbaqueen’) made by edit_user, wp_insert_user”. With the WP-phpMyAdmin tool, I deleted the record with ID 0 and created a new user, the record in the DB was created with ID 0, if I go to the users page I think the account exists but nothing is displayed (alla the fileds are blank). If I then try to create another user, I get the same error as Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO `wp893_users’ again. So at this point I assume that the problem is due to the fact that it always wants to enter the account with Primary Key ID at 0. Another thing, in the DB I find 284 rows, while in the wp-admin\account page the users are 283 Thank you for all the support you can give me.

    Thread Starter giorgiopeschier

    (@giorgiopeschier)

    Hi, i resolve my problem. I detail the resolution for other users that eventually get the same problem. I found 2 posts:

    1)wp_actionscheduler_logs – Duplicate entry ‘0’ for key ‘PRIMARY’ | www.ads-software.com that write to put the primary key in auto increment,

    2)Issue with Primary key duplicate entries on all wp_meta table | www.ads-software.com another link that route to New Zealand Go Online | How to Fix: WordPress database error Duplicate entry ‘0’ for key ‘PRIMARY’ for query INSERT INTO wp_usermeta – New Zealand Go Online that show how to put to A.I. (Auto Increment)

    At first time i get error #1062 – ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ‘1’ for key ‘PRIMARY’ so i cannot put the ID in Automatic Increment. This was due becaus i have a record that have a PK ID with value 0.

    I deleted the record, i redo the commando to set the autoincrement and the alter tables works right.

    I create a new user and finally i see the user in the table and in the wp-admin panel and received the correct confirmation email of the new user.

    You can put this post as resolved.

    Thanks to all

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Add New User’ is closed to new replies.