[Duplicate entry ‘0’ for key ‘PRIMARY’]

  • Resolved thewebalchemist

    (@thewebalchemist)


    1 year, 9 months ago

    Just went in to sort an issue with this and noticed the redirect to /space-estimator/quote is no longer working. Checked the back end of the form and the entire redirect sequence is empty. There were previously a number of field values passed through the URL which are no longer present in the settings.

    When trying to save the form, I also get an error message as stated below:

    WordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]
    INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES (362, 'external_url', '')

    WordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]
    INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES (362, 'http_build_query_selectively', 'on')

    WordPress database error: [Duplicate entry ‘0’ for key ‘PRIMARY’]
    INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES (362, 'http_build_query_selectively_fields', 'choose-your-location,chosen-size,storage-duration,start-date')

    WordPress database error:?[Duplicate entry ‘0’ for key ‘PRIMARY’]
    INSERT INTO wp_postmeta (post_id, meta_key, meta_value) VALUES (362, 'delay_redirect_seconds', '')

    This was working perfectly on 5th Jan, and no changes have been made directly to the form. Plugins relating to this issue haven’t been touched since August 2022.

    Any help much appreciated!

    CF7 version 5.5.6
    CF7 Redirect version 2.7.0
    WP Core version 5.8.6

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

Viewing 1 replies (of 1 total)

  • Sorry but it looks like a problem on your db that does not relate to this plugin.

    It looks like your DB table lost its auto-increment and is always trying to insert a new record with “0” index – you can find more information about that on a simple google search

Viewing 1 replies (of 1 total)
  • The topic ‘[Duplicate entry ‘0’ for key ‘PRIMARY’]’ is closed to new replies.