ID skipping

  • Resolved jessicaib

    (@jessicaib)


    2 years ago

    hi, formanitor submission ID numbers are skipping instead of going after each number for example it’ll go 200, 201 then skip to 204,205,206 etc and does it randomly. We only have 1 form so there’s no possibility of ID allocated in other form submission. How can we fix this issue?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Kris – WPMU DEV Support

    (@wpmudevsupport13)

    Hi @jessicaib

    I hope you are doing well today.

    If there is no other forms on site, then this should not happen. The only valid explanation in this case will be that you have Polls or Quizzes as well, and those take those IDs. Please note this is expected behavior as submissions are stored in same table in database.

    Kind Regards,
    Kris

    Thread Starter jessicaib

    (@jessicaib)

    hi Kris,

    I have checked there’s no polls or quizzes. only a single form on the site. Can your team look into this? how can we fix this issue?

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @jessicaib

    Thank you for the update.

    Do you have access to the database for example using PHPmyAdmin?

    If so, can you navigate to the table PREFIX_frmt_form_entry ( replace the PREFIX_ with your prefix ) and then check if the order is correct there and if it matches the sequence + form ID?

    https://monosnap.com/file/6HKdIAfcTjrH6G9HMF1h6T1vsORgd6

    Also, check if you see the same gaps there.

    Let us know the result you got looking at the database.
    Best Regards
    Patrick Freitas

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @jessicaib ,

    We haven’t heard from you for some time now, so it looks like you don’t require our further assistance.

    Feel free to re-open this ticket if needed.

    Kind regards
    Kasia

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘ID skipping’ is closed to new replies.