Missing ID in table

fix missing auto-increment IDs in a database table.

Overview

The issue is caused by MySQL server problems that disrupt the auto-increment sequence.
Contact your server administrator to check and repair the MySQL database to restore normal numbering.

Answered
ChronoForms v5
te tempus 14 Jul, 2017
Hi

My form saves records to the table, but auto-increment field (id) has missing numbering (1,2,3,6,7,8,11,12...).
I have no deletion actions in this form. How can it be? And how to solve? I need normal numbering in the id field.

Thank you!
Max_admin Max_admin 23 Aug, 2017
Hi tempus,

Was the table modified by any other program ? it does not have to be the form itself!

Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
te tempus 23 Aug, 2017
Answer
1 Likes
Hi🙂

Table was modified only with chronoforms, and there were no deleting actions.
Server admin told me that there were problems with MySQL. He fixed.

Thank you
This topic is locked and no more replies can be posted.