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.remarpro.com that write to put the primary key in auto increment,

2)Issue with Primary key duplicate entries on all wp_meta table | www.remarpro.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

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.

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

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

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, 2 months ago by giorgiopeschier. Reason: Put other rows to detail the problem/test made

Hi, i’ve translated some strings…but there are some parts that i would like to share to you because i suppose they are incorrect. How can i upload an image from my computer? Many Thanks