WP error ‘Could not insert post into the database’
-
Need to know how to fix this error we get when clicking the “Add New Episode” button.
Error: ‘Could not insert post into the database’
-
Support said… Thanks for contacting us and sorry you’re having trouble here.
- Have you added any custom filters recently?
- Are you able to create regular posts?
- do you have any errors in the PHP debug log?
- have any plugins been recently installed or updated, or versions of WordPress?
I was able to confirm that this happens on Podcasting → Add New Episode
I see I get the error on new Posts, too.
I will check on the log…
Yes, we have updated all plugins to their latest, Don’t believe we have updated WP itself since before this was not an issue. Running WP 7.0 …log shows…
WordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]
INSERT INTO 21DtDSD_actionscheduler_actions (hook,status,scheduled_date_gmt,scheduled_date_local,schedule,group_id,priority,args) SELECT 'action_scheduler_run_recurring_actions_schedule_hook', 'pending', '2026-07-07 15:43:11', '2026-07-07 15:43:11', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1783438991;s:18:\"\0*\0first_timestamp\";i:1783438991;s:13:\"\0*\0recurrence\";i:86400;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1783438991;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:86400;}', 3, 20, '[]' FROM DUAL WHERE ( SELECT NULL FROM DUAL ) IS NULLWordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]
INSERT INTO 21DtDSD_actionscheduler_actions (hook,status,scheduled_date_gmt,scheduled_date_local,schedule,group_id,priority,args) SELECT 'action_scheduler/migration_hook', 'pending', '2026-07-07 15:44:12', '2026-07-07 15:44:12', 'O:30:\"ActionScheduler_SimpleSchedule\":2:{s:22:\"\0*\0scheduled_timestamp\";i:1783439052;s:41:\"\0ActionScheduler_SimpleSchedule\0timestamp\";i:1783439052;}', 1, 10, '[]' FROM DUAL WHERE ( SELECT NULL FROM DUAL ) IS NULLWordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]
INSERT INTO 21DtDSD_actionscheduler_actions (hook,status,scheduled_date_gmt,scheduled_date_local,schedule,group_id,priority,args) SELECT 'publishpressfuture_check_expired_actions', 'pending', '2026-07-07 15:43:12', '2026-07-07 15:43:12', 'O:32:\"ActionScheduler_IntervalSchedule\":5:{s:22:\"\0*\0scheduled_timestamp\";i:1783438992;s:18:\"\0*\0first_timestamp\";i:1783438992;s:13:\"\0*\0recurrence\";i:86400;s:49:\"\0ActionScheduler_IntervalSchedule\0start_timestamp\";i:1783438992;s:53:\"\0ActionScheduler_IntervalSchedule\0interval_in_seconds\";i:86400;}', 2, 10, '[]' FROM DUAL WHERE ( SELECT NULL FROM DUAL ) IS NULLWordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]
INSERT INTO21DtDSD_posts(post_author,post_date,post_date_gmt,post_content,post_content_filtered,post_title,post_excerpt,post_status,post_type,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_parent,menu_order,post_mime_type,guid) VALUES (1, '2026-07-07 08:43:12', '0000-00-00 00:00:00', '', '', 'Auto Draft', '', 'auto-draft', 'podcast', 'open', 'closed', '', '', '', '', '2026-07-07 08:43:12', '0000-00-00 00:00:00', 0, 0, '', '')Could not insert post into the database.
Found this article… Was an issue with the Auto Increment setting in the tables shown in the errors above.
Posts now work!
Well… now they do not update or save…
“Updating failed. The response is not a valid JSON response.”
ugh…
You must be logged in to reply to this topic.