• 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’

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter ffusion

    (@ffusion)

    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

    Thread Starter ffusion

    (@ffusion)

    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 …

    Thread Starter ffusion

    (@ffusion)

    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 NULL

    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/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 NULL

    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 '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 NULL

    WordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]
    INSERT INTO 21DtDSD_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.

    Thread Starter ffusion

    (@ffusion)

    Found this article… Was an issue with the Auto Increment setting in the tables shown in the errors above.

    https://www.malcare.com/blog/wordpress-database-error-duplicate-entry-0-for-key-primary-error-9-steps/

    Posts now work!

    Thread Starter ffusion

    (@ffusion)

    Well… now they do not update or save…

    “Updating failed. The response is not a valid JSON response.”

    ugh…

    Thread Starter ffusion

    (@ffusion)

    Also reaching out to hosting server support.

Viewing 6 replies - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.