How to solve Duplicate entry '0' for key 'PRIMARY' in Wordpress?

Question

my website running perfect but today 1 order is placed by the customer, and I am getting this error in my website.

Here is the screenshot of error

error is here.. Fatal error: Uncaught RuntimeException: Error saving action: Error saving action: Duplicate entry '0' for key 'PRIMARY' in /home/website/public_html/wp-content/plugins/woocommerce/packages/action-scheduler/classes/migration/ActionScheduler_DBStoreMigrator.php:44

Which parts of that error message are unclear? What have you tried to resolve that problem? — Nico Haase, Aug 25 '20 at 10:02

score 7 · Accepted Answer · answered Aug 25 '20 at 10:00

7

Go to table structure and then hover on More option in front of id field and then click on primary key. Here is screenshot

if problem still there after doing this then click on change in front of id field and check the A.I checkbox

Here is screenshot

answered Aug 25 '20 at 10:00

Subhan Khalid

156
4

when I am activating `woocommerce` plugin, then I am getting those errors – GCP Bukalo Aug 25 '20 at 11:24
Did you try the solution i mentioned above? – Subhan Khalid Aug 25 '20 at 11:28
what i mentioned above, you have to do with all tables manually. Otherwise you can try to re-install wordpress. but before doing this, try once the solution i mentioned. – Subhan Khalid Aug 25 '20 at 11:30
i tried but that's not working...getting same error – GCP Bukalo Aug 25 '20 at 11:44
did you implement for all tables? – Subhan Khalid Aug 25 '20 at 11:50
No, I implement only for 1 table, I am implementing this on all tables – GCP Bukalo Aug 25 '20 at 11:59
I am getting this issue in one table...Please check the screenshot.... `https://prnt.sc/u5jqn7` and `log_id` is different here `https://prnt.sc/u5jrqe` and after some records `log_id` is `0` ..`https://prnt.sc/u5jsj7` – GCP Bukalo Aug 25 '20 at 12:12
i think this table hasn't defined any primary key column. did your old issue resolved? – Subhan Khalid Aug 25 '20 at 12:15
How many tables remaining haven't implemented the solution i mentioned above? – Subhan Khalid Aug 25 '20 at 12:22
yes, I implement but 2 table showing `Duplicate entry '0' for key 'PRIMARY'` – GCP Bukalo Aug 25 '20 at 12:29
you have to make them same. each table should have primary key working with Auto Increament – Subhan Khalid Aug 25 '20 at 12:35
This saved the day for me, in my case the ID was named action_id and when I checked the AI option, everything seems to be working well again – Blu3 Feb 24 '22 at 09:00

score 2 · Answer 2 · edited May 05 '22 at 17:42

2

Error resolved when I changed id=0 to id=1 in

actionscheduler_actions

table.

edited May 05 '22 at 17:42

cigien

57,834
11
73
112

answered May 05 '22 at 16:38

Samet. Smile

21
3

How to solve Duplicate entry '0' for key 'PRIMARY' in Wordpress?

2 Answers2